/// <summary>
/// 根据产线 和 商品获取对应的产能信息
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList <Base_ProductionLines> GetAllDomainByLineNoAndGoodNos(QueryCondition query)
{
var parameters = WriteAdoTemplate.CreateDbParameters();
StringBuilder strSql = new StringBuilder();
//子产品
// strSql.Append("select distinct Base_ProductionLine.GoodNo,People,Number from[Base_ProductionLines]");
// strSql.Append("left join [Base_ProductionLine] on Base_ProductionLine.ID=[Base_ProductionLines].ProLineId");
// strSql.AppendFormat(@" left join (select SonGoodNo as GoodNo,SonGoodName as GoodName from
// Pro_ShipPlan
//left join Pro_ShipPlanMain on Pro_ShipPlanMain.ID = Pro_ShipPlan.MainId
//inner join [dbo].[Base_Bom_View] on GoodNo=Base_Bom_View.ParentGoodNo
//where Pro_ShipPlanMain.ProNo='{0}') as TB ON TB.GoodNo=Base_ProductionLine.GoodNo", query.GetCondition("ShipMainProNo").Value);
// strSql.AppendFormat(" where ProLineNo='{0}'", query.GetCondition("LineNo").Value);
// strSql.AppendFormat(" and People in({0})", query.GetCondition("People").Value);
// strSql.Append(" union all ");
//成品
strSql.Append("select distinct Base_ProductionLine.GoodNo,People,Number from[Base_ProductionLines]");
strSql.Append("left join [Base_ProductionLine] on Base_ProductionLine.ID=[Base_ProductionLines].ProLineId");
strSql.Append(@" left join Pro_ShipPlan on Pro_ShipPlan.GoodNo=Base_ProductionLine.GoodNo
left join Pro_ShipPlanMain on Pro_ShipPlanMain.ID = Pro_ShipPlan.MainId");
strSql.AppendFormat(" where ProLineNo='{0}'", query.GetCondition("LineNo").Value);
strSql.AppendFormat(" and Pro_ShipPlanMain.ProNo='{0}'", query.GetCondition("ShipMainProNo").Value);
strSql.AppendFormat(" and People in({0})", query.GetCondition("People").Value);
return(ReadAdoTemplate.QueryWithRowMapperDelegate <Base_ProductionLines>(CommandType.Text, strSql.ToString(), MapRowByLineNoAndGoodNos, parameters));
}
/// <summary>
/// 重新填充Base_Bom_View 表信息
/// </summary>
/// <returns></returns>
public bool ReSetView()
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"truncate table Base_Bom_View;
with t as
(select a.ParentGoodNo ,a.SonGoodNo ,a.BiLi,a.ParentGoodName,a.SonGoodName
from Base_Bom a
where not exists(select 1 from Base_Bom b where b.SonGoodNo=a.ParentGoodNo)
union all
select d.ParentGoodNo,c.SonGoodNo,c.BiLi*d.BiLi,d.ParentGoodName,c.SonGoodName
from Base_Bom c
inner join t d on c.ParentGoodNo=d.SonGoodNo
)
insert into Base_Bom_View
select ParentGoodNo ,SonGoodNo ,BiLi,ParentGoodName,SonGoodName from (
select a.ParentGoodNo,a.SonGoodNo,a.BiLi,
case when not exists(select 1 from Base_Bom b where b.ParentGoodNo=a.SonGoodNo)
then '底层' else '' end as 'BiaoShi',a.ParentGoodName,a.SonGoodName
from t a ) as TopBom where BiaoShi=''
union
select a.ParentGoodNo ,a.SonGoodNo ,a.BiLi,a.ParentGoodName,a.SonGoodName
from Base_Bom a");
var parameters = WriteAdoTemplate.CreateDbParameters();
return(ReadAdoTemplate.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 保存 权限
/// </summary>
/// <param name="roleId">角色</param>
/// <param name="allMenuids">所有展开的窗口</param>
/// <param name="selectedFormIds">所有选中的窗口</param>
/// <param name="selectedFunctionIds">所有选中的窗口方法</param>
/// <param name="userName">用户名称</param>
/// <returns></returns>
//[Transaction(ReadOnly = false)]
public bool SaveRole_FormAndFunctioin(int roleId, string allMenuids, string selectedFormIds, string selectedFunctionIds, string userName = "")
{
Role_FormDao roleFormDao = new Role_FormDao();
Role_FunctionDao roleFunctionDao = new Role_FunctionDao();
string deleteFromAndFunction = string.Format("delete from SetUp_Role_Function where RoleId={0} and FormId in (select Id from SetUp_Form where MenuId in ({1})); delete from SetUp_Role_Form where Role_Id={0} and Form_Id in (select Id from SetUp_Form where MenuId in ({1}));", roleId, allMenuids);
ReadAdoTemplate.ExecuteNonQuery(CommandType.Text, deleteFromAndFunction);
foreach (var formId in selectedFormIds.Split(','))
{
var model = new Role_FormDomain {
Form_Id = Convert.ToInt32(formId), Role_Id = roleId, CreateTime = DateTime.Now, UpdateTime = DateTime.Now, Creater = userName, Updater = userName
};
roleFormDao.Add(model);
}
if (!string.IsNullOrEmpty(selectedFunctionIds))
{
foreach (var function_FormId in selectedFunctionIds.Split(','))
{
var functionFormId = function_FormId.Split('_');//0 FORMID 1 FUNCTIONID
var model = new Role_FunctionDomain {
FormId = Convert.ToInt32(functionFormId[0]), FunctionId = Convert.ToInt32(functionFormId[1]), RoleId = roleId, CreateTime = DateTime.Now, UpdateTime = DateTime.Now, Creater = userName, Updater = userName
};
roleFunctionDao.Add(model);
}
}
//ReadAdoTemplate.DbProvider.
//var a = 0;
//if (1 / a==0)
//{
//}
return(true);
}
/// <summary>
/// 获取信息列表 导出到Excel
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList <Pro_PSDetail> GetAllDomainToExcel(QueryCondition query, Hashtable hs)
{
var parameters = WriteAdoTemplate.CreateDbParameters();
StringBuilder strSql = new StringBuilder();
strSql.Append(@"select ProLineNo, ProDate,GoodNo,GoodName,ShipTo,ShipToName,Qty,SType,StartTime,EndTime
FROM Pro_PSDetail left join Pro_PS on Pro_PS.Id = Pro_PSDetail.[MainId] where 1=1 ");
if (query.GetCondition("ProNo") != null)
{
strSql.AppendFormat(" and ProNo like '%{0}%'", query.GetCondition("ProNo").Value);
}
if (query.GetCondition("ProLineNo") != null)
{
strSql.AppendFormat(" and ProLineNo like '%{0}%'", query.GetCondition("ProLineNo").Value);
}
if (query.GetCondition("ProDate") != null)
{
strSql.AppendFormat(" and ProDate >='{0}'", query.GetCondition("ProDate").Value);
}
if (hs.ContainsKey("ProDateTo"))
{
strSql.AppendFormat(" and ProDate <='{0}'", hs["ProDateTo"]);
}
if (query.GetCondition("SchedulingProNo") != null)
{
strSql.AppendFormat(" and SchedulingProNo like '%{0}%'", query.GetCondition("SchedulingProNo").Value);
}
strSql.Append(" order by ProDate,[ProOrderIndex] ");
return(ReadAdoTemplate.QueryWithRowMapperDelegate <Pro_PSDetail>(CommandType.Text, strSql.ToString(), MapRowToExcel, parameters));
}
/// <summary>
/// 获取信息列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public override IList <Pro_Scheduling> GetAllDomain(QueryCondition query)
{
var parameters = WriteAdoTemplate.CreateDbParameters();
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" Id,ProNo,ShipMainProNo,PlanFromDate,PlanToDate,CreateTime,Creater,UpdateTime,Updater,RowState ");
strSql.Append(" from Pro_Scheduling ");
string otherWhere = "";
if (query.GetCondition("PlanFromDate") != null)
{
}
if (query.GetPager() != null)
{
strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters, otherWhere));
}
else
{
strSql.Append(query.GetSQL_Where(parameters));
strSql.Append(query.GetSQL_Order());
}
return(ReadAdoTemplate.QueryWithRowMapperDelegate <Pro_Scheduling>(CommandType.Text, strSql.ToString(), MapRow, parameters));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public override bool Update(AlipayDetailDomain entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update AlipayDetail set ");
strSql.Append("AppId=@AppId,");
strSql.Append("BatchNumber=@BatchNumber,");
strSql.Append("AlipayPlayDate=@AlipayPlayDate,");
strSql.Append("SceneryRate=@SceneryRate,");
strSql.Append("SceneryName=@SceneryName,");
strSql.Append("Buyer_logon_id=@Buyer_logon_id,");
strSql.Append("Out_trade_no=@Out_trade_no,");
strSql.Append("Send_pay_date=@Send_pay_date,");
strSql.Append("Total_amount=@Total_amount,");
strSql.Append("Trade_no=@Trade_no,");
strSql.Append("Trade_status=@Trade_status,");
strSql.Append("Code=@Code,");
strSql.Append("Msg=@Msg,");
strSql.Append("UpdateTime=@UpdateTime,");
strSql.Append("Updater=@Updater,");
strSql.Append("RowState=@RowState");
strSql.Append(" where Id=@Id ");
var parameters = GetBaseParams(entity);
parameters.Add("ID", DbType.Int32, 0).Value = entity.Id;
return(ReadAdoTemplate.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public override bool Update(Pro_PS entity)
{
//修改数据时 同时删除子数据明细
string deleteSQL = string.Format("delete from Pro_PSDetail where MainId={0}", entity.Id);
ReadAdoTemplate.ExecuteNonQuery(CommandType.Text, deleteSQL);
//修改数据
StringBuilder strSql = new StringBuilder();
strSql.Append("update Pro_PS set ");
strSql.Append("SchedulingProNo=@SchedulingProNo,");
strSql.Append("ProNo=@ProNo,");
strSql.Append("ProLineNo=@ProLineNo,");
strSql.Append("LineId=@LineId,");
strSql.Append("ProDate=@ProDate,");
strSql.Append("FinalMorningNum=@FinalMorningNum,");
strSql.Append("FinalMiddleNum=@FinalMiddleNum,");
strSql.Append("FinalEveningNum=@FinalEveningNum,");
//strSql.Append("CreateTime=@CreateTime,");
//strSql.Append("Creater=@Creater,");
strSql.Append("UpdateTime=@UpdateTime,");
strSql.Append("Updater=@Updater,");
strSql.Append("RowState=@RowState");
strSql.Append(" where Id=@Id");
var parameters = GetBaseParams(entity);
parameters.Add("ID", DbType.Int32, 0).Value = entity.Id;
return(ReadAdoTemplate.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public override bool Update(UserDomain entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SetUp_User set ");
strSql.Append("loginId=@loginId,");
//strSql.Append("loginPwd=@loginPwd,");
strSql.Append("loginState=@loginState,");
strSql.Append("Name=@Name,");
strSql.Append("UserState=@UserState,");
strSql.Append("Phone=@Phone,");
strSql.Append("Email=@Email,");
strSql.Append("Sex=@Sex,");
strSql.Append("Position=@Position,");
strSql.Append("Leader=@Leader,");
strSql.Append("Company=@Company,");
strSql.Append("Avatar=@Avatar,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("Creater=@Creater,");
strSql.Append("UpdateTime=@UpdateTime,");
strSql.Append("Updater=@Updater,");
strSql.Append("RowState=@RowState");
strSql.Append(" where ID=@ID");
var parameters = GetBaseParams(entity);
parameters.Add("ID", DbType.Int32, 0).Value = entity.Id;
return(ReadAdoTemplate.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters) > 0);
}
public bool Add_Update_User_Role(UserDomain entity, string roleIds, string userName)
{
if (entity.Id > 0)
{
Update(entity);
string sql = "delete from SetUp_Role_User where User_Id=" + entity.Id;
ReadAdoTemplate.ExecuteNonQuery(CommandType.Text, sql);
}
else
{
Add(entity);
}
if (!string.IsNullOrEmpty(roleIds))
{
var roleUserDao = new Role_UserDao();
foreach (var roleId in roleIds.Split(','))
{
var model = new Role_UserDomain
{
User_Id = entity.Id,
Role_Id = Convert.ToInt32(roleId),
CreateTime = DateTime.Now,
UpdateTime = DateTime.Now,
Creater = userName,
Updater = userName
};
roleUserDao.Add(model);
}
}
return(true);
}
/// <summary>
/// 获取信息列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList <SceneryOrderRefundDomain> GetAllDomain(QueryCondition query, Hashtable hsWhere)
{
query.AddEqual("RowState", "1").AddOrderBy("Id", false);
var parameters = WriteAdoTemplate.CreateDbParameters();
StringBuilder strSql = new StringBuilder();
StringBuilder otherWhere = new StringBuilder();
if (hsWhere.ContainsKey("ApprovalStatus"))
{
otherWhere.AppendFormat(" and ApprovalStatus in (0,1)");
}
strSql.Append("select Id,SceneryTCId,SceneryName,BatchNumber,SerialId,PlayDate,Total,ApprovalStatus,PayType,CreateTime,Creater,UpdateTime,Updater,RowState from SceneryOrderRefund ");
if (query.GetPager() != null)
{
string sumSql = "sum(Total) as SumTotal";
strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters, otherWhere.ToString(), sumSql));
}
else
{
strSql.Append(query.GetSQL_Where(parameters));
strSql.Append(otherWhere);
strSql.Append(query.GetSQL_Order());
}
return(ReadAdoTemplate.QueryWithRowMapperDelegate <SceneryOrderRefundDomain>(CommandType.Text, strSql.ToString(), MapRow, parameters));
}
/// <summary>
/// 微信
/// 修改
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public override bool Update(WeChatDetailDomain entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update WeChatDetail set ");
strSql.Append("AppId=@AppId,");
strSql.Append("SceneryName=@SceneryName,");
strSql.Append("BatchNumber=@BatchNumber,");
strSql.Append("SerialId=@SerialId,");
strSql.Append("Result_code=@Result_code,");
strSql.Append("Err_code=@Err_code,");
strSql.Append("Err_code_des=@Err_code_des,");
strSql.Append("Openid=@Openid,");
strSql.Append("Trade_type=@Trade_type,");
strSql.Append("Bank_type=@Bank_type,");
strSql.Append("Total_fee=@Total_fee,");
strSql.Append("Settlement_total_fee=@Settlement_total_fee,");
strSql.Append("Transaction_id=@Transaction_id,");
strSql.Append("Out_trade_no=@Out_trade_no,");
strSql.Append("Time_end=@Time_end,");
strSql.Append("SceneryRate=@SceneryRate,");
strSql.Append("WeChatPlayDate=@WeChatPlayDate,");
strSql.Append("Out_refund_no=@Out_refund_no,");
strSql.Append("Refund_id=@Refund_id,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("Creater=@Creater,");
strSql.Append("UpdateTime=@UpdateTime,");
strSql.Append("Updater=@Updater,");
strSql.Append("RowState=@RowState");
strSql.Append(" where Id=@Id ");
var parameters = GetBaseParams(entity);
parameters.Add("ID", DbType.Int32, 0).Value = entity.Id;
return(ReadAdoTemplate.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public override bool Update(Base_ProductionLine entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Base_ProductionLine set ");
strSql.Append("ProLineNo=@ProLineNo,");
strSql.Append("GoodNo=@GoodNo,");
strSql.Append("GoodName=@GoodName,");
strSql.Append("PCS=@PCS,");
strSql.Append("StandPers=@StandPers,");
strSql.Append("MinProNum=@MinProNum,");
strSql.Append("BoxNum=@BoxNum,");
strSql.Append("LineMins=@LineMins,");
strSql.Append("ProShift=@ProShift,");
strSql.Append("ProCapacityDesc=@ProCapacityDesc,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("Creater=@Creater,");
strSql.Append("UpdateTime=@UpdateTime,");
strSql.Append("Updater=@Updater,");
strSql.Append("RowState=@RowState");
strSql.Append(" where ID=@ID");
var parameters = GetBaseParams(entity);
parameters.Add("ID", DbType.Int32, 0).Value = entity.Id;
return(ReadAdoTemplate.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 获取信息列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList <string> GetGoodName(QueryCondition query)
{
var parameters = WriteAdoTemplate.CreateDbParameters();
StringBuilder strSql = new StringBuilder();
strSql.Append("select GoodNo+','+GoodName as good from Base_Goods where RowState=1 group by GoodNo,GoodName");
return(ReadAdoTemplate.QueryWithRowMapperDelegate <string>(CommandType.Text, strSql.ToString(), MapRowToString, parameters));
}
/// <summary>
/// 获取信息列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public List <Base_Goods> GetBomName(string parentNo, string sonNo)
{
var parameters = WriteAdoTemplate.CreateDbParameters();
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat("select GoodNo,GoodName from Base_Goods where RowState=1 and GoodNo in ('{0}','{1}') group by GoodNo,GoodName ", parentNo, sonNo);
return(ReadAdoTemplate.QueryWithRowMapperDelegate(CommandType.Text, strSql.ToString(), MapRowBomName, parameters).ToList());
}
/// <summary>
/// 跟进用户获取权限菜单
/// </summary>
/// <param name="UserId"></param>
/// <returns></returns>
public IList <FormDomain> GetFormByUserId(int UserId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SetUp_Form.Id,MenuId,FormName,Path,FormIndex,FormImgURL ");
strSql.Append(" FROM SetUp_Role_Form left join SetUp_Form on SetUp_Form.id=SetUp_Role_Form.form_ID ");
strSql.AppendFormat(" where SetUp_Role_Form.Role_Id in (select Role_Id from SetUp_Role_User where User_Id={0}) ORDER BY FormIndex ", UserId);
return(ReadAdoTemplate.QueryWithRowMapperDelegate <FormDomain>(CommandType.Text, strSql.ToString(), MapRow));
}
/// <summary>
/// 修改时 使用
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public IList <Pro_ShipPlan> GetPro_SchedulingByEdit(int Id)
{
var parameters = WriteAdoTemplate.CreateDbParameters();
string sql = string.Format(@"select Pro_SchedulingGoods.Id,ProLineNo,Pro_SchedulingGoods.GoodNo,Pro_SchedulingGoods.GoodName,Pro_SchedulingGoods.ShipTo,Pro_SchedulingGoods.ShipToName,StockNum,PackNum,MorningNum,MiddleNum,EveningNum,ParentGoodNo,ParentGoodName,StandardDays from Pro_SchedulingLine
left join Pro_SchedulingGoods on Pro_SchedulingLine.Id=Pro_SchedulingGoods.SLineId
left join Base_Goods on Base_Goods.GoodNo=Pro_SchedulingGoods.GoodNo and Base_Goods.ShipTo=Pro_SchedulingGoods.ShipTo where [MainId]={0}", Id);
return(ReadAdoTemplate.QueryWithRowMapperDelegate <Pro_ShipPlan>(CommandType.Text, sql, MapPro_SchedulingByEdit, parameters));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public override bool Delete(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Base_Stock ");
strSql.Append(" where ID=@ID ");
var parameters = WriteAdoTemplate.CreateDbParameters();
parameters.Add("ID", DbType.Int32, 0).Value = Id;
return ReadAdoTemplate.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters) > 0;
}
/// <summary>
/// 新增 修改 基本参数
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
private IDbParameters GetBaseParams(Pro_ShipPlans entity)
{
var parameters = ReadAdoTemplate.CreateDbParameters();
parameters.Add("PlanId", DbType.Int32).Value = entity.PlanId;
parameters.Add("PlanDate", DbType.Date).Value = entity.PlanDate;
parameters.Add("PlanNum", DbType.Int32).Value = entity.PlanNum;
return(parameters);
}
/// <summary>
/// 密码修改
/// </summary>
/// <param name="Id"></param>
/// <param name="loginPwd"></param>
/// <returns></returns>
public bool ChangePassword(int Id, string loginPwd)
{
string sql = string.Format("update SetUp_User set loginPwd=@loginPwd where ID=@ID");
var parameters = ReadAdoTemplate.CreateDbParameters();
parameters.Add("loginPwd", SqlDbType.VarChar).Value = loginPwd;
parameters.Add("ID", DbType.Int32, 0).Value = Id;
return(ReadAdoTemplate.ExecuteNonQuery(CommandType.Text, sql, parameters) > 0);
}
/// <summary>
/// 获取信息列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList <FunctionDomain> GetRoleFunctionList(int roleId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SetUp_Function.ID,SetUp_Function.Form_Id,SetUp_Function.FunctionText,SetUp_Function.FunctionName,SetUp_Role_Function.Id as FunId ");
strSql.AppendFormat(" FROM SetUp_Function left join SetUp_Role_Function on SetUp_Role_Function.FunctionId=SetUp_Function.Id and RoleId={0}", roleId);
return(ReadAdoTemplate.QueryWithRowMapperDelegate <FunctionDomain>(CommandType.Text, strSql.ToString(), MapRow_RoleFunction));
}
/// <summary>
/// 获取信息列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList <FormDomain> GetRoleFromList(int roleId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SetUp_Form.Id,SetUp_Form.MenuId,SetUp_Form.FormName,SetUp_Form.Path,SetUp_Form.FormIndex,SetUp_Form.FormImgURL,SetUp_Role_Form.id as RF_Id ");
strSql.AppendFormat(" FROM SetUp_Form left join SetUp_Role_Form on SetUp_Form.id=SetUp_Role_Form.Form_Id and SetUp_Role_Form.Role_Id={0} order by FormIndex", roleId);
return(ReadAdoTemplate.QueryWithRowMapperDelegate <FormDomain>(CommandType.Text, strSql.ToString(), MapRow_Selected));
}
/// <summary>
/// 删除-所有信息
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public bool DeleteAll(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("truncate table [dbo].[Base_LineHour] ");
var parameters = WriteAdoTemplate.CreateDbParameters();
parameters.Add("ID", DbType.Int32, 0).Value = Id;
return(ReadAdoTemplate.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 新增 修改 基本参数
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
private IDbParameters GetBaseParams(Pro_SchedulingGoodsNum entity)
{
var parameters = ReadAdoTemplate.CreateDbParameters();
parameters.Add("SGoodId", DbType.Int32).Value = entity.SGoodId;
parameters.Add("SType", DbType.Int32).Value = entity.SType;
parameters.Add("SDate", DbType.Date).Value = entity.SDate;
parameters.Add("SNum", DbType.Int32).Value = entity.SNum;
return(parameters);
}
/// <summary>
/// 获取信息列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList <RoleDomain> GetUser_RoleList(int UserId)
{
var parameters = WriteAdoTemplate.CreateDbParameters();
StringBuilder strSql = new StringBuilder();
strSql.Append("select SetUp_Role.ID,RoleName,SetUp_Role_User.Id as RU_ID ");
strSql.Append(" FROM SetUp_Role left join SetUp_Role_User on SetUp_Role_User.Role_Id=SetUp_Role.Id and SetUp_Role_User.User_Id=" + UserId);
return(ReadAdoTemplate.QueryWithRowMapperDelegate <RoleDomain>(CommandType.Text, strSql.ToString(), GetUser_RoleList_MapRow, parameters));
}
/// <summary>
/// 新增 修改 基本参数
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
private IDbParameters GetBaseParams(Pro_SchedulingLine entity)
{
var parameters = ReadAdoTemplate.CreateDbParameters();
parameters.Add("MainId", DbType.Int32).Value = entity.MainId;
parameters.Add("ProLineNo", DbType.String).Value = entity.ProLineNo;
parameters.Add("MorningShift", DbType.Int32).Value = entity.MorningShift ?? 0;
parameters.Add("MiddleShift", DbType.Int32).Value = entity.MiddleShift ?? 0;
parameters.Add("EveningShift", DbType.Int32).Value = entity.EveningShift ?? 0;
return(parameters);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public override bool Delete(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update WxPayConfig set RowState=0 ");
strSql.Append(" where ID=@ID ");
var parameters = WriteAdoTemplate.CreateDbParameters();
parameters.Add("ID", DbType.Int32, 0).Value = Id;
return(ReadAdoTemplate.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 批量删除
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public bool DeleteByMainId(int MainId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Base_ProductionLines ");
strSql.Append(" where ProLineId=@ProLineId ");
var parameters = WriteAdoTemplate.CreateDbParameters();
parameters.Add("ProLineId", DbType.Int32, 0).Value = MainId;
return(ReadAdoTemplate.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 新增 修改 基本参数
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
private IDbParameters GetBaseParams(Base_StockMain entity)
{
var parameters = ReadAdoTemplate.CreateDbParameters();
parameters.Add("ProNo", SqlDbType.NVarChar).Value = entity.ProNo;
parameters.Add("CreateTime", SqlDbType.NVarChar).Value = DateTime.Now;
parameters.Add("Creater", SqlDbType.NVarChar).Value = entity.Creater ?? "";
parameters.Add("UpdateTime", SqlDbType.DateTime).Value = DateTime.Now;
parameters.Add("Updater", SqlDbType.NVarChar).Value = entity.Updater ?? "";
parameters.Add("RowState", SqlDbType.TinyInt).Value = entity.RowState;
return(parameters);
}
/// <summary>
/// 获取信息列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList <Pro_ShipPlans> GetPro_SchedulingGoodsNumByEdit(int Id)
{
var parameters = WriteAdoTemplate.CreateDbParameters();
StringBuilder strSql = new StringBuilder();
strSql.Append(@"select Pro_SchedulingGoodsNum.SGoodId,SType,SDate,SNum FROM Pro_SchedulingLine
left join Pro_SchedulingGoods on Pro_SchedulingLine.Id=Pro_SchedulingGoods.SLineId
left join Pro_SchedulingGoodsNum on Pro_SchedulingGoodsNum.SGoodId=Pro_SchedulingGoods.Id");
strSql.AppendFormat(" where [MainId]={0} and SType>-1", Id);
return(ReadAdoTemplate.QueryWithRowMapperDelegate <Pro_ShipPlans>(CommandType.Text, strSql.ToString(), MapRow_Pro_SchedulingGoodsNum, parameters));
}
/// <summary>
/// 获取信息列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList <Base_LineHour> GetLineHourList(string proLineNosList)
{
var parameters = WriteAdoTemplate.CreateDbParameters();
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,ProLineNo,MaxHours,CreateTime,Creater,UpdateTime,Updater,RowState ");
strSql.Append(" FROM Base_LineHour ");
strSql.AppendFormat("where RowState=1 and ProLineNo in({0})", proLineNosList);
return(ReadAdoTemplate.QueryWithRowMapperDelegate <Base_LineHour>(CommandType.Text, strSql.ToString(), MapRow, parameters));
}
