/// <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); }