/// <summary>
/// 查询产品配置表明细
/// </summary>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public List <ProductSet_New> selectProductSet_NewDal(string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
List <ProductSet_New> list = new List <ProductSet_New>();
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new ProductSet_New()
{
ProductClass = reader.GetString(0),
Stations = reader.GetString(1),
EfficiencyQuantity = reader.IsDBNull(2)?"0":reader.GetString(2),
TheNumberOf = reader.IsDBNull(3)?"0":reader.GetString(3),
UpdateTime = reader.GetDateTime(4)
});
}
}
return(list);
}
}
catch
{
throw;
}
}
/// <summary>
/// 根据公司名查找工位
/// </summary>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public List <string> selectProductionTypeOnWorkTimeTypeDal(string OnWorkTimeType, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
List <string> list = new List <string>();
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@OnWorkTimeType", SqlDbType.VarChar, 50)
{
Value = OnWorkTimeType
}
};
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text, pms))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(reader.GetString(0));
}
}
return(list);
}
}
catch
{
throw;
}
}
/// <summary>
/// 查询工位表
/// </summary>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public List <ProductionType> selectProductionTypeDal(string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
List <ProductionType> list = new List <ProductionType>();
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new ProductionType()
{
ProductType = reader.GetString(0).Trim(),
Command = reader.IsDBNull(1) ? "" : reader.GetString(1),
Command1 = reader.IsDBNull(2) ? "" : reader.GetString(2),
Command2 = reader.IsDBNull(3)?"":reader.GetString(3),
OnWorkTimeType = reader.IsDBNull(4)?"":reader.GetString(4),
Command3 = reader.IsDBNull(5)?"":reader.GetString(5),
OnWorkTimeTypeNight = reader.IsDBNull(6)?"":reader.GetString(6)
});
}
}
return(list);
}
}
catch
{
throw;
}
}
public List <ProductionLinePC_title> selectProductionLinePC_titleDal(string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
List <ProductionLinePC_title> list = new List <ProductionLinePC_title>();
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new ProductionLinePC_title()
{
CompanyName = reader.IsDBNull(1) ? "" : reader.GetString(1),
LineName = reader.IsDBNull(0) ? "" : reader.GetString(0)
});
}
}
return(list);
}
}
catch
{
throw;
}
}
public List<Users> selectPUsersDal(string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
List<Users> list = new List<Users>();
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new Users()
{
UserName=reader.GetString(0),
UserPassword=reader.GetString(1),
systemAdimin=reader.GetBoolean(2),
Limite=reader.GetBoolean(3),
Department=reader.IsDBNull(4)?"":reader.GetString(4),
AddUser=reader.GetBoolean(5)
});
}
}
return list;
}
}
catch
{
throw;
}
}
/// <summary>
/// 查询
/// </summary>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public List <PUsers_Function_Detailed> selectPUsers_Function_DetailedDal(string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
List <PUsers_Function_Detailed> list = new List <PUsers_Function_Detailed>();
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new PUsers_Function_Detailed()
{
UserName = reader.GetString(0),
FunctionName = reader.GetString(1),
FunctionJurisdiction = reader.GetBoolean(2),
FunctionGUID = reader.GetString(3)
});
}
}
return(list);
}
}
catch
{
throw;
}
}
/// <summary>
/// 插入
/// </summary>
/// <param name="data"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int insertTimeAttendance_AttendanceInformation_machineDal(TimeAttendance_AttendanceInformation_machine data, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@MachineID", SqlDbType.VarChar, 50)
{
Value = data.MachineID
},
new SqlParameter("@ComInterface", SqlDbType.VarChar, 50)
{
Value = data.ComInterface
},
new SqlParameter("@BaudRate", SqlDbType.VarChar, 50)
{
Value = data.BaudRate
},
new SqlParameter("@IPAddress", SqlDbType.VarChar, 50)
{
Value = data.IPAddress
},
new SqlParameter("@MachinePosition", SqlDbType.VarChar, 80)
{
Value = data.MachinePosition
},
new SqlParameter("@MachineUse", SqlDbType.VarChar, 50)
{
Value = data.MachineUse
},
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
public int insertProductionLinePCDal(List <ProductionLinePC> list, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@pcname", SqlDbType.VarChar, 100)
{
Value = list[0].Pcname
},
new SqlParameter("@producttype", SqlDbType.VarChar, 20)
{
Value = list[0].ProductType
},
new SqlParameter("@linename", SqlDbType.VarChar, 80)
{
Value = list[0].LineName
},
new SqlParameter("@companyname", SqlDbType.VarChar, 50)
{
Value = list[0].CompanyName
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 修改权限
/// </summary>
/// <param name="list"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int updatePUsers_FunctionDal(List <PUsers_Function> list, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@UserName", SqlDbType.VarChar, 50)
{
Value = list[0].UserName
},
new SqlParameter("@FunctionGUID", SqlDbType.VarChar, 100)
{
Value = list[0].FunctionGUID
},
new SqlParameter("@FunctionName", SqlDbType.VarChar, 50)
{
Value = list[0].FunctionName
},
new SqlParameter("@NewFunctionJurisdiction", SqlDbType.Bit)
{
Value = list[0].FunctionJurisdiction
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 查询
/// </summary>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public List <PRequiredTime_Detailed> selectPRequiredTime_DetailedDal(string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
List <PRequiredTime_Detailed> list = new List <PRequiredTime_Detailed>();
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new PRequiredTime_Detailed()
{
ProductType = reader.GetString(0),
RequiredTimeGUID = reader.GetString(1),
RequiredTime = reader.GetDouble(2)
});
}
}
return(list);
}
}
catch
{
throw;
}
}
/// <summary>
/// 查询产能配置抬头表
/// </summary>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public List <ProductSet_New_title> selectProductSet_New_titleDal(string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
List <ProductSet_New_title> list = new List <ProductSet_New_title>();
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new ProductSet_New_title()
{
Id = reader.GetInt32(0),
ProductClass = reader.GetString(1),
UpdateTime = reader.GetDateTime(2)
});
}
}
return(list);
}
}
catch
{
throw;
}
}
/// <summary>
/// 查询失败产品表
/// </summary>
/// <param name="order">zhidan号</param>
/// <param name="timeBegin">开始时间</param>
/// <param name="timeEnd">结束时间</param>
/// <param name="SQLCommand">SQL语句</param>
/// <returns>int</returns>
public int selectLTestLogMessageDal(string order, string SoftModel, DateTime timeBegin, DateTime timeEnd, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
if (order != "")
{
sql += " and llm.ZhiDan= " + "'" + order + "'";
}
if (SoftModel != "")
{
sql += " and llm.SoftModel= " + "'" + SoftModel + "'";
}
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@TimeBegin", SqlDbType.DateTime)
{
Value = timeBegin
},
new SqlParameter("@TimeEnd", SqlDbType.DateTime)
{
Value = timeEnd
}
};
try
{
return(Convert.ToInt32(SQLhelp.ExecuteScalar(sql, CommandType.Text, pms)));;
}
catch
{
throw;
}
}
public List <PFunctionMenu> selectPFunctionMenuFID00Dal(string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
List <PFunctionMenu> list = new List <PFunctionMenu>();
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new PFunctionMenu()
{
ID = reader.GetString(0),
FunctionName = reader.GetString(1),
FID = reader.GetString(2)
});
}
}
return(list);
}
}
catch
{
throw;
}
}
/// <summary>
/// 插入产能配置表
/// </summary>
/// <param name="list"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int insertProductSet_NewDal(List <ProductSet_New> list, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@productcalss", SqlDbType.VarChar, 100)
{
Value = list[0].ProductClass
},
new SqlParameter("@stations", SqlDbType.VarChar, 50)
{
Value = list[0].Stations
},
new SqlParameter("@efficiencyquantity", SqlDbType.VarChar, 100)
{
Value = list[0].EfficiencyQuantity
},
new SqlParameter("@thenumberof", SqlDbType.VarChar, 100)
{
Value = list[0].TheNumberOf
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 查询条件
/// </summary>
/// <param name="SQLComand"></param>
/// <returns></returns>
public List <selectConditionsQueryPStaffResumeModel2> selectConditionsQueryPStaffResumeDal2(string SQLComand)
{
string sql = SQLhelp.GetSQLCommand(SQLComand);
List <selectConditionsQueryPStaffResumeModel2> list = new List <Gce_Model.selectConditionsQueryPStaffResumeModel2>();
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new selectConditionsQueryPStaffResumeModel2()
{
Name = reader.GetString(0),
WorkNumber = reader.GetString(1),
CompanyName = reader.GetString(2)
});
}
}
return(list);
}
}
catch
{
throw;
}
}
/// <summary>
/// 增改
/// </summary>
/// <param name="data"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int insertTimeAttendance_AttendanceScheduleDal(TimeAttendance_AttendanceSchedule data, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@JobNumber", SqlDbType.VarChar, 50)
{
Value = data.JobNumber
},
new SqlParameter("@Name", SqlDbType.VarChar, 80)
{
Value = data.Name
},
new SqlParameter("@AttendanceTime", SqlDbType.DateTime)
{
Value = data.AttendanceTime
},
new SqlParameter("@UpdateTime", SqlDbType.DateTime)
{
Value = data.UpdateTime
},
new SqlParameter("@MachineID", SqlDbType.VarChar, 50)
{
Value = data.MachineID
},
new SqlParameter("@MachinePosition", SqlDbType.VarChar, 50)
{
Value = data.MachinePosition
},
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 插入
/// </summary>
/// <param name="list"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int insertPUsers_Function_DetailedDal(List <PUsers_Function_Detailed> list, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@UserName", SqlDbType.VarChar, 50)
{
Value = list[0].UserName
},
new SqlParameter("@FunctionName", SqlDbType.VarChar, 50)
{
Value = list[0].FunctionName
},
new SqlParameter("@FunctionJurisdiction", SqlDbType.Bit)
{
Value = list[0].FunctionJurisdiction
},
new SqlParameter("@FunctionGUID", SqlDbType.VarChar, 100)
{
Value = list[0].FunctionGUID
},
};
try
{
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
catch
{
throw;
}
}
public List <PWorkSchedule> selectPWorkScheduleDal(string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
List <PWorkSchedule> list = new List <PWorkSchedule>();
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new PWorkSchedule()
{
CompanyName = reader.IsDBNull(0) ? "" : reader.GetString(0),
MorningOnWorkTime = reader.IsDBNull(1) ? "" : reader.GetString(1),
MorningUnderWorkTime = reader.IsDBNull(2) ? "" : reader.GetString(2),
AfternoonOnWorkTime = reader.IsDBNull(3) ? "" : reader.GetString(3),
AfternoonUnderWorkTime = reader.IsDBNull(4) ? "" : reader.GetString(4),
NightOnWorkTime = reader.IsDBNull(5) ? "" : reader.GetString(5),
Flag = reader.GetBoolean(7)
});
}
}
return(list);
}
}
catch
{
throw;
}
}
/// <summary>
/// 查询表中所有数据
/// </summary>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public List <PTypesWork> selectPTypesWorkDal(string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
List <PTypesWork> list = new List <PTypesWork>();
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new PTypesWork()
{
TypesWork = reader.GetString(0)
});
}
}
return(list);
}
}
catch
{
throw;
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="data"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int updateTimeAttendance_DepartmentDal(TimeAttendance_Department data, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@DepartmentNo", SqlDbType.VarChar, 50)
{
Value = data.DepartmentNo
},
new SqlParameter("@DepartmentName", SqlDbType.VarChar, 80)
{
Value = data.DepartmentName
},
new SqlParameter("@NumberOfStaff", SqlDbType.Int)
{
Value = data.NumberOfStaff
},
new SqlParameter("@InTheNumberOfStaff", SqlDbType.Int)
{
Value = data.InTheNumberOfStaff
},
new SqlParameter("@ExceedNumberOfStaff", SqlDbType.Int)
{
Value = data.ExceedNumberOfStaff
},
new SqlParameter("@note", SqlDbType.VarChar, 255)
{
Value = data.note
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
public List <TimeAttendance_AttendanceInformation_machine> selectTimeAttendance_AttendanceInformation_machineDal(string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
List <TimeAttendance_AttendanceInformation_machine> list = new List <TimeAttendance_AttendanceInformation_machine>();
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new TimeAttendance_AttendanceInformation_machine()
{
MachineID = reader.GetString(0),
ComInterface = reader.IsDBNull(1)?"":reader.GetString(1),
BaudRate = reader.IsDBNull(2) ? "" : reader.GetString(2),
IPAddress = reader.IsDBNull(3) ? "" : reader.GetString(3),
MachinePosition = reader.IsDBNull(4) ? "" : reader.GetString(4),
MachineUse = reader.IsDBNull(5) ? "" : reader.GetString(5),
});
}
}
return(list);
}
}
catch
{
throw;
}
}
public List <TimeAttendance_Department> selectAllTimeAttendance_EmployeeParentDepartmentNoDal(string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
List <TimeAttendance_Department> list = new List <TimeAttendance_Department>();
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new TimeAttendance_Department()
{
DepartmentNo = reader.GetString(0),
DepartmentName = reader.IsDBNull(1) ? "" : reader.GetString(1)
});
}
}
return(list);
}
}
catch
{
throw;
}
}
public List <string> selectProductionLinePC_titleLineNameDal(string CompanyName, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
List <string> list = new List <string>();
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@companyname", SqlDbType.VarChar, 50)
{
Value = CompanyName
}
};
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text, pms))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(reader.IsDBNull(0) ? "" : reader.GetString(0));
}
}
return(list);
}
}
catch
{
throw;
}
}
/// <summary>
/// 挑选更新
/// </summary>
/// <param name="PurchaseReceiptID"></param>
/// <param name="ChooseNumber"></param>
/// <param name="NotChooseNumber"></param>
/// <param name="ChooseTime1"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int updatePurchaseReceiptChooseDal(string PurchaseReceiptID, int ChooseNumber, int NotChooseNumber, string ChooseName, DateTime ChooseTime1, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@PurchaseReceiptID", SqlDbType.VarChar, 100)
{
Value = PurchaseReceiptID
},
new SqlParameter("@ChooseNumber", SqlDbType.Int)
{
Value = ChooseNumber
},
new SqlParameter("@NotChooseNumber", SqlDbType.Int)
{
Value = NotChooseNumber
},
new SqlParameter("@ChooseTime1", SqlDbType.DateTime)
{
Value = ChooseTime1
},
new SqlParameter("@ChooseName", SqlDbType.VarChar, 50)
{
Value = ChooseName
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 向ProductSet表修改一条数据
/// </summary>
/// <param name="list"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int UpdateProductSetBll(List <ProductSet> list, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@pc", SqlDbType.VarChar, 80)
{
Value = list[0].ProductClass
},
new SqlParameter("@s1", SqlDbType.VarChar, 200)
{
Value = list[0].station1
},
new SqlParameter("@n1", SqlDbType.VarChar, 200)
{
Value = list[0].Numberof1
},
new SqlParameter("@id", SqlDbType.Int)
{
Value = list[0].Id
}
};
try
{
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
catch
{
return(-1);
}
}
/// <summary>
/// 查询异常配置表
/// </summary>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public List <PEncodingSetting> selectPEncodingSettingDal(string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
List <PEncodingSetting> list = new List <PEncodingSetting>();
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new PEncodingSetting()
{
BarcodeEncoding = reader.GetString(0),
ProblemDescription = reader.GetString(1),
ES_ExceptionTypes = reader.GetString(2)
});
}
}
return(list);
}
}
catch
{
throw;
}
}
public List <ProductSet> SelectProductTop1Dal(string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
List <ProductSet> list = new List <ProductSet>();
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new ProductSet()
{
ProductClass = reader.GetString(1),
station1 = reader.IsDBNull(2) ? "" : reader.GetString(2),
Numberof1 = reader.IsDBNull(3) ? "" : reader.GetString(3),
Id = reader.GetInt32(0)
});
}
}
return(list);
}
}
catch
{
throw;
}
}
/// <summary>
/// 查询库存数量
/// </summary>
/// <param name="MaterialName"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public ck_StockModel selectPWarehouseTable_DetailedProductQuantityDal(string MaterialName, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
ck_StockModel list = new ck_StockModel();
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@MaterialName", SqlDbType.VarChar, 80)
{
Value = MaterialName
}
};
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text, pms))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.MaterialName = reader.IsDBNull(0)?"":reader.GetString(0);
list.ProductQuantity = reader.IsDBNull(1) ? 0 : reader.GetInt32(1);
}
}
return(list);
}
}
catch
{
throw;
}
}
/// <summary>
/// 查询所有数据
/// </summary>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public List <PCapacityConfiguration> selectPCapacityConfigurationDal(string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
List <PCapacityConfiguration> list = new List <PCapacityConfiguration>();
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new PCapacityConfiguration
{
ZhiDan = reader.GetString(0),
ProductClass = reader.GetString(1)
});
}
}
return(list);
}
}
catch
{
throw;
}
}
/// <summary>
/// 检查用户名是否存在
/// </summary>
/// <param name="UserName">用户名</param>
/// <param name="SQLCommand">SQK命令</param>
/// <returns>int</returns>
public int checkUserNemeDal(string UserName,string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]{
new SqlParameter("@username",SqlDbType.VarChar,50){Value=UserName}
};
return (int)SQLhelp.ExecuteScalar(sql, CommandType.Text, pms);
}