/// <summary>
/// 获取记录总数
/// </summary>
public int GetRecordCount(string C_NO, string C_NAME)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) FROM TS_CUSTFILE where 1=1");
if (!string.IsNullOrEmpty(C_NO))
{
strSql.Append("and C_NO='" + C_NO + "'");
}
if (!string.IsNullOrEmpty(C_NAME))
{
strSql.Append("and C_NAME like '%" + C_NAME + "%'");
}
object obj = DbHelperOra.GetSingle(strSql.ToString());
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TS_CUSTADDR GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_CUST_ID,C_CGC,C_CGADDR,C_CGAREA,C_CGMAN,C_POSTCODE,C_CGMOBILE,C_CGMOBILE2,N_ISDEFAULT from TS_CUSTADDR ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TS_CUSTADDR model = new Mod_TS_CUSTADDR();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TS_CUSTOTCOMPANY GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_CUST_ID,C_OTCOMPANY,C_OPENBANK,C_ACCOUNTBANK,N_ISDEFAULT from TS_CUSTOTCOMPANY ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TS_CUSTOTCOMPANY model = new Mod_TS_CUSTOTCOMPANY();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 获取客户基本信息
/// </summary>
/// <param name="C_NC_M_ID">NC客商管理档案主键</param>
/// <returns></returns>
public Mod_TS_CUSTFILE GetCustModel(string C_NC_M_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_NC_ID,C_NC_M_ID,N_ISFLAG,C_NO,C_NAME,C_SHORNAME,C_AREATYPE,C_LEGALREPRES,C_AGENT,C_OPERATOR,C_FAX,C_TAXPAYERNO,N_LEVEL,N_STATUS,N_TYPE,C_EXTEND1,C_EXTEND2,C_EXTEND3,C_EXTEND4,C_EXTEND5,C_EMP_ID,C_EMP_NAME,D_MOD_DT,N_ISGPS,C_AREAMMAX from TS_CUSTFILE ");
strSql.Append(" where C_NC_M_ID=:C_NC_M_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_NC_M_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_NC_M_ID;
Mod_TS_CUSTFILE model = new Mod_TS_CUSTFILE();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMC_CUSTGIVEMARK GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_PKHID,C_PKID,N_SCORE,D_TIME,C_REMARK from TMC_CUSTGIVEMARK ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TMC_CUSTGIVEMARK model = new Mod_TMC_CUSTGIVEMARK();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMQ_QUALITY_STL_GRD GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_QUALITY_ID,C_MAT_TYPE,C_MAT_TYPE_N,C_STL_GRD,C_SPEC,C_BATCH_NO,C_STD_CODE,N_SHIP_WGT,N_OBJEC_WGT,N_WGT,C_REMARK,N_STATUS,N_FLAG,C_EMP_ID,C_EMP_NAME,D_MOD_DT from TMQ_QUALITY_STL_GRD ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TMQ_QUALITY_STL_GRD model = new Mod_TMQ_QUALITY_STL_GRD();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TS_RoleUSER GetTokenUserRoleModel(string C_TOKEN_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_NAME,C_ACCOUNT,C_PASSWORD,C_EMAIL,C_MOBILE,N_TYPE,N_STATUS,C_DESC,D_LASTLOGINTIME,C_EMP_ID,C_EMP_NAME,D_MOD_DT,C_MOBILE2,C_PHONE,C_SHORTNAME,C_CUST_ID,C_TOKEN_ID,C_CJNAME,C_CJINTRO,C_STL_GRD,C_LEGALREPRES,C_CGJCR,C_JOB,C_JCTEL,C_ADDRESS,C_AREA,C_MANAGER from TS_USER ");
strSql.Append(" where C_TOKEN_ID=:C_TOKEN_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_TOKEN_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_TOKEN_ID;
Mod_TS_RoleUSER model = new Mod_TS_RoleUSER();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model = DataRowToRoleModel(ds.Tables[0].Rows[0]);
string sql = @"select c_id,c_code from ts_role where c_id in (
select t.c_role_id from ts_user_role t where t.c_user_id = '" + model.C_ID + "' )";
var dt = DbHelperOra.Query(sql).Tables[0];
foreach (DataRow item in dt.Rows)
{
model.Roles.Add(new Mod_TS_ROLE()
{
C_ID = item["C_ID"].ToString(),
C_CODE = item["c_code"].ToString()
});
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TQ_MODULE GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_CLASS,C_MODULE,C_CONENT,C_XGEMP,C_DEPT,C_TEL,D_TIME,C_ICT,C_RESULT,D_ICTTIME,C_REAMRK from TQ_MODULE ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2)
};
parameters[0].Value = C_ID;
Mod_TQ_MODULE model = new Mod_TQ_MODULE();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMQ_QUALITY_FILE GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_QUALITY_ID,C_TITLE,C_PATH,C_REMARK,D_DT from TMQ_QUALITY_FILE ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TMQ_QUALITY_FILE model = new Mod_TMQ_QUALITY_FILE();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TS_DIC GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_TYPECODE,C_TYPENAME,C_DETAILCODE,C_DETAILNAME,C_INDEX,N_STATUS,N_ISGPS,C_EMP_ID,C_EMP_NAME,D_MOD_DT from TS_DIC ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TS_DIC model = new Mod_TS_DIC();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetListByPage(int pageSize, int startIndex, string classID, string empID, string start, string end, string title, string state)
{
StringBuilder where = new StringBuilder();
string item = "C_ID,C_QUEST_ID,(select a.c_name from tmc_question a where a.c_id=TMC_TECH_CONSULT.c_quest_id)QUEST_NAME,C_CUST_NAME,C_CUST_CODE,C_STL_GRD,C_USE_DESC,C_REMARK,C_EMP_ID,C_EMP_NAME,D_MOD_DT,C_DEPT,C_EMP,D_PLAN_DT,D_FINISH_DT,C_REAL_TIME,C_RESULT,C_LEAVE_Q,C_REMARK2,N_CUST_EVAL,N_STATE,decode(N_STATE,0,'未处理',1,'已处理',2,'已评分',3,'办结')as N_STATE2,D_CUST_EVAL_DT,N_XG_EVAL,C_XG_EVAL_EMP,D_XG_EVAL_DT,C_ORDER_NO";
string table = "TMC_TECH_CONSULT";
string order = "D_MOD_DT desc";
if (!string.IsNullOrEmpty(empID))
{
where.Append(" and C_EMP_ID='" + empID + "'");
}
if (!string.IsNullOrEmpty(classID))
{
where.Append(" and C_QUEST_ID='" + classID + "'");
}
if (!string.IsNullOrEmpty(title))
{
where.Append(" and C_STL_GRD like '%" + title + "%'");
}
if (!string.IsNullOrEmpty(start) && !string.IsNullOrEmpty(end))
{
where.Append(" and D_MOD_DT between to_date('" + start + "', 'yyyy-mm-dd hh24:mi:ss') and to_date('" + Convert.ToDateTime(end).AddDays(1).ToString() + "', 'yyyy-mm-dd hh24:mi:ss')");
}
if (!string.IsNullOrEmpty(state))
{
where.Append("and N_STATE=" + state + "");
}
string sql = ByPage.GenerateByPageSql(pageSize, startIndex, item, table, order, where.ToString());
return(DbHelperOra.Query(sql));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMC_TECH_CONSULT GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_QUEST_ID,C_CUST_NAME,C_CUST_CODE,C_STL_GRD,C_USE_DESC,C_REMARK,C_EMP_ID,C_EMP_NAME,D_MOD_DT,C_DEPT,C_EMP,D_PLAN_DT,D_FINISH_DT,C_REAL_TIME,C_RESULT,C_LEAVE_Q,C_REMARK2,N_CUST_EVAL,N_STATE,D_CUST_EVAL_DT,N_XG_EVAL,C_XG_EVAL_EMP,D_XG_EVAL_DT,C_ORDER_NO from TMC_TECH_CONSULT ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TMC_TECH_CONSULT model = new Mod_TMC_TECH_CONSULT();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TB_BCBZ model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TB_BCBZ(");
strSql.Append("D_START,D_END,C_BC,C_BZ,C_EMP_ID,D_MOD_DT,C_PRO_ID)");
strSql.Append(" values (");
strSql.Append(":D_START,:D_END,:C_BC,:C_BZ,:C_EMP_ID,:D_MOD_DT,:C_PRO_ID)");
OracleParameter[] parameters =
{
new OracleParameter(":D_START", OracleDbType.Date),
new OracleParameter(":D_END", OracleDbType.Date),
new OracleParameter(":C_BC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BZ", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_PRO_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.D_START;
parameters[1].Value = model.D_END;
parameters[2].Value = model.C_BC;
parameters[3].Value = model.C_BZ;
parameters[4].Value = model.C_EMP_ID;
parameters[5].Value = model.D_MOD_DT;
parameters[6].Value = model.C_PRO_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TSC_SLAB_MAIN GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_PLAN_ID,C_ORD_NO,C_STOVE,C_STA_ID,C_STA_CODE,C_STA_DESC,C_STL_GRD,C_STL_GRD_PRE,C_MAT_CODE,C_MAT_NAME,C_SPEC,N_LEN,N_QUA,N_WGT,C_STD_CODE,C_SLAB_TYPE,D_CCM_DATE,C_CCM_SHIFT,C_CCM_GROUP,C_CCM_EMP_ID,C_MOVE_TYPE,C_SC_STATE,D_ESC_DATE,D_LSC_DATE,C_QKP_STATE,C_KP_ID,C_CON_NO,C_CUS_NO,C_CUS_NAME,D_WL_DATE,C_WL_SHIFT,C_WL_GROUP,C_WL_EMP_ID,D_WE_DATE,C_WE_SHIFT,C_WE_GROUP,C_WE_EMP_ID,C_STOCK_STATE,C_MAT_TYPE,C_QGP_STATE,C_SLABWH_CODE,C_SLABWH_AREA_CODE,C_SLABWH_LOC_CODE,C_SLABWH_TIER_CODE,C_Q_RESULT,D_Q_DATE,C_Q_NOTE,N_WGT_METER,C_QF_NAME,C_DESIGN_NO,C_ZRBM,C_IS_DEPOT,C_ISXM,C_XMGX,C_ISFREE from TSC_SLAB_MAIN ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TSC_SLAB_MAIN model = new Mod_TSC_SLAB_MAIN();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TS_USER GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_NAME,C_ACCOUNT,C_PASSWORD,C_EMAIL,C_MOBILE,N_TYPE,N_STATUS,C_DESC,D_LASTLOGINTIME,C_EMP_ID,C_EMP_NAME,D_MOD_DT,C_MOBILE2,C_PHONE,C_SHORTNAME,C_CUST_ID,C_TOKEN_ID,C_CJNAME,C_CJINTRO,C_STL_GRD,C_LEGALREPRES,C_CGJCR,C_JOB,C_JCTEL,C_ADDRESS,C_AREA,C_MANAGER,N_TYPE from TS_USER ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TS_USER model = new Mod_TS_USER();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TQB_STD_SPEC GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_STD_MAIN_ID,C_SPEC,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT from TQB_STD_SPEC ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TQB_STD_SPEC model = new Mod_TQB_STD_SPEC();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMB_NOTICE GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_CLASS,C_TITLE,C_PICURL,C_LINK,C_CONTENT,C_FILE,N_SORT,C_REMARK,N_STATUS,C_EMP_ID,C_EMP_NAME,D_MOD_DT from TMB_NOTICE ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TMB_NOTICE model = new Mod_TMB_NOTICE();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMC_CUST_BOOK GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,D_ZF_DT,C_CUST_NAME,C_AREA,C_CUST_MANAGE,C_CUST_EMP,C_CUST_EMP_TEL,C_MEETING_CUST,C_MEETING_XG,C_MAIN_CONTENT,C_NEED_S_Q,C_LEAVE_Q,C_STL_GRD,C_PRO_USE,C_SITE,C_REMARK,N_TYPE from TMC_CUST_BOOK ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TMC_CUST_BOOK model = new Mod_TMC_CUST_BOOK();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public void AddExportLog(string empName)
{
string strSql = $"INSERT INTO TMC_TRAIN_EXPORT_LOG(C_EMPNAME)VALUES('{empName}')";
DbHelperOra.ExecuteSql(strSql);
}
/// <summary>
/// 获取火运报备计划-发运日计划申请
/// </summary>
/// <param name="conno"></param>
/// <returns></returns>
public DataSet GetTrain(string conno, string stlgrd, string spec, string custname, string startdt, string enddt, string area)
{
string strSql = $@"SELECT T.C_AREA,
T.C_CON_NO,
T.C_ORDER_NO,
B.C_NO AS C_CUSTNO,
B.C_NAME AS C_CUSTNAME,
B.C_EXTEND1 AS C_KH_BANK,
B.C_TAXPAYERNO AS C_TAXNO,
B.C_EXTEND2 AS C_ACCOUNT,
B.C_EXTEND4 AS C_TEL,
B.C_EXTEND3 AS C_ADDRESS,
T.C_SPEC,
T.C_STL_GRD,
T.D_DT,
T.C_MAT_CODE,
T.C_STD_CODE,
T.N_WGT, --原订单量
TMC.N_WGT AS PLANWGT, --计划量
TRC.N_WGT KCWGT,
(SELECT A.C_NAME
FROM TS_CUSTFILE A
WHERE A.C_NC_M_ID = T.C_RECEIPTCORPID) AS C_DH_COMPANY
FROM TMO_CON_ORDER T
LEFT JOIN TS_CUSTFILE B
ON B.C_NO = T.C_CUST_NO
LEFT JOIN (SELECT SUM(C.N_WGT) N_WGT, C.C_BILLCODE
FROM TMC_TRAIN_ITEM C
WHERE C.C_FLAG = '1'
GROUP BY C.C_BILLCODE) TMC
ON TMC.C_BILLCODE = T.C_ORDER_NO
LEFT JOIN (SELECT SUM(T.N_WGT) N_WGT,
T.C_MAT_CODE,
T.C_STD_CODE,
T.C_SALE_AREA,
T.C_CON_NO,
T.C_CUST_NAME
FROM TRC_ROLL_PRODCUT T
WHERE T.C_MOVE_TYPE = 'E' AND T.C_IS_QR = 'Y'
GROUP BY T.C_MAT_CODE,
T.C_STD_CODE,
T.C_SALE_AREA,
T.C_CON_NO,
T.C_CUST_NAME) TRC
ON TRC.C_MAT_CODE = T.C_MAT_CODE
AND TRC.C_STD_CODE = T.C_STD_CODE
AND TRC.C_SALE_AREA = T.C_AREA
AND SUBSTR(TRC.C_CON_NO, 0, 15) = SUBSTR(T.C_CON_NO, 0, 15)
AND TRC.C_CUST_NAME = T.C_CUST_NAME
WHERE T.N_STATUS = 2
AND NVL(TRC.N_WGT, 0) > 0";
if (!string.IsNullOrEmpty(area))
{
strSql += $" AND T.C_AREA='{area}'";
}
if (!string.IsNullOrEmpty(conno))
{
strSql += $" AND T.C_CON_NO LIKE '%{conno}%'";
}
if (!string.IsNullOrEmpty(stlgrd))
{
strSql += $" AND T.C_STL_GRD LIKE '%{stlgrd}%'";
}
if (!string.IsNullOrEmpty(spec))
{
strSql += $" AND T.C_SPEC LIKE '%{spec}%'";
}
if (!string.IsNullOrEmpty(custname))
{
strSql += $" AND T.C_CUST_NAME LIKE '%{custname}%'";
}
if (!string.IsNullOrEmpty(startdt) && !string.IsNullOrEmpty(enddt))
{
strSql += $@" AND T.D_DT >= TO_DATE('{startdt}', 'yyyy-mm-dd hh24:mi:ss') AND T.D_DT<= to_date('{enddt} 23:59:59', 'yyyy-mm-dd hh24:mi:ss')";
}
return(DbHelperOra.Query(strSql));
}
/// <summary>
/// 删除计划号
/// </summary>
/// <param name="C_ID"></param>
/// <returns></returns>
public bool DelTrainPlan(string C_ID)
{
string strSql = $"DELETE FROM TMC_TRAIN WHERE C_ID='{C_ID}'";
return(DbHelperOra.ExecuteSql(strSql) > 0 ? true : false);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TRC_ROLL_QTCKD_ITEM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TRC_ROLL_QTCKD_ITEM(");
strSql.Append("C_QTCKD_NO,C_BATCH_NO,C_JUDGE_LEV_ZH,C_MAT_CODE,C_MAT_DESC,C_STL_GRD,C_SPEC,N_NUM,N_WGT,C_Z_DW,C_F_DW,C_STOVE,C_ZYX1,C_ZYX2,C_BZYQ,C_ZYX4,N_STATUS,C_LINEWH_CODE,D_PRODUCE_DATE,C_JUDGE_LEV_BP,C_STD_CODE,N_SJNUM,N_SJWGT)");
strSql.Append(" values (");
strSql.Append(":C_QTCKD_NO,:C_BATCH_NO,:C_JUDGE_LEV_ZH,:C_MAT_CODE,:C_MAT_DESC,:C_STL_GRD,:C_SPEC,:N_NUM,:N_WGT,:C_Z_DW,:C_F_DW,:C_STOVE,:C_ZYX1,:C_ZYX2,:C_BZYQ,:C_ZYX4,:N_STATUS,:C_LINEWH_CODE,:D_PRODUCE_DATE,:C_JUDGE_LEV_BP,:C_STD_CODE,:N_SJNUM,:N_SJWGT)");
OracleParameter[] parameters =
{
new OracleParameter(":C_QTCKD_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_JUDGE_LEV_ZH", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":N_NUM", OracleDbType.Int16, 15),
new OracleParameter(":N_WGT", OracleDbType.Int16, 15),
new OracleParameter(":C_Z_DW", OracleDbType.Varchar2, 100),
new OracleParameter(":C_F_DW", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STOVE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ZYX1", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ZYX2", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BZYQ", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ZYX4", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Int16, 1),
new OracleParameter(":C_LINEWH_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":D_PRODUCE_DATE", OracleDbType.Date),
new OracleParameter(":C_JUDGE_LEV_BP", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_SJNUM", OracleDbType.Int16, 15),
new OracleParameter(":N_SJWGT", OracleDbType.Int16, 15)
};
parameters[0].Value = model.C_QTCKD_NO;
parameters[1].Value = model.C_BATCH_NO;
parameters[2].Value = model.C_JUDGE_LEV_ZH;
parameters[3].Value = model.C_MAT_CODE;
parameters[4].Value = model.C_MAT_DESC;
parameters[5].Value = model.C_STL_GRD;
parameters[6].Value = model.C_SPEC;
parameters[7].Value = model.N_NUM;
parameters[8].Value = model.N_WGT;
parameters[9].Value = model.C_Z_DW;
parameters[10].Value = model.C_F_DW;
parameters[11].Value = model.C_STOVE;
parameters[12].Value = model.C_ZYX1;
parameters[13].Value = model.C_ZYX2;
parameters[14].Value = model.C_BZYQ;
parameters[15].Value = model.C_ZYX4;
parameters[16].Value = model.N_STATUS;
parameters[17].Value = model.C_LINEWH_CODE;
parameters[18].Value = model.D_PRODUCE_DATE;
parameters[19].Value = model.C_JUDGE_LEV_BP;
parameters[20].Value = model.C_STD_CODE;
parameters[21].Value = model.N_SJNUM;
parameters[22].Value = model.N_SJWGT;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除火运计划
/// </summary>
/// <param name="mod"></param>
/// <returns></returns>
public bool Del(Mod_TMC_TRAIN_ITEM mod)
{
string strSql = $"DELETE FROM TMC_TRAIN_ITEM WHERE C_ID='{mod.C_ID}'";
return(DbHelperOra.ExecuteSql(strSql) > 0 ? true : false);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMQ_QUALITY_MAIN model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TMQ_QUALITY_MAIN(");
strSql.Append("C_ID,C_QUEST_ID,C_PROD_KIND_ID,C_SHIPVIA,D_SHIP_START_DT,D_SHIP_END_DT,N_PARENT_REMAIN_WGT,N_MIDDLE_REMAIN_WGT,C_AREA,C_CUST_NAME,C_CUST_TYPE,C_CUST_NO,C_TEL,C_NAME,C_STL_GRD_CLASS,C_PROD_USE,N_OBJECT_COUNT_WGT,C_OBJECT_CONTENT,C_TECH_DESC,C_SITE_SURVEY_CONTENT,N_PARENT_QUA,N_QUEST_QUA,N_MIDDLE_QUA,N_ELSE_QUA,C_SITE_SURVEY_EMP,C_DEPT,C_REMARK,C_CUST_MAKING,C_CUST_MAKING_DT,C_XG_MODIFY,C_XG_MODEIFY_DT,C_APPROVER,D_APPROVER_DT,C_FLOW_ID,N_STATUS,N_FLAG,C_EMP_ID,C_EMP_NAME,D_MOD_DT,C_DEPT2,C_DEPT3,C_DEPT4)");
strSql.Append(" values (");
strSql.Append(":C_ID,:C_QUEST_ID,:C_PROD_KIND_ID,:C_SHIPVIA,:D_SHIP_START_DT,:D_SHIP_END_DT,:N_PARENT_REMAIN_WGT,:N_MIDDLE_REMAIN_WGT,:C_AREA,:C_CUST_NAME,:C_CUST_TYPE,:C_CUST_NO,:C_TEL,:C_NAME,:C_STL_GRD_CLASS,:C_PROD_USE,:N_OBJECT_COUNT_WGT,:C_OBJECT_CONTENT,:C_TECH_DESC,:C_SITE_SURVEY_CONTENT,:N_PARENT_QUA,:N_QUEST_QUA,:N_MIDDLE_QUA,:N_ELSE_QUA,:C_SITE_SURVEY_EMP,:C_DEPT,:C_REMARK,:C_CUST_MAKING,:C_CUST_MAKING_DT,:C_XG_MODIFY,:C_XG_MODEIFY_DT,:C_APPROVER,:D_APPROVER_DT,:C_FLOW_ID,:N_STATUS,:N_FLAG,:C_EMP_ID,:C_EMP_NAME,:D_MOD_DT,:C_DEPT2,:C_DEPT3,:C_DEPT4)");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_QUEST_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PROD_KIND_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SHIPVIA", OracleDbType.Varchar2, 100),
new OracleParameter(":D_SHIP_START_DT", OracleDbType.Date),
new OracleParameter(":D_SHIP_END_DT", OracleDbType.Date),
new OracleParameter(":N_PARENT_REMAIN_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":N_MIDDLE_REMAIN_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":C_AREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_TYPE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_TEL", OracleDbType.Varchar2, 20),
new OracleParameter(":C_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD_CLASS", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PROD_USE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_OBJECT_COUNT_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":C_OBJECT_CONTENT", OracleDbType.Varchar2, 200),
new OracleParameter(":C_TECH_DESC", OracleDbType.Varchar2, 200),
new OracleParameter(":C_SITE_SURVEY_CONTENT", OracleDbType.Varchar2, 200),
new OracleParameter(":N_PARENT_QUA", OracleDbType.Decimal, 2),
new OracleParameter(":N_QUEST_QUA", OracleDbType.Decimal, 2),
new OracleParameter(":N_MIDDLE_QUA", OracleDbType.Decimal, 2),
new OracleParameter(":N_ELSE_QUA", OracleDbType.Decimal, 2),
new OracleParameter(":C_SITE_SURVEY_EMP", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DEPT", OracleDbType.Varchar2, 100),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":C_CUST_MAKING", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_MAKING_DT", OracleDbType.Date),
new OracleParameter(":C_XG_MODIFY", OracleDbType.Varchar2, 100),
new OracleParameter(":C_XG_MODEIFY_DT", OracleDbType.Date),
new OracleParameter(":C_APPROVER", OracleDbType.Varchar2, 100),
new OracleParameter(":D_APPROVER_DT", OracleDbType.Date),
new OracleParameter(":C_FLOW_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":N_FLAG", OracleDbType.Decimal, 1),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 20),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_DEPT2", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DEPT3", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DEPT4", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_QUEST_ID;
parameters[2].Value = model.C_PROD_KIND_ID;
parameters[3].Value = model.C_SHIPVIA;
parameters[4].Value = model.D_SHIP_START_DT;
parameters[5].Value = model.D_SHIP_END_DT;
parameters[6].Value = model.N_PARENT_REMAIN_WGT;
parameters[7].Value = model.N_MIDDLE_REMAIN_WGT;
parameters[8].Value = model.C_AREA;
parameters[9].Value = model.C_CUST_NAME;
parameters[10].Value = model.C_CUST_TYPE;
parameters[11].Value = model.C_CUST_NO;
parameters[12].Value = model.C_TEL;
parameters[13].Value = model.C_NAME;
parameters[14].Value = model.C_STL_GRD_CLASS;
parameters[15].Value = model.C_PROD_USE;
parameters[16].Value = model.N_OBJECT_COUNT_WGT;
parameters[17].Value = model.C_OBJECT_CONTENT;
parameters[18].Value = model.C_TECH_DESC;
parameters[19].Value = model.C_SITE_SURVEY_CONTENT;
parameters[20].Value = model.N_PARENT_QUA;
parameters[21].Value = model.N_QUEST_QUA;
parameters[22].Value = model.N_MIDDLE_QUA;
parameters[23].Value = model.N_ELSE_QUA;
parameters[24].Value = model.C_SITE_SURVEY_EMP;
parameters[25].Value = model.C_DEPT;
parameters[26].Value = model.C_REMARK;
parameters[27].Value = model.C_CUST_MAKING;
parameters[28].Value = model.C_CUST_MAKING_DT;
parameters[29].Value = model.C_XG_MODIFY;
parameters[30].Value = model.C_XG_MODEIFY_DT;
parameters[31].Value = model.C_APPROVER;
parameters[32].Value = model.D_APPROVER_DT;
parameters[33].Value = model.C_FLOW_ID;
parameters[34].Value = model.N_STATUS;
parameters[35].Value = model.N_FLAG;
parameters[36].Value = model.C_EMP_ID;
parameters[37].Value = model.C_EMP_NAME;
parameters[38].Value = model.D_MOD_DT;
parameters[39].Value = model.C_DEPT2;
parameters[40].Value = model.C_DEPT3;
parameters[41].Value = model.C_DEPT4;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TRC_ROLL_QTCKD_ITEM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TRC_ROLL_QTCKD_ITEM set ");
strSql.Append("C_QTCKD_NO=:C_QTCKD_NO,");
strSql.Append("C_BATCH_NO=:C_BATCH_NO,");
strSql.Append("C_JUDGE_LEV_ZH=:C_JUDGE_LEV_ZH,");
strSql.Append("C_MAT_CODE=:C_MAT_CODE,");
strSql.Append("C_MAT_DESC=:C_MAT_DESC,");
strSql.Append("C_STL_GRD=:C_STL_GRD,");
strSql.Append("C_SPEC=:C_SPEC,");
strSql.Append("N_NUM=:N_NUM,");
strSql.Append("N_WGT=:N_WGT,");
strSql.Append("C_Z_DW=:C_Z_DW,");
strSql.Append("C_F_DW=:C_F_DW,");
strSql.Append("C_STOVE=:C_STOVE,");
strSql.Append("C_ZYX1=:C_ZYX1,");
strSql.Append("C_ZYX2=:C_ZYX2,");
strSql.Append("C_BZYQ=:C_BZYQ,");
strSql.Append("C_ZYX4=:C_ZYX4,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("C_LINEWH_CODE=:C_LINEWH_CODE,");
strSql.Append("D_PRODUCE_DATE=:D_PRODUCE_DATE,");
strSql.Append("C_JUDGE_LEV_BP=:C_JUDGE_LEV_BP,");
strSql.Append("C_STD_CODE=:C_STD_CODE,");
strSql.Append("N_SJNUM=:N_SJNUM,");
strSql.Append("N_SJWGT=:N_SJWGT");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_QTCKD_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_JUDGE_LEV_ZH", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":N_NUM", OracleDbType.Int16, 15),
new OracleParameter(":N_WGT", OracleDbType.Int16, 15),
new OracleParameter(":C_Z_DW", OracleDbType.Varchar2, 100),
new OracleParameter(":C_F_DW", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STOVE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ZYX1", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ZYX2", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BZYQ", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ZYX4", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Int16, 1),
new OracleParameter(":C_LINEWH_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":D_PRODUCE_DATE", OracleDbType.Date),
new OracleParameter(":C_JUDGE_LEV_BP", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_SJNUM", OracleDbType.Int16, 15),
new OracleParameter(":N_SJWGT", OracleDbType.Int16, 15),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_QTCKD_NO;
parameters[1].Value = model.C_BATCH_NO;
parameters[2].Value = model.C_JUDGE_LEV_ZH;
parameters[3].Value = model.C_MAT_CODE;
parameters[4].Value = model.C_MAT_DESC;
parameters[5].Value = model.C_STL_GRD;
parameters[6].Value = model.C_SPEC;
parameters[7].Value = model.N_NUM;
parameters[8].Value = model.N_WGT;
parameters[9].Value = model.C_Z_DW;
parameters[10].Value = model.C_F_DW;
parameters[11].Value = model.C_STOVE;
parameters[12].Value = model.C_ZYX1;
parameters[13].Value = model.C_ZYX2;
parameters[14].Value = model.C_BZYQ;
parameters[15].Value = model.C_ZYX4;
parameters[16].Value = model.N_STATUS;
parameters[17].Value = model.C_LINEWH_CODE;
parameters[18].Value = model.D_PRODUCE_DATE;
parameters[19].Value = model.C_JUDGE_LEV_BP;
parameters[20].Value = model.C_STD_CODE;
parameters[21].Value = model.N_SJNUM;
parameters[22].Value = model.N_SJWGT;
parameters[23].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMQ_QUALITY_MAIN model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TMQ_QUALITY_MAIN set ");
strSql.Append("C_QUEST_ID=:C_QUEST_ID,");
strSql.Append("C_PROD_KIND_ID=:C_PROD_KIND_ID,");
strSql.Append("C_SHIPVIA=:C_SHIPVIA,");
strSql.Append("D_SHIP_START_DT=:D_SHIP_START_DT,");
strSql.Append("D_SHIP_END_DT=:D_SHIP_END_DT,");
strSql.Append("N_PARENT_REMAIN_WGT=:N_PARENT_REMAIN_WGT,");
strSql.Append("N_MIDDLE_REMAIN_WGT=:N_MIDDLE_REMAIN_WGT,");
strSql.Append("C_AREA=:C_AREA,");
strSql.Append("C_CUST_NAME=:C_CUST_NAME,");
strSql.Append("C_CUST_TYPE=:C_CUST_TYPE,");
strSql.Append("C_CUST_NO=:C_CUST_NO,");
strSql.Append("C_TEL=:C_TEL,");
strSql.Append("C_NAME=:C_NAME,");
strSql.Append("C_STL_GRD_CLASS=:C_STL_GRD_CLASS,");
strSql.Append("C_PROD_USE=:C_PROD_USE,");
strSql.Append("N_OBJECT_COUNT_WGT=:N_OBJECT_COUNT_WGT,");
strSql.Append("C_OBJECT_CONTENT=:C_OBJECT_CONTENT,");
strSql.Append("C_TECH_DESC=:C_TECH_DESC,");
strSql.Append("C_SITE_SURVEY_CONTENT=:C_SITE_SURVEY_CONTENT,");
strSql.Append("N_PARENT_QUA=:N_PARENT_QUA,");
strSql.Append("N_QUEST_QUA=:N_QUEST_QUA,");
strSql.Append("N_MIDDLE_QUA=:N_MIDDLE_QUA,");
strSql.Append("N_ELSE_QUA=:N_ELSE_QUA,");
strSql.Append("C_SITE_SURVEY_EMP=:C_SITE_SURVEY_EMP,");
strSql.Append("C_DEPT=:C_DEPT,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("C_CUST_MAKING=:C_CUST_MAKING,");
strSql.Append("C_CUST_MAKING_DT=:C_CUST_MAKING_DT,");
strSql.Append("C_XG_MODIFY=:C_XG_MODIFY,");
strSql.Append("C_XG_MODEIFY_DT=:C_XG_MODEIFY_DT,");
strSql.Append("C_APPROVER=:C_APPROVER,");
strSql.Append("D_APPROVER_DT=:D_APPROVER_DT,");
strSql.Append("C_FLOW_ID=:C_FLOW_ID,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("N_FLAG=:N_FLAG,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("C_EMP_NAME=:C_EMP_NAME,");
strSql.Append("D_MOD_DT=:D_MOD_DT,");
strSql.Append("C_DEPT2=:C_DEPT2,");
strSql.Append("C_DEPT3=:C_DEPT3,");
strSql.Append("C_DEPT4=:C_DEPT4");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_QUEST_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PROD_KIND_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SHIPVIA", OracleDbType.Varchar2, 100),
new OracleParameter(":D_SHIP_START_DT", OracleDbType.Date),
new OracleParameter(":D_SHIP_END_DT", OracleDbType.Date),
new OracleParameter(":N_PARENT_REMAIN_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":N_MIDDLE_REMAIN_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":C_AREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_TYPE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_TEL", OracleDbType.Varchar2, 20),
new OracleParameter(":C_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD_CLASS", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PROD_USE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_OBJECT_COUNT_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":C_OBJECT_CONTENT", OracleDbType.Varchar2, 200),
new OracleParameter(":C_TECH_DESC", OracleDbType.Varchar2, 200),
new OracleParameter(":C_SITE_SURVEY_CONTENT", OracleDbType.Varchar2, 200),
new OracleParameter(":N_PARENT_QUA", OracleDbType.Decimal, 2),
new OracleParameter(":N_QUEST_QUA", OracleDbType.Decimal, 2),
new OracleParameter(":N_MIDDLE_QUA", OracleDbType.Decimal, 2),
new OracleParameter(":N_ELSE_QUA", OracleDbType.Decimal, 2),
new OracleParameter(":C_SITE_SURVEY_EMP", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DEPT", OracleDbType.Varchar2, 100),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":C_CUST_MAKING", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_MAKING_DT", OracleDbType.Date),
new OracleParameter(":C_XG_MODIFY", OracleDbType.Varchar2, 100),
new OracleParameter(":C_XG_MODEIFY_DT", OracleDbType.Date),
new OracleParameter(":C_APPROVER", OracleDbType.Varchar2, 100),
new OracleParameter(":D_APPROVER_DT", OracleDbType.Date),
new OracleParameter(":C_FLOW_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":N_FLAG", OracleDbType.Decimal, 1),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 20),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_DEPT2", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DEPT3", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DEPT4", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_QUEST_ID;
parameters[1].Value = model.C_PROD_KIND_ID;
parameters[2].Value = model.C_SHIPVIA;
parameters[3].Value = model.D_SHIP_START_DT;
parameters[4].Value = model.D_SHIP_END_DT;
parameters[5].Value = model.N_PARENT_REMAIN_WGT;
parameters[6].Value = model.N_MIDDLE_REMAIN_WGT;
parameters[7].Value = model.C_AREA;
parameters[8].Value = model.C_CUST_NAME;
parameters[9].Value = model.C_CUST_TYPE;
parameters[10].Value = model.C_CUST_NO;
parameters[11].Value = model.C_TEL;
parameters[12].Value = model.C_NAME;
parameters[13].Value = model.C_STL_GRD_CLASS;
parameters[14].Value = model.C_PROD_USE;
parameters[15].Value = model.N_OBJECT_COUNT_WGT;
parameters[16].Value = model.C_OBJECT_CONTENT;
parameters[17].Value = model.C_TECH_DESC;
parameters[18].Value = model.C_SITE_SURVEY_CONTENT;
parameters[19].Value = model.N_PARENT_QUA;
parameters[20].Value = model.N_QUEST_QUA;
parameters[21].Value = model.N_MIDDLE_QUA;
parameters[22].Value = model.N_ELSE_QUA;
parameters[23].Value = model.C_SITE_SURVEY_EMP;
parameters[24].Value = model.C_DEPT;
parameters[25].Value = model.C_REMARK;
parameters[26].Value = model.C_CUST_MAKING;
parameters[27].Value = model.C_CUST_MAKING_DT;
parameters[28].Value = model.C_XG_MODIFY;
parameters[29].Value = model.C_XG_MODEIFY_DT;
parameters[30].Value = model.C_APPROVER;
parameters[31].Value = model.D_APPROVER_DT;
parameters[32].Value = model.C_FLOW_ID;
parameters[33].Value = model.N_STATUS;
parameters[34].Value = model.N_FLAG;
parameters[35].Value = model.C_EMP_ID;
parameters[36].Value = model.C_EMP_NAME;
parameters[37].Value = model.D_MOD_DT;
parameters[38].Value = model.C_DEPT2;
parameters[39].Value = model.C_DEPT3;
parameters[40].Value = model.C_DEPT4;
parameters[41].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TB_STA model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TB_STA set ");
strSql.Append("C_PRO_ID=:C_PRO_ID,");
strSql.Append("C_STA_CODE=:C_STA_CODE,");
strSql.Append("C_STA_DESC=:C_STA_DESC,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("D_MOD_DT=:D_MOD_DT,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("D_START_DATE=:D_START_DATE,");
strSql.Append("D_END_DATE=:D_END_DATE,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("C_STA_ERPCODE=:C_STA_ERPCODE,");
strSql.Append("C_STA_MESCODE=:C_STA_MESCODE,");
strSql.Append("N_SORT=:N_SORT,");
strSql.Append("C_ERP_PK=:C_ERP_PK");
strSql.Append(" WHERE C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_PRO_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STA_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STA_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":D_START_DATE", OracleDbType.Date),
new OracleParameter(":D_END_DATE", OracleDbType.Date),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_STA_ERPCODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STA_MESCODE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_SORT", OracleDbType.Decimal, 3),
new OracleParameter(":C_ERP_PK", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_PRO_ID;
parameters[1].Value = model.C_STA_CODE;
parameters[2].Value = model.C_STA_DESC;
parameters[3].Value = model.C_EMP_ID;
parameters[4].Value = model.D_MOD_DT;
parameters[5].Value = model.C_REMARK;
parameters[6].Value = model.D_START_DATE;
parameters[7].Value = model.D_END_DATE;
parameters[8].Value = model.N_STATUS;
parameters[9].Value = model.C_STA_ERPCODE;
parameters[10].Value = model.C_STA_MESCODE;
parameters[11].Value = model.N_SORT;
parameters[12].Value = model.C_ERP_PK;
parameters[13].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加火运日计划单据号
/// </summary>
/// <param name="mod"></param>
/// <returns></returns>
public bool Insert(Mod_TMC_TRAIN_MAIN mod)
{
string strSql = $@"INSERT INTO TMC_TRAIN_MAIN(C_ID,C_EMPID,C_EMPNAME,C_SHIPVIA)VALUES('{mod.C_ID}','{mod.C_EMPID}','{mod.C_EMPNAME}','火运代垫（销售）')";
return(DbHelperOra.ExecuteSql(strSql) > 0 ? true : false);
}
/// <summary>
/// 火运/汽运审核
/// </summary>
/// <param name="fyd">发运单</param>
/// <param name="emp">制单人</param>
/// <param name="conno">合同号</param>
/// <param name="cust">客户</param>
/// <param name="stlgrd">钢种</param>
/// <param name="spec">规格</param>
/// <param name="ischeck">是否审核</param>
/// <param name="flag">是否监控</param>
/// <param name="startDT">提报开始时间</param>
/// <param name="endDT">提报截至时间</param>
/// <returns></returns>
public DataSet GetTrainMain(string fyd, string emp, string conno, string cust, string stlgrd, string spec, string ischeck, string flag, string startDT, string endDT, string fyfs, string station, string area, string xfwgt)
{
string strSql = $@"SELECT T.C_ID,
T.C_STATION,
T.C_SHIPVIA,
T.D_DT,
T.D_CHECKTIME,
T.C_CHECKEMP,
T.C_EMPNAME,
T.C_ISCHECK,
A.C_AREA,
A.C_CONNO,
A.C_DH_COMPANY,
A.C_STL_GRD,
A.C_SPEC,
A.N_WGT,
NVL(B.C_FLAG, 'N') C_FLAG,
A.C_ID AS C_ID2
FROM TMC_TRAIN_MAIN T
INNER JOIN TMC_TRAIN_ITEM A
ON A.C_PKID = T.C_ID
LEFT JOIN TMB_MONI_STLGRD B
ON B.C_STL_GRD = A.C_STL_GRD WHERE T.C_ISCHECK='{ischeck}'";
if (!string.IsNullOrEmpty(fyd))
{
strSql += $" AND T.C_ID = '{fyd}'";
}
if (!string.IsNullOrEmpty(emp))
{
strSql += $" AND T.C_EMPNAME = '{emp}'";
}
if (!string.IsNullOrEmpty(conno))
{
strSql += $" AND A.C_CONNO = '{conno}'";
}
if (!string.IsNullOrEmpty(cust))
{
strSql += $" AND A.C_DH_COMPANY='{cust}'";
}
if (!string.IsNullOrEmpty(stlgrd))
{
strSql += $" AND A.C_STL_GRD='{stlgrd}'";
}
if (!string.IsNullOrEmpty(spec))
{
strSql += $" AND A.C_SPEC LIKE '%{spec}%'";
}
if (!string.IsNullOrEmpty(flag))
{
strSql += $" AND B.C_FLAG='{flag}'";
}
if (!string.IsNullOrEmpty(startDT) && !string.IsNullOrEmpty(endDT))
{
strSql += $@" AND T.D_DT BETWEEN TO_DATE('{startDT}', 'yyyy-mm-dd hh24:mi:ss') AND to_date('{endDT} 23:59:59', 'yyyy-mm-dd hh24:mi:ss')";
}
if (!string.IsNullOrEmpty(fyfs))
{
strSql += $" AND T.C_SHIPVIA='{fyfs}'";
}
if (!string.IsNullOrEmpty(station))
{
strSql += $" AND T.C_STATION LIKE '%{station}%'";
}
if (!string.IsNullOrEmpty(area))
{
strSql += $" AND A.C_AREA = '{area}'";
}
if (!string.IsNullOrEmpty(xfwgt))
{
DataView dv = DbHelperOra.Query(strSql).Tables[0].DefaultView;
dv.Sort = "N_WGT ASC";
DataTable dt = dv.ToTable();
string listID = "";
var list = new List <string>();
decimal wgt = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
wgt = wgt + Convert.ToDecimal(dt.Rows[i]["N_WGT"]);
list.Add(dt.Rows[i]["C_ID2"].ToString());
if (wgt >= Convert.ToDecimal(xfwgt))
{
break;
}
}
listID = "'" + string.Join("','", list.ToArray()) + "'";
if (!string.IsNullOrEmpty(listID))
{
strSql += $" AND A.C_ID IN({listID})";
}
return(DbHelperOra.Query(strSql));
}
else
{
return(DbHelperOra.Query(strSql));
}
}
/// <summary>
/// 获取火运计划子表数据
/// </summary>
/// <param name="pkID"></param>
/// <returns></returns>
public DataSet GetList(string pkID)
{
string strSql = $"SELECT * FROM TMC_TRAIN_ITEM T WHERE T.C_PKID='{pkID}'";
return(DbHelperOra.Query(strSql));
}