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