public int checkedPExceptionTypesDal(string ExceptionTypes, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@et", SqlDbType.VarChar, 80)
{
Value = ExceptionTypes
}
};
return(Convert.ToInt32(SQLhelp.ExecuteScalar(sql, CommandType.Text, pms)));
}
/// <summary>
/// 检查产能设置抬头表
/// </summary>
/// <param name="ProductClass"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int checkProductSet_New_titleDal(string ProductClass, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@productcalss", SqlDbType.VarChar, 100)
{
Value = ProductClass
}
};
return(Convert.ToInt32(SQLhelp.ExecuteScalar(sql, CommandType.Text, pms)));
}
/// <summary>
/// 检查是否已存在编码
/// </summary>
/// <param name="barcodeEncoding"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int checkedPEncodingSettingDal(string barcodeEncoding, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@be", SqlDbType.VarChar, 100)
{
Value = barcodeEncoding
}
};
return(Convert.ToInt32(SQLhelp.ExecuteScalar(sql, CommandType.Text, pms)));
}
/// <summary>
/// 查询货物剩余数量
/// </summary>
/// <param name="MaterialName"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int PWarehouseTable_DetailedPWarehouseTable_PickingOutSUMDal(string MaterialName, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@MaterialName", SqlDbType.VarChar, 80)
{
Value = MaterialName
}
};
return((int)SQLhelp.ExecuteScalar(sql, CommandType.Text, pms));
}
/// <summary>
/// 检查姓名工号是否存在
/// </summary>
/// <param name="name"></param>
/// <param name="worknumber"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int checkedPStaffResumeDal(string name, string worknumber, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@name", SqlDbType.VarChar, 20)
{
Value = name
},
new SqlParameter("@worknumber", SqlDbType.VarChar, 50)
{
Value = worknumber
}
};
return(Convert.ToInt32(SQLhelp.ExecuteScalar(sql, CommandType.Text, pms)));
}
/// <summary>
/// 检测是否存在单号
/// </summary>
/// <param name="Zhidan"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int CheckedPAbnormalInputDal(string Zhidan, string problem, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@zhidan", SqlDbType.VarChar, 100)
{
Value = Zhidan
},
new SqlParameter("@problem", SqlDbType.VarChar, 200)
{
Value = problem
}
};
return(Convert.ToInt32(SQLhelp.ExecuteScalar(sql, CommandType.Text, pms)));
}
/// <summary>
/// 检查数据是否存在
/// </summary>
/// <param name="CorporateName"></param>
/// <param name="ZhiDan"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int checkedPMCplan_tableDal(string CorporateName, string ZhiDan, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@corporatename", SqlDbType.VarChar, 50)
{
Value = CorporateName
},
new SqlParameter("@zhidan", SqlDbType.VarChar, 100)
{
Value = ZhiDan
}
};
return(Convert.ToInt32(SQLhelp.ExecuteScalar(sql, CommandType.Text, pms)));
}
public Object selectPCapacityConfigurationProductClassDal(string txtOrder, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@zd", SqlDbType.VarChar, 80)
{
Value = txtOrder
}
};
try
{
return(SQLhelp.ExecuteScalar(sql, CommandType.Text, pms));
}
catch
{
throw;
}
}
/// <summary>
/// 查询产能抬头表Top1
/// </summary>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public string selectProductSet_New_titleTop1Dal(string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
return(SQLhelp.ExecuteScalar(sql, CommandType.Text).ToString());
}