/// <summary>
/// 增加一条数据
/// </summary>
public void Add(T_CP_ACT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_CP_ACT(");
strSql.Append("ACTID,ID,ACTCODE,DEPTIDS,SRCTYPE,STATUS,DELFLAG,CREATOR,UPDATOR,UPDATETIME,ENDDATE,ACTNAME,FILENUMBER,PUBDATE,STADATE,DEPTS,CONTENT,CREATEDTIME,EFFECT");
strSql.Append(") values (");
strSql.Append(":ACTID,:ID,:ACTCODE,:DEPTIDS,:SRCTYPE,:STATUS,:DELFLAG,:CREATOR,:UPDATOR,:UPDATETIME,:ENDDATE,:ACTNAME,:FILENUMBER,:PUBDATE,:STADATE,:DEPTS,:CONTENT,:CREATEDTIME,:EFFECT");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":ACTID", OracleType.Number, 32),
new OracleParameter(":ID", OracleType.Number, 32),
new OracleParameter(":ACTCODE", OracleType.VarChar, 64),
new OracleParameter(":DEPTIDS", OracleType.VarChar, 640),
new OracleParameter(":SRCTYPE", OracleType.Char, 2),
new OracleParameter(":STATUS", OracleType.Char, 2),
new OracleParameter(":DELFLAG", OracleType.Char, 2),
new OracleParameter(":CREATOR", OracleType.VarChar, 64),
new OracleParameter(":UPDATOR", OracleType.VarChar, 64),
new OracleParameter(":UPDATETIME", OracleType.DateTime),
new OracleParameter(":ENDDATE", OracleType.DateTime),
new OracleParameter(":ACTNAME", OracleType.VarChar, 1024),
new OracleParameter(":FILENUMBER", OracleType.VarChar, 4000),
new OracleParameter(":PUBDATE", OracleType.DateTime),
new OracleParameter(":STADATE", OracleType.DateTime),
new OracleParameter(":DEPTS", OracleType.VarChar, 1024),
new OracleParameter(":CONTENT", OracleType.Clob, 4000),
new OracleParameter(":CREATEDTIME", OracleType.DateTime),
new OracleParameter(":EFFECT", OracleType.Char, 2)
};
parameters[0].Value = model.ACTID;
parameters[1].Value = model.ID;
parameters[2].Value = model.ACTCODE;
parameters[3].Value = model.DEPTIDS;
parameters[4].Value = model.SRCTYPE;
parameters[5].Value = model.STATUS;
parameters[6].Value = model.DELFLAG;
parameters[7].Value = model.CREATOR;
parameters[8].Value = model.UPDATOR;
parameters[9].Value = model.UPDATETIME;
parameters[10].Value = model.ENDDATE;
parameters[11].Value = model.ACTNAME;
parameters[12].Value = model.FILENUMBER;
parameters[13].Value = model.PUBDATE;
parameters[14].Value = model.STADATE;
parameters[15].Value = model.DEPTS;
parameters[16].Value = model.CONTENT;
parameters[17].Value = model.CREATEDTIME;
parameters[18].Value = model.EFFECT;
DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
static void ActInsert(act parm)
{
// string sql = @"insert into T_CP_ACT (ID,ACTID,ACTNAME,FILENUMBER,CONTENT,PUBDATE,STADATE,DEPTS,CREATEDTIME,EFFECT,ACTCODE,DEPTIDS,SRCTYPE,STATUS,DELFLAG,UPDATETIME,ENDDATE)
// values (:ID,:ACTID,:ACTNAME,:FILENUMBER,:CONTENT,:PUBDATE,:STADATE,:DEPTS,:CREATEDTIME,:EFFECT,:ACTCODE,:DEPTIDS,:SRCTYPE,:STATUS,:DELFLAG,:UPDATETIME,:ENDDATE)";
// //:ID,:ACTID,:ACTNAME,:FILENUMBER,:CONTENT,:PUBDATE,:STADATE,:DEPTS,:CREATEDTIME,:EFFECT,:ACTCODE,:DEPTIDS,:SRCTYPE,:STATUS,:DELFLAG,:UPDATETIME,:ENDDATE
// OracleParameter[] parms ={
// new OracleParameter(":ID",OracleType.Number,32,parm.actid),
// new OracleParameter(":ACTID",OracleType.Number,32,parm.actid),
// new OracleParameter(":ACTNAME",parm.actname),
// new OracleParameter(":FILENUMBER",parm.fileNumber),
// new OracleParameter(":CONTENT",parm.content),
// new OracleParameter(":PUBDATE", Convert.ToDateTime(parm.pubdate)),//有问题
// new OracleParameter(":STADATE",Convert.ToDateTime(parm.stadate)),//有问题
// new OracleParameter(":DEPTS",parm.depts),
// new OracleParameter(":CREATEDTIME",DateTime.Now),
// new OracleParameter(":EFFECT",parm.effect),
// new OracleParameter(":ACTCODE",""),
// new OracleParameter(":DEPTIDS",parm.deptids),
// new OracleParameter(":SRCTYPE","1"),
// new OracleParameter(":STATUS","1"),
// new OracleParameter(":DELFLAG","N"),//如果是"Y"呢？
// new OracleParameter(":UPDATETIME",DateTime.Now),
// new OracleParameter(":ENDDATE",parm.enddate==null?DateTime.MinValue:Convert.ToDateTime(parm.enddate))
// };
// DBHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text, parms);
// string sql = "INSERT INTO T_CP_ACT (ID,ACTID,ACTNAME,FILENUMBER,CONTENT,PUBDATE,STADATE,DEPTS,CREATEDTIME,EFFECT,ACTCODE,DEPTIDS,SRCTYPE,STATUS,DELFLAG,UPDATETIME,ENDDATE) VALUES (" + parm.actid + "," + parm.actid + ",'" + parm.actname + "','" + parm.fileNumber + "','" + parm.content + "','" + parm.pubdate + "','" + parm.stadate + "','" + parm.depts + "','" + DateTime.Now.ToString("yyyy/MM/dd") + "'," + parm.effect + ",1,'" + parm.deptids + "',1,1,'N','" + DateTime.Now.ToString("yyyy/MM/dd") + "','"+parm.enddate+"')";
// DBHelper.ExecuteNonQuery(sql);
T_CP_ACT act = new T_CP_ACT()
{
ID = Convert.ToInt32(parm.actid),
ACTCODE = "",
ACTID = Convert.ToInt32(parm.actid),
ACTNAME = parm.actname,
CONTENT = parm.content,
CREATEDTIME = DateTime.Now,
CREATOR = "",
DELFLAG = "N",
DEPTIDS = parm.deptids,
DEPTS = parm.depts,
EFFECT = parm.effect,
FILENUMBER = parm.fileNumber,
SRCTYPE = "1",
STATUS = "1",
UPDATETIME = DateTime.Now,
UPDATOR = "",
STADATE = DateTime.MinValue,
PUBDATE = DateTime.MinValue,
ENDDATE = DateTime.MinValue
};
if (parm.pubdate != null && parm.pubdate != string.Empty)
{
act.PUBDATE = Convert.ToDateTime(parm.pubdate);
}
if (parm.stadate != null && parm.stadate != string.Empty)
{
act.STADATE = Convert.ToDateTime(parm.stadate);
}
if (parm.enddate != null && parm.enddate != string.Empty)
{
act.ENDDATE = Convert.ToDateTime(parm.enddate);
}
act.Add(act);
Console.WriteLine("Act Inserted " + act.ACTID);
}
