/// <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="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="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;
}
}
/// <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));
}
/// <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 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));
}
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="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));
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="UserName"></param>
/// <param name="Userpassword"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int UpdatePasswordDal(string UserName,string Userpassword,string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]{
new SqlParameter("@username",SqlDbType.VarChar,50){Value=UserName},
new SqlParameter("@password",SqlDbType.VarChar,100){Value=Userpassword}
};
return SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="pware"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int insertPWarehouseTable_DetailedDal(PWarehouseTable_Detailed pware, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@PurchaseReceiptID", SqlDbType.VarChar, 100)
{
Value = pware.PurchaseReceiptID
},
new SqlParameter("@PurchaseNo", SqlDbType.VarChar, 80)
{
Value = pware.PurchaseNo
},
new SqlParameter("@SupplierName", SqlDbType.VarChar, 80)
{
Value = pware.SupplierName
},
new SqlParameter("@BatchNo", SqlDbType.VarChar, 80)
{
Value = pware.BatchNo
},
new SqlParameter("@MaterialCode", SqlDbType.VarChar, 80)
{
Value = pware.MaterialCode
},
new SqlParameter("@MaterialName", SqlDbType.VarChar, 80)
{
Value = pware.MaterialName
},
new SqlParameter("@MaterialSpecifications", SqlDbType.VarChar, 80)
{
Value = pware.MaterialSpecifications
},
new SqlParameter("@ProductQuantity", SqlDbType.Int)
{
Value = pware.ProductQuantity
},
new SqlParameter("@note", SqlDbType.VarChar, 200)
{
Value = pware.note
},
new SqlParameter("@StorageAddress", SqlDbType.VarChar, 255)
{
Value = pware.StorageAddress
},
new SqlParameter("@UserName", SqlDbType.VarChar, 50)
{
Value = pware.UserName
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 修改用户表权限
/// </summary>
/// <param name="UserName"></param>
/// <param name="Limite"></param>
/// <param name="SQLComman"></param>
/// <returns></returns>
public int updatePUsersDal(string UserName,bool Limite, string SQLComman)
{
string sql = SQLhelp.GetSQLCommand(SQLComman);
SqlParameter[] pms = new SqlParameter[]{
new SqlParameter("@UserName",SqlDbType.VarChar,50){Value=UserName},
new SqlParameter("@Limite",SqlDbType.Bit){Value=Limite}
};
return SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms);
}
/// <summary>
/// 质检更新合格率
/// </summary>
/// <param name="incoming"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int updatePurchaseReceiptQualifiedDal(IncomingInspectionModel incoming, bool WhetherQualified, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@CheckQualified", SqlDbType.VarChar, 50)
{
Value = incoming.CheckQualified
},
new SqlParameter("@CheckQualifiedUserName", SqlDbType.VarChar, 50)
{
Value = incoming.CheckQualifiedUserName
},
new SqlParameter("@QualifiedTime1", SqlDbType.DateTime)
{
Value = incoming.QualifiedTime1
},
new SqlParameter("@QualifiedTime2", SqlDbType.DateTime)
{
Value = incoming.QualifiedTime2
},
new SqlParameter("@QualifiedRate", SqlDbType.Float)
{
Value = incoming.QualifiedRate
},
new SqlParameter("@PurchaseReceiptID", SqlDbType.VarChar, 100)
{
Value = incoming.PurchaseReceiptID
},
new SqlParameter("@WhetherQualified", SqlDbType.Bit)
{
Value = WhetherQualified
},
new SqlParameter("@CheckNumber", SqlDbType.Int)
{
Value = incoming.CheckNumber
},
new SqlParameter("@classType", SqlDbType.VarChar, 80)
{
Value = incoming.classType
},
new SqlParameter("@ProblemDescription", SqlDbType.VarChar, 255)
{
Value = incoming.ProblemDescription
},
new SqlParameter("@CheckAudit", SqlDbType.VarChar, 80)
{
Value = WhetherQualified?"审核":"未审核"
},
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 插入ProductionEfficiencySummary表
/// </summary>
/// <param name="list"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int InsertProductionEfficiencySummaryDal(List <ProductionEfficiencyModel> list, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@ProductionClass", SqlDbType.VarChar, 20)
{
Value = list[0].ProductionClass
},
new SqlParameter("@ZhiDan", SqlDbType.VarChar, 100)
{
Value = list[0].Order
},
new SqlParameter("@SoftModel", SqlDbType.VarChar, 100)
{
Value = list[0].SoftModel
},
new SqlParameter("@ProductClass", SqlDbType.VarChar, 80)
{
Value = list[0].ProductClass
},
new SqlParameter("@Hours", SqlDbType.Int)
{
Value = list[0].Hours
},
new SqlParameter("@actualHours", SqlDbType.Int)
{
Value = list[0].actualHours
},
new SqlParameter("@Ratio", SqlDbType.Float)
{
Value = list[0].Ratio
},
new SqlParameter("@sumHours", SqlDbType.Float)
{
Value = list[0].sumHours
},
new SqlParameter("@sum", SqlDbType.Int)
{
Value = list[0].sum
},
new SqlParameter("@FailureRate", SqlDbType.Float)
{
Value = list[0].FailureRate
},
new SqlParameter("@FailureNuber", SqlDbType.Int)
{
Value = list[0].FailureNuber
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 删除异常配置
/// </summary>
/// <param name="BarcodeEncoding"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int deletePEncodingSettingDal(string BarcodeEncoding, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@be", SqlDbType.VarChar, 100)
{
Value = BarcodeEncoding
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
///像异常类型表插入信息
/// </summary>
/// <param name="ExceptionTypes"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int insertPExceptionTypesDal(string ExceptionTypes, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@et", SqlDbType.VarChar, 80)
{
Value = ExceptionTypes
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
public int deletePWorkScheduleDal(string CompanyName, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@cn", SqlDbType.VarChar, 50)
{
Value = CompanyName
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
//删除
public int deletePAbnormalInputDal(int ID, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@id", SqlDbType.Int)
{
Value = ID
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="PurchaseReceiptID"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int deletePurchaseReceiptDal(string PurchaseReceiptID, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@PurchaseReceiptID", SqlDbType.VarChar, 100)
{
Value = PurchaseReceiptID
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 删除产能配置表中的数据
/// </summary>
/// <param name="ProductClass"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int deleteProductSet_New_titleDal(string ProductClass, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@productcalss", SqlDbType.VarChar, 100)
{
Value = ProductClass
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 向表中插入一条数据
/// </summary>
/// <param name="list"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int insertPTypesWorkDal(List <PTypesWork> list, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@typeswork", SqlDbType.VarChar, 50)
{
Value = list[0].TypesWork
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="ID"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int deletePWarehouseTable_titleDal(string ID, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@ID", SqlDbType.VarChar, 80)
{
Value = ID
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="data"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int deleteTimeAttendance_DepartmentDal(TimeAttendance_Department data, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@DepartmentNo", SqlDbType.VarChar, 50)
{
Value = data.DepartmentNo
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="list"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int insertUsersDal(List<Users> list,string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]{
new SqlParameter("@UserName",SqlDbType.VarChar,50){Value=list[0].UserName},
new SqlParameter("@UserPassword",SqlDbType.VarChar,100){Value=list[0].UserPassword},
new SqlParameter("@systemAdimin",SqlDbType.Bit){Value=list[0].systemAdimin},
new SqlParameter("@Limite",SqlDbType.Bit){Value=list[0].Limite},
new SqlParameter("@Department",SqlDbType.VarChar,100){Value=list[0].Department},
new SqlParameter("@AddUser",SqlDbType.Bit){Value=list[0].AddUser}
};
return SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="MachineID"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int deleteTimeAttendance_AttendanceInformation_machineDal(string MachineID, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@MachineID", SqlDbType.VarChar, 50)
{
Value = MachineID
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 增加异常类别
/// </summary>
/// <param name="classType"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int insertClassType_tableDal(string classType, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@classType", SqlDbType.VarChar, 80)
{
Value = classType
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 更新员工信息
/// </summary>
/// <param name="oldName"></param>
/// <param name="oldWorkNumber"></param>
/// <param name="list"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int updatePStaffResumeDal(string oldName, string oldWorkNumber, List <PStaffResume> list, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@name", SqlDbType.VarChar, 20)
{
Value = list[0].Name
},
new SqlParameter("@worknumber", SqlDbType.VarChar, 50)
{
Value = list[0].WorkNumber
},
new SqlParameter("@gender", SqlDbType.VarChar, 4)
{
Value = list[0].Gender
},
new SqlParameter("@age", SqlDbType.VarChar, 6)
{
Value = list[0].Age
},
new SqlParameter("@worktype", SqlDbType.VarChar, 80)
{
Value = list[0].WorkTypes
},
new SqlParameter("@levels", SqlDbType.VarChar, 50)
{
Value = list[0].Levels
},
new SqlParameter("@factorytime", SqlDbType.DateTime)
{
Value = list[0].FactoryTime
},
new SqlParameter("@companyname", SqlDbType.VarChar, 120)
{
Value = list[0].CompanyName
},
new SqlParameter("@name1", SqlDbType.VarChar, 20)
{
Value = oldName
},
new SqlParameter("@worknumber1", SqlDbType.VarChar, 50)
{
Value = oldWorkNumber
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="CorporateName"></param>
/// <param name="ZhiDan"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int deletePMCplan_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(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 审核更新
/// </summary>
/// <param name="PurchaseReceiptID"></param>
/// <param name="CheckSpecialMining"></param>
/// <param name="CheckAuditUserName"></param>
/// <param name="WhetherQualified"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int updatePurchaseReceiptIncomingAuditDal(string PurchaseReceiptID, string CheckAudit, string CheckSpecialMining, string CheckAuditUserName, string note, string AttributionResponsibility, string Presentation8D, bool WhetherQualified, string ReturnGoods, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@CheckAudit", SqlDbType.VarChar, 50)
{
Value = CheckAudit
},
new SqlParameter("@PurchaseReceiptID", SqlDbType.VarChar, 100)
{
Value = PurchaseReceiptID
},
new SqlParameter("@CheckSpecialMining", SqlDbType.VarChar, 80)
{
Value = CheckSpecialMining
},
new SqlParameter("@CheckAuditUserName", SqlDbType.VarChar, 50)
{
Value = CheckAuditUserName
},
new SqlParameter("@WhetherQualified", SqlDbType.Bit)
{
Value = WhetherQualified
},
new SqlParameter("@note", SqlDbType.VarChar, 8000)
{
Value = note
},
new SqlParameter("@AttributionResponsibility", SqlDbType.VarChar, 50)
{
Value = AttributionResponsibility
},
new SqlParameter("@Presentation8D", SqlDbType.VarChar, 50)
{
Value = Presentation8D
},
new SqlParameter("@ReturnGoods", SqlDbType.VarChar, 20)
{
Value = SqlNull(ReturnGoods)
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 删除员工信息
/// </summary>
/// <param name="name"></param>
/// <param name="worknumber"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int deletePStaffResumeDal(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(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
