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