5,889
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Model.CenterToDeptApplication model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ADMINISTRATOR.CENTERTODEPT_APPLICATION(";
strSql.Append("UUID,APP_NO,DEPT_NO,PROJ_NAME,APP_NAME,PROM_TIME,UNIT_CODE,UNIT_NAME,ACC_NAME,ACC_TIME,END_TIME,COMP_TIME,END_STATUS,GET_NAME,GET_TIME,DEPT_APP_NO,COMMENTS,SWAP_TIME,STATUS,INVEST,FEE,SWAP_STATUS)";
strSql.Append(" values (";
strSql.Append(":UUID,:APP_NO,EPT_NO,:PROJ_NAME,:APP_NAME,ATA_XML,@PROM_TIME,:UNIT_CODE,:UNIT_NAME,:ACC_NAME,:ACC_TIME,:END_TIME,:COMP_TIME,:END_STATUS,:GET_NAME,:GET_TIME,EPT_APP_NO,:COMMENTS,:SWAP_TIME,:STATUS,:INVEST,:FEE,:SWAP_STATUS)";
OleDbParameter[] parameters = {
new OleDbParameter(":UUID", OleDbType.VarChar,50),
new OleDbParameter(":APP_NO", OleDbType.VarChar,50),
new OleDbParameter("EPT_NO", OleDbType.VarChar,50),
new OleDbParameter(":PROJ_NAME", OleDbType.VarChar,200),
new OleDbParameter(":APP_NAME", OleDbType.VarChar,100),
new OleDbParameter("ATA_XML", OleDbType.Binary,16),
new OleDbParameter(":PROM_TIME", OleDbType.VarChar,20),
new OleDbParameter(":UNIT_CODE", OleDbType.VarChar,50),
new OleDbParameter(":UNIT_NAME", OleDbType.VarChar,200),
new OleDbParameter(":ACC_NAME", OleDbType.VarChar,50),
new OleDbParameter(":ACC_TIME", OleDbType.VarChar,20),
new OleDbParameter(":END_TIME", OleDbType.VarChar,20),
new OleDbParameter(":COMP_TIME", OleDbType.VarChar,20),
new OleDbParameter(":END_STATUS", OleDbType.VarChar,50),
new OleDbParameter(":GET_NAME", OleDbType.VarChar,50),
new OleDbParameter(":GET_TIME", OleDbType.VarChar,20),
new OleDbParameter("EPT_APP_NO", OleDbType.VarChar,50),
new OleDbParameter(":COMMENTS", OleDbType.VarChar,500),
new OleDbParameter(":SWAP_TIME", OleDbType.VarChar,20),
new OleDbParameter(":STATUS", OleDbType.VarChar,50),
new OleDbParameter(":INVEST", OleDbType.VarChar,50),
new OleDbParameter(":FEE", OleDbType.VarChar,500),
new OleDbParameter(":SWAP_STATUS", OleDbType.VarChar,10)};
parameters[0].Value = model.UUID;
parameters[1].Value = model.AppNo;
parameters[2].Value = model.DeptNo;
parameters[3].Value = model.ProjName;
parameters[4].Value = model.AppName;
parameters[5].Value = model.DataXml;
parameters[6].Value = model.PromTime;
parameters[7].Value = model.UnitCode;
parameters[8].Value = model.UnitName;
parameters[9].Value = model.AccName;
parameters[10].Value = model.AccTime;
parameters[11].Value = model.EndTime;
parameters[12].Value = model.CompTime;
parameters[13].Value = model.EndStatus;
parameters[14].Value = model.GetName;
parameters[15].Value = model.GetTime;
parameters[16].Value = model.DeptAppNo;
parameters[17].Value = model.Comments;
parameters[18].Value = model.SwapTime;
parameters[19].Value = model.Status;
parameters[20].Value = model.Invest;
parameters[21].Value = model.Fee;
parameters[22].Value = model.SwapStatus;
OleDbHelper.ExecuteSql(strSql.ToString(),parameters);
}