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