/// <summary> /// 增加一条数据 /// </summary> public int Add(Approval_Mode_3Info model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Approval_Mode_3("); strSql.Append("FILE_POINTER,SOURCE_TYPE,APPROVAL_STEP_NO,APPROVAL_STEP_DESC)"); strSql.Append(" values ("); strSql.Append("@FILE_POINTER,@SOURCE_TYPE,@APPROVAL_STEP_NO,@APPROVAL_STEP_DESC)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@FILE_POINTER", SqlDbType.Int, 4), new SqlParameter("@SOURCE_TYPE", SqlDbType.Int, 4), new SqlParameter("@APPROVAL_STEP_NO", SqlDbType.Int, 4), new SqlParameter("@APPROVAL_STEP_DESC", SqlDbType.VarChar, 50) }; parameters[0].Value = model.FILE_POINTER; parameters[1].Value = model.SOURCE_TYPE; parameters[2].Value = model.APPROVAL_STEP_NO; parameters[3].Value = model.APPROVAL_STEP_DESC; object obj = dbHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="DATA0002">data0002对象</param> /// <returns>新插入记录的编号</returns> public int Add(DATA0002 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DATA0002("); strSql.Append("UNIT_CODE,UNIT_NAME,PROD,PURCH,STOCK,QUOTE,SELL,UNIT_BASE,DERIVED,INT_CHECK,EXPRESSION,MIN_UNIT_VALUE,MAX_UNIT_VALUE,UNIT_TYPE,POT_OUTER_LAYER,POT_INNER_LAYER,ACTIVE_FLAG,ECN_FLAG)"); strSql.Append(" values ("); strSql.Append("@UNIT_CODE,@UNIT_NAME,@PROD,@PURCH,@STOCK,@QUOTE,@SELL,@UNIT_BASE,@DERIVED,@INT_CHECK,@EXPRESSION,@MIN_UNIT_VALUE,@MAX_UNIT_VALUE,@UNIT_TYPE,@POT_OUTER_LAYER,@POT_INNER_LAYER,@ACTIVE_FLAG,@ECN_FLAG)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UNIT_CODE", SqlDbType.VarChar, 5), new SqlParameter("@UNIT_NAME", SqlDbType.VarChar, 20), new SqlParameter("@PROD", SqlDbType.Char, 1), new SqlParameter("@PURCH", SqlDbType.Char, 1), new SqlParameter("@STOCK", SqlDbType.Char, 1), new SqlParameter("@QUOTE", SqlDbType.Char, 1), new SqlParameter("@SELL", SqlDbType.Char, 1), new SqlParameter("@UNIT_BASE", SqlDbType.Char, 1), new SqlParameter("@DERIVED", SqlDbType.Char, 1), new SqlParameter("@INT_CHECK", SqlDbType.Char, 1), new SqlParameter("@EXPRESSION", SqlDbType.VarChar, 50), new SqlParameter("@MIN_UNIT_VALUE", SqlDbType.Decimal, 13), new SqlParameter("@MAX_UNIT_VALUE", SqlDbType.Decimal, 13), new SqlParameter("@UNIT_TYPE", SqlDbType.Char, 1), new SqlParameter("@POT_OUTER_LAYER", SqlDbType.Decimal, 5), new SqlParameter("@POT_INNER_LAYER", SqlDbType.Decimal, 5), new SqlParameter("@ACTIVE_FLAG", SqlDbType.Decimal, 9), new SqlParameter("@ECN_FLAG", SqlDbType.VarChar, 1) }; parameters[0].Value = model.UNIT_CODE; parameters[1].Value = model.UNIT_NAME; parameters[2].Value = model.PROD; parameters[3].Value = model.PURCH; parameters[4].Value = model.STOCK; parameters[5].Value = model.QUOTE; parameters[6].Value = model.SELL; parameters[7].Value = model.UNIT_BASE; parameters[8].Value = model.DERIVED; parameters[9].Value = model.INT_CHECK; parameters[10].Value = model.EXPRESSION; parameters[11].Value = model.MIN_UNIT_VALUE; parameters[12].Value = model.MAX_UNIT_VALUE; parameters[13].Value = model.UNIT_TYPE; parameters[14].Value = model.POT_OUTER_LAYER; parameters[15].Value = model.POT_INNER_LAYER; parameters[16].Value = model.ACTIVE_FLAG; parameters[17].Value = model.ECN_FLAG; object obj = dbHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Approval_Mode_4Info model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Approval_Mode_4("); strSql.Append("ROUTE_STEP_PTR,USER_PTR)"); strSql.Append(" values ("); strSql.Append("@ROUTE_STEP_PTR,@USER_PTR)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ROUTE_STEP_PTR", SqlDbType.Int, 4), new SqlParameter("@USER_PTR", SqlDbType.Int, 4) }; parameters[0].Value = model.ROUTE_STEP_PTR; parameters[1].Value = model.USER_PTR; object obj = dbHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(FOUNDERPCB_ANALYSIS model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into FOUNDERPCB_ANALYSIS("); strSql.Append("SOURCE_CODE,ID_KEY,ANS_NAME)"); strSql.Append(" values ("); strSql.Append("@SOURCE_CODE,@ID_KEY,@ANS_NAME)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SOURCE_CODE", SqlDbType.VarChar, 20), new SqlParameter("@ID_KEY", SqlDbType.Int, 4), new SqlParameter("@ANS_NAME", SqlDbType.VarChar, 50) }; parameters[0].Value = model.SOURCE_CODE; parameters[1].Value = model.ID_KEY; parameters[2].Value = model.ANS_NAME; object obj = dbHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(RPT_SERVERPATH model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into RPT_SERVERPATH("); strSql.Append("SERVER_PATH,FLODER_PATH,TTYPE,ACTIVE_FLAG,EMP_PTR)"); strSql.Append(" values ("); strSql.Append("@SERVER_PATH,@FLODER_PATH,@TTYPE,@ACTIVE_FLAG,@EMP_PTR)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SERVER_PATH", SqlDbType.VarChar, 200), new SqlParameter("@FLODER_PATH", SqlDbType.VarChar, 200), new SqlParameter("@TTYPE", SqlDbType.Int, 4), new SqlParameter("@ACTIVE_FLAG", SqlDbType.Int, 4), new SqlParameter("@EMP_PTR", SqlDbType.Int, 4) }; parameters[0].Value = model.SERVER_PATH; parameters[1].Value = model.FLODER_PATH; parameters[2].Value = model.TTYPE; parameters[3].Value = model.ACTIVE_FLAG; parameters[4].Value = model.EMP_PTR; object obj = dbHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(RPT_QUICKREPORT_LINK model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into RPT_QUICKREPORT_LINK("); strSql.Append("FROM_NAME,REPORT_NAME,REPORT_dESC,REPORT_PTR,EMP_PTR)"); strSql.Append(" values ("); strSql.Append("@FROM_NAME,@REPORT_NAME,@REPORT_dESC,@REPORT_PTR,@EMP_PTR)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@FROM_NAME", SqlDbType.VarChar, 200), new SqlParameter("@REPORT_NAME", SqlDbType.VarChar, 200), new SqlParameter("@REPORT_dESC", SqlDbType.VarChar, 200), new SqlParameter("@REPORT_PTR", SqlDbType.Int, 4), new SqlParameter("@EMP_PTR", SqlDbType.Int, 4) }; parameters[0].Value = model.FROM_NAME; parameters[1].Value = model.REPORT_NAME; parameters[2].Value = model.REPORT_dESC; parameters[3].Value = model.REPORT_PTR; parameters[4].Value = model.EMP_PTR; object obj = dbHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(RPT_MODUL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into RPT_MODUL("); strSql.Append("MODUL_NAME,ACTIVE_FLAG,EMP_PTR)"); strSql.Append(" values ("); strSql.Append("@MODUL_NAME,@ACTIVE_FLAG,@EMP_PTR)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MODUL_NAME", SqlDbType.VarChar, 50), new SqlParameter("@ACTIVE_FLAG", SqlDbType.Int, 4), new SqlParameter("@EMP_PTR", SqlDbType.Int, 4) }; parameters[0].Value = model.MODUL_NAME; parameters[1].Value = model.ACTIVE_FLAG; parameters[2].Value = model.EMP_PTR; object obj = dbHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(RPT_SETPARM model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into RPT_SETPARM("); strSql.Append("SERVER_PTR,MODUL_PTR,TTYPE,REPORT_PATH,REPORT_NAME,DISPLAY_NAME,REPORT_CODE,REPORT_PARM,QUICK_PRINT,CHOOSE_PAYE,MARGINS_TOP,MARGINS_BUTTOM,MARGINS_LEFT,MARGINS_RIGHT,ACTIVE_FLAG,EMP_PTR)"); strSql.Append(" values ("); strSql.Append("@SERVER_PTR,@MODUL_PTR,@TTYPE,@REPORT_PATH,@REPORT_NAME,@DISPLAY_NAME,@REPORT_CODE,@REPORT_PARM,@QUICK_PRINT,@CHOOSE_PAYE,@MARGINS_TOP,@MARGINS_BUTTOM,@MARGINS_LEFT,@MARGINS_RIGHT,@ACTIVE_FLAG,@EMP_PTR)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SERVER_PTR", SqlDbType.Int, 4), new SqlParameter("@MODUL_PTR", SqlDbType.Int, 4), new SqlParameter("@TTYPE", SqlDbType.VarChar, 20), new SqlParameter("@REPORT_PATH", SqlDbType.VarChar, 200), new SqlParameter("@REPORT_NAME", SqlDbType.VarChar, 200), new SqlParameter("@DISPLAY_NAME", SqlDbType.VarChar, 100), new SqlParameter("@REPORT_CODE", SqlDbType.VarChar, 20), new SqlParameter("@REPORT_PARM", SqlDbType.VarChar, 100), new SqlParameter("@QUICK_PRINT", SqlDbType.Int, 4), new SqlParameter("@CHOOSE_PAYE", SqlDbType.Int, 4), new SqlParameter("@MARGINS_TOP", SqlDbType.Int, 4), new SqlParameter("@MARGINS_BUTTOM", SqlDbType.Int, 4), new SqlParameter("@MARGINS_LEFT", SqlDbType.Int, 4), new SqlParameter("@MARGINS_RIGHT", SqlDbType.Int, 4), new SqlParameter("@ACTIVE_FLAG", SqlDbType.Int, 4), new SqlParameter("@EMP_PTR", SqlDbType.Int, 4) }; parameters[0].Value = model.SERVER_PTR; parameters[1].Value = model.MODUL_PTR; parameters[2].Value = model.TTYPE; parameters[3].Value = model.REPORT_PATH; parameters[4].Value = model.REPORT_NAME; parameters[5].Value = model.DISPLAY_NAME; parameters[6].Value = model.REPORT_CODE; parameters[7].Value = model.REPORT_PARM; parameters[8].Value = model.QUICK_PRINT; parameters[9].Value = model.CHOOSE_PAYE; parameters[10].Value = model.MARGINS_TOP; parameters[11].Value = model.MARGINS_BUTTOM; parameters[12].Value = model.MARGINS_LEFT; parameters[13].Value = model.MARGINS_RIGHT; parameters[14].Value = model.ACTIVE_FLAG; parameters[15].Value = model.EMP_PTR; object obj = dbHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DATA0001 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DATA0001("); strSql.Append("ID,APPLYTIME,DEPT,NAME,NUMBER,KIND,TYPE,REACHTIME,PROTYPE.MAPNUMB,ATTACH,REASON)"); strSql.Append(" values ("); strSql.Append("@ID,@APPLYTIME,@DEPT,@NAME,@NUMBER,@KIND,@TYPE,@REACHTIME,@PROTYPE,@MAPNUMB,@ATTACH,@REASON)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 4), new SqlParameter("@APPLYTIME", SqlDbType.VarChar, 4), new SqlParameter("@DEPT", SqlDbType.VarChar, 4), new SqlParameter("@NAME", SqlDbType.VarChar, 4), new SqlParameter("@NUMBER", SqlDbType.VarChar, 4), new SqlParameter("@KIND", SqlDbType.VarChar, 4), new SqlParameter("@TYPE", SqlDbType.VarChar, 4), new SqlParameter("@REACHTIME", SqlDbType.VarChar, 4), new SqlParameter("@PROTYPE", SqlDbType.VarChar, 4), new SqlParameter("@MAPNUMB", SqlDbType.VarChar, 4), new SqlParameter("@ATTACH", SqlDbType.VarChar, 4), new SqlParameter("@REASON", SqlDbType.VarChar, 4) }; parameters[0].Value = model.ID; parameters[0].Value = model.APPLYTIME; parameters[0].Value = model.DEPT; parameters[0].Value = model.NAME; parameters[0].Value = model.NUMBER; parameters[0].Value = model.KIND; parameters[0].Value = model.TYPE; parameters[0].Value = model.REACHTIME; parameters[0].Value = model.PROTYPE; parameters[0].Value = model.MAPNUMB; parameters[0].Value = model.ATTACH; parameters[0].Value = model.REASON; object obj = dbHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Approval_Mode_1Info model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Approval_Mode_1("); strSql.Append("FILE_POINTER,SOURCE_TYPE,FROM_STEP_NO,TO_STEP_NO,TRANS_TYPE,TRANS_DESCRIPTION,USER_PTR,TRANS_DATE_TIME)"); strSql.Append(" values ("); strSql.Append("@FILE_POINTER,@SOURCE_TYPE,@FROM_STEP_NO,@TO_STEP_NO,@TRANS_TYPE,@TRANS_DESCRIPTION,@USER_PTR,@TRANS_DATE_TIME)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@FILE_POINTER", SqlDbType.Int, 4), new SqlParameter("@SOURCE_TYPE", SqlDbType.Int, 4), new SqlParameter("@FROM_STEP_NO", SqlDbType.Int, 4), new SqlParameter("@TO_STEP_NO", SqlDbType.Int, 4), new SqlParameter("@TRANS_TYPE", SqlDbType.Int, 4), new SqlParameter("@TRANS_DESCRIPTION", SqlDbType.VarChar, 30), new SqlParameter("@USER_PTR", SqlDbType.Int, 4), new SqlParameter("@TRANS_DATE_TIME", SqlDbType.DateTime) }; parameters[0].Value = model.FILE_POINTER; parameters[1].Value = model.SOURCE_TYPE; parameters[2].Value = model.FROM_STEP_NO; parameters[3].Value = model.TO_STEP_NO; parameters[4].Value = model.TRANS_TYPE; parameters[5].Value = model.TRANS_DESCRIPTION; parameters[6].Value = model.USER_PTR; if (model.TRANS_DATE_TIME == DateTime.Parse("1900-1-1") || model.TRANS_DATE_TIME == DateTime.Parse("0001-1-1")) { parameters[7].Value = null; } else { parameters[7].Value = model.TRANS_DATE_TIME; } object obj = dbHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }