/// <summary> /// 增加一条数据 /// </summary> public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, 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; return(dbHelper.ExecuteTranByID(cmd, conn, trans, strSql.ToString(), parameters)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, 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; return(dbHelper.ExecuteTranByID(cmd, conn, trans, strSql.ToString(), parameters)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, Approval_Mode_2Info model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Approval_Mode_2("); strSql.Append("FILE_POINTER,SOURCE_TYPE,APPROVAL_ROUTE_PTR,APPROVAL_STATUS,APPROVAL_STEP_NO,TOTAL_STEPS)"); strSql.Append(" values ("); strSql.Append("@FILE_POINTER,@SOURCE_TYPE,@APPROVAL_ROUTE_PTR,@APPROVAL_STATUS,@APPROVAL_STEP_NO,@TOTAL_STEPS)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@FILE_POINTER", SqlDbType.Int, 4), new SqlParameter("@SOURCE_TYPE", SqlDbType.Int, 4), new SqlParameter("@APPROVAL_ROUTE_PTR", SqlDbType.Int, 4), new SqlParameter("@APPROVAL_STATUS", SqlDbType.Int, 4), new SqlParameter("@APPROVAL_STEP_NO", SqlDbType.Int, 4), new SqlParameter("@TOTAL_STEPS", SqlDbType.Int, 4) }; parameters[0].Value = model.FILE_POINTER; parameters[1].Value = model.SOURCE_TYPE; parameters[2].Value = model.APPROVAL_ROUTE_PTR; parameters[3].Value = model.APPROVAL_STATUS; parameters[4].Value = model.APPROVAL_STEP_NO; parameters[5].Value = model.TOTAL_STEPS; return(dbHelper.ExecuteTranByID(cmd, conn, trans, strSql.ToString(), parameters)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, 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; return(dbHelper.ExecuteTranByID(cmd, conn, trans, strSql.ToString(), parameters)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, 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; return(dbHelper.ExecuteTranByID(cmd, conn, trans, strSql.ToString(), parameters)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, Approval_Mode_NoteInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Approval_Mode_Note("); strSql.Append("FILE_POINTER,SOURCE_TYPE,NOTES)"); strSql.Append(" values ("); strSql.Append("@FILE_POINTER,@SOURCE_TYPE,@NOTES)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@FILE_POINTER", SqlDbType.Int, 4), new SqlParameter("@SOURCE_TYPE", SqlDbType.Int, 4), new SqlParameter("@NOTES", SqlDbType.VarChar, 500) }; parameters[0].Value = model.FILE_POINTER; parameters[1].Value = model.SOURCE_TYPE; parameters[2].Value = model.NOTES; return(dbHelper.ExecuteTranByID(cmd, conn, trans, strSql.ToString(), parameters)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, 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; return(dbHelper.ExecuteTranByID(cmd, conn, trans, strSql.ToString(), parameters)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, 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; return(dbHelper.ExecuteTranByID(cmd, conn, trans, strSql.ToString(), parameters)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, 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; return(dbHelper.ExecuteTranByID(cmd, conn, trans, strSql.ToString(), parameters)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, 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; } return(dbHelper.ExecuteTranByID(cmd, conn, trans, strSql.ToString(), parameters)); }