/// <summary> /// 更新一条数据 /// </summary> public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, Approval_Mode_3Info model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Approval_Mode_3 set "); strSql.Append("FILE_POINTER=@FILE_POINTER,"); strSql.Append("SOURCE_TYPE=@SOURCE_TYPE,"); strSql.Append("APPROVAL_STEP_NO=@APPROVAL_STEP_NO,"); strSql.Append("APPROVAL_STEP_DESC=@APPROVAL_STEP_DESC"); strSql.Append(" where RKEY=@RKEY "); SqlParameter[] parameters = { new SqlParameter("@RKEY", SqlDbType.Int, 4), 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.RKEY; parameters[1].Value = model.FILE_POINTER; parameters[2].Value = model.SOURCE_TYPE; parameters[3].Value = model.APPROVAL_STEP_NO; parameters[4].Value = model.APPROVAL_STEP_DESC; dbHelper.ExecuteTranByNone(cmd, conn, trans, strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, RPT_SERVERPATH model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update RPT_SERVERPATH set "); strSql.Append("SERVER_PATH=@SERVER_PATH,"); strSql.Append("FLODER_PATH=@FLODER_PATH,"); strSql.Append("TTYPE=@TTYPE,"); strSql.Append("ACTIVE_FLAG=@ACTIVE_FLAG,"); strSql.Append("EMP_PTR=@EMP_PTR"); strSql.Append(" where RKEY=@RKEY "); SqlParameter[] parameters = { new SqlParameter("@RKEY", SqlDbType.Int, 4), 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.RKEY; parameters[1].Value = model.SERVER_PATH; parameters[2].Value = model.FLODER_PATH; parameters[3].Value = model.TTYPE; parameters[4].Value = model.ACTIVE_FLAG; parameters[5].Value = model.EMP_PTR; dbHelper.ExecuteTranByNone(cmd, conn, trans, strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, RPT_QUICKREPORT_LINK model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update RPT_QUICKREPORT_LINK set "); strSql.Append("FROM_NAME=@FROM_NAME,"); strSql.Append("REPORT_NAME=@REPORT_NAME,"); strSql.Append("REPORT_dESC=@REPORT_dESC,"); strSql.Append("REPORT_PTR=@REPORT_PTR,"); strSql.Append("EMP_PTR=@EMP_PTR"); strSql.Append(" where RKEY=@RKEY "); SqlParameter[] parameters = { new SqlParameter("@RKEY", SqlDbType.Int, 4), 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.RKEY; parameters[1].Value = model.FROM_NAME; parameters[2].Value = model.REPORT_NAME; parameters[3].Value = model.REPORT_dESC; parameters[4].Value = model.REPORT_PTR; parameters[5].Value = model.EMP_PTR; dbHelper.ExecuteTranByNone(cmd, conn, trans, strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, DATA0001 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update DATA0001 set "); strSql.Append("ID=@ID,"); strSql.Append("APPLYTIME=@APPLYTIME,"); strSql.Append("DEPT=@DEPT,"); strSql.Append("NAME=@NAME,"); strSql.Append("NUMBER=@NUMBER,"); strSql.Append("KIND=@KIND,"); strSql.Append("TYPE=@TYPE,"); strSql.Append("REACHTIME=@REACHTIME,"); strSql.Append("PROTYPE=@PROTYPE,"); strSql.Append("MAPNUMB=@MAPNUMB,"); strSql.Append("ATTACH=@ATTACH,"); strSql.Append("REASON=@REASON "); strSql.Append(" where RKEY=@RKEY "); SqlParameter[] parameters = { new SqlParameter("@RKEY", SqlDbType.VarChar, 4), 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.RKEY; 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; dbHelper.ExecuteTranByNone(cmd, conn, trans, strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, Approval_Mode_1Info model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Approval_Mode_1 set "); strSql.Append("FILE_POINTER=@FILE_POINTER,"); strSql.Append("SOURCE_TYPE=@SOURCE_TYPE,"); strSql.Append("FROM_STEP_NO=@FROM_STEP_NO,"); strSql.Append("TO_STEP_NO=@TO_STEP_NO,"); strSql.Append("TRANS_TYPE=@TRANS_TYPE,"); strSql.Append("TRANS_DESCRIPTION=@TRANS_DESCRIPTION,"); strSql.Append("USER_PTR=@USER_PTR,"); strSql.Append("TRANS_DATE_TIME=@TRANS_DATE_TIME"); strSql.Append(" where RKEY=@RKEY "); SqlParameter[] parameters = { new SqlParameter("@RKEY", SqlDbType.Int, 4), 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.RKEY; parameters[1].Value = model.FILE_POINTER; parameters[2].Value = model.SOURCE_TYPE; parameters[3].Value = model.FROM_STEP_NO; parameters[4].Value = model.TO_STEP_NO; parameters[5].Value = model.TRANS_TYPE; parameters[6].Value = model.TRANS_DESCRIPTION; parameters[7].Value = model.USER_PTR; if (model.TRANS_DATE_TIME == DateTime.Parse("1900-1-1") || model.TRANS_DATE_TIME == DateTime.Parse("0001-1-1")) { parameters[8].Value = null; } else { parameters[8].Value = model.TRANS_DATE_TIME; } dbHelper.ExecuteTranByNone(cmd, conn, trans, strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, Approval_Mode_4Info model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Approval_Mode_4 set "); strSql.Append("ROUTE_STEP_PTR=@ROUTE_STEP_PTR,"); strSql.Append("USER_PTR=@USER_PTR"); strSql.Append(" where RKEY=@RKEY "); SqlParameter[] parameters = { new SqlParameter("@RKEY", SqlDbType.Int, 4), new SqlParameter("@ROUTE_STEP_PTR", SqlDbType.Int, 4), new SqlParameter("@USER_PTR", SqlDbType.Int, 4) }; parameters[0].Value = model.RKEY; parameters[1].Value = model.ROUTE_STEP_PTR; parameters[2].Value = model.USER_PTR; dbHelper.ExecuteTranByNone(cmd, conn, trans, strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, FOUNDERPCB_ANALYSIS model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update FOUNDERPCB_ANALYSIS set "); strSql.Append("SOURCE_CODE=@SOURCE_CODE,"); strSql.Append("ID_KEY=@ID_KEY,"); strSql.Append("ANS_NAME=@ANS_NAME"); strSql.Append(" where RKEY=@RKEY "); SqlParameter[] parameters = { new SqlParameter("@RKEY", SqlDbType.Int, 4), 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.RKEY; parameters[1].Value = model.SOURCE_CODE; parameters[2].Value = model.ID_KEY; parameters[3].Value = model.ANS_NAME; dbHelper.ExecuteTranByNone(cmd, conn, trans, strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, RPT_MODUL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update RPT_MODUL set "); strSql.Append("MODUL_NAME=@MODUL_NAME,"); strSql.Append("ACTIVE_FLAG=@ACTIVE_FLAG,"); strSql.Append("EMP_PTR=@EMP_PTR"); strSql.Append(" where RKEY=@RKEY "); SqlParameter[] parameters = { new SqlParameter("@RKEY", SqlDbType.Int, 4), 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.RKEY; parameters[1].Value = model.MODUL_NAME; parameters[2].Value = model.ACTIVE_FLAG; parameters[3].Value = model.EMP_PTR; dbHelper.ExecuteTranByNone(cmd, conn, trans, strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, RPT_SETPARM model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update RPT_SETPARM set "); strSql.Append("SERVER_PTR=@SERVER_PTR,"); strSql.Append("MODUL_PTR=@MODUL_PTR,"); strSql.Append("TTYPE=@TTYPE,"); strSql.Append("REPORT_PATH=@REPORT_PATH,"); strSql.Append("REPORT_NAME=@REPORT_NAME,"); strSql.Append("DISPLAY_NAME=@DISPLAY_NAME,"); strSql.Append("REPORT_CODE=@REPORT_CODE,"); strSql.Append("REPORT_PARM=@REPORT_PARM,"); strSql.Append("QUICK_PRINT=@QUICK_PRINT,"); strSql.Append("CHOOSE_PAYE=@CHOOSE_PAYE,"); strSql.Append("MARGINS_TOP=@MARGINS_TOP,"); strSql.Append("MARGINS_BUTTOM=@MARGINS_BUTTOM,"); strSql.Append("MARGINS_LEFT=@MARGINS_LEFT,"); strSql.Append("MARGINS_RIGHT=@MARGINS_RIGHT,"); strSql.Append("ACTIVE_FLAG=@ACTIVE_FLAG,"); strSql.Append("EMP_PTR=@EMP_PTR"); strSql.Append(" where RKEY=@RKEY "); SqlParameter[] parameters = { new SqlParameter("@RKEY", SqlDbType.Int, 4), 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.RKEY; parameters[1].Value = model.SERVER_PTR; parameters[2].Value = model.MODUL_PTR; parameters[3].Value = model.TTYPE; parameters[4].Value = model.REPORT_PATH; parameters[5].Value = model.REPORT_NAME; parameters[6].Value = model.DISPLAY_NAME; parameters[7].Value = model.REPORT_CODE; parameters[8].Value = model.REPORT_PARM; parameters[9].Value = model.QUICK_PRINT; parameters[10].Value = model.CHOOSE_PAYE; parameters[11].Value = model.MARGINS_TOP; parameters[12].Value = model.MARGINS_BUTTOM; parameters[13].Value = model.MARGINS_LEFT; parameters[14].Value = model.MARGINS_RIGHT; parameters[15].Value = model.ACTIVE_FLAG; parameters[16].Value = model.EMP_PTR; dbHelper.ExecuteTranByNone(cmd, conn, trans, strSql.ToString(), parameters); }