110,538
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// oracle数据库操作
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public int oracleExecuteNonQuery(string sql)
{
using (OracleConnection conn = new OracleConnection(ConnString))
{
conn.Open();
using (OracleCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
int i = cmd.ExecuteNonQuery();
return i;
}
}
}
/// <summary>
/// 增加数据
/// </summary>
/// <param name="tableName"></param>
public void Add(string tableName)
{
string sql = "select * from " + tableName;
DataSet ds = db.sqlTableShow(sql);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
model.IDVOLUME = Int32.Parse(ds.Tables[0].Rows[i]["IDVolume"].ToString());
model.IDARCHIVE = long.Parse(ds.Tables[0].Rows[i]["IDArchive"].ToString());
model.ARCHIVEID = ds.Tables[0].Rows[i]["ArchiveID"].ToString();
model.DUTYMAN = ds.Tables[0].Rows[i]["DutyMan"].ToString();
if (ds.Tables[0].Rows[i]["Title"].ToString().Contains("'"))
{
model.TITLE = ds.Tables[0].Rows[i]["Title"].ToString().Replace("'", "吋");
}
else
{
model.TITLE = ds.Tables[0].Rows[i]["Title"].ToString();
}
model.GOTTIME = Convert.ToDateTime((Convert.ToDateTime(ds.Tables[0].Rows[i]["GotTime"])).ToString("yyyy-MM-dd"));
model.PAGES = ds.Tables[0].Rows[i]["Pages"].ToString();
model.REMARK = ds.Tables[0].Rows[i]["Remark"].ToString();
model.JUANXUHAO = ds.Tables[0].Rows[i]["JuanXuHao"].ToString();
if (ds.Tables[0].Rows[i]["TitleFormat"].ToString().Contains("'"))
{
model.TITLEFORMAT = ds.Tables[0].Rows[i]["TitleFormat"].ToString().Replace("'", "吋");
}
else
{
model.TITLEFORMAT = ds.Tables[0].Rows[i]["TitleFormat"].ToString();
}
model.GOTTIMESPECIAL = ds.Tables[0].Rows[i]["GotTimeSpecial"].ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into AMARCHIVES(");
strSql.Append("IDVOLUME,TITLEFORMAT,GOTTIMESPECIAL,IDARCHIVE,ARCHIVEID,DUTYMAN,TITLE,GOTTIME,PAGES,REMARK,JUANXUHAO");
strSql.Append(") values (");
strSql.Append(":IDVOLUME,:TITLEFORMAT,:GOTTIMESPECIAL,:IDARCHIVE,:ARCHIVEID,:DUTYMAN,:TITLE,:GOTTIME,:PAGES,:REMARK,:JUANXUHAO");
strSql.Append(") ");
OracleParameter[] parameters = {
new OracleParameter(":IDVOLUME", OracleType.Number,10) ,
new OracleParameter(":TITLEFORMAT", OracleType.NVarChar) ,
new OracleParameter(":GOTTIMESPECIAL", OracleType.NVarChar) ,
new OracleParameter(":IDARCHIVE", OracleType.Number,19) ,
new OracleParameter(":ARCHIVEID", OracleType.NVarChar) ,
new OracleParameter(":DUTYMAN", OracleType.NVarChar) ,
new OracleParameter(":TITLE", OracleType.NVarChar) ,
new OracleParameter(":GOTTIME", OracleType.DateTime) ,
new OracleParameter(":PAGES", OracleType.NVarChar) ,
new OracleParameter(":REMARK", OracleType.NVarChar) ,
new OracleParameter(":JUANXUHAO", OracleType.NVarChar)
};
parameters[0].Value = model.IDVOLUME;
parameters[1].Value = model.TITLEFORMAT;
parameters[2].Value = model.GOTTIMESPECIAL;
parameters[3].Value = model.IDARCHIVE;
parameters[4].Value = model.ARCHIVEID;
parameters[5].Value = model.DUTYMAN;
parameters[6].Value = model.TITLE;
parameters[7].Value = model.GOTTIME;
parameters[8].Value = model.PAGES;
parameters[9].Value = model.REMARK;
parameters[10].Value = model.JUANXUHAO;
db.oracleExecuteNonQuery(strSql.ToString());
}
}