public List <RoleInfo> GetRolesByRule(string name, int status) { List <RoleInfo> result = new List <RoleInfo>(); string sqlText = RoleStatement.GetAllRolesByRule; if (!string.IsNullOrEmpty(name)) { sqlText += " AND RoleName LIKE '%'+@key+'%'"; } if (status > -1) { sqlText += " AND Status=@Status"; } DataCommand command = new DataCommand(ConnectionString, GetDbCommand(sqlText, "Text")); if (!string.IsNullOrEmpty(name)) { command.AddInputParameter("@key", DbType.String, name); } if (status > -1) { command.AddInputParameter("@Status", DbType.Int32, status); } result = command.ExecuteEntityList <RoleInfo>(); return(result); }
public List <StorageLocationInfo> GetSubAreaNoByStorageAreaNo(string StorageAreaNo, int status) { List <StorageLocationInfo> result = new List <StorageLocationInfo>(); string sqlText = StorageLocationStatement.GetSubAreaNo; if (!string.IsNullOrEmpty(StorageAreaNo)) { sqlText += " AND StorageAreaNo=@StorageAreaNo"; } if (status > -1) { sqlText += " AND Status=@Status"; } sqlText += " ORDER BY StorageSubAreaNo"; DataCommand command = new DataCommand(ConnectionString, GetDbCommand(sqlText, "Text")); if (!string.IsNullOrEmpty(StorageAreaNo)) { command.AddInputParameter("@StorageAreaNo", DbType.String, StorageAreaNo); } if (status > -1) { command.AddInputParameter("@Status", DbType.Int32, status); } result = command.ExecuteEntityList <StorageLocationInfo>(); return(result); }
/// <summary> /// /// </summary> /// <param name="UnionType"></param> /// <param name="UnionID"></param> /// <returns></returns> public List <ContactInfo> GetContactsByRule(string UnionType, int UnionID) { List <ContactInfo> result = new List <ContactInfo>(); string sqlText = ContactStatement.GetAllContactByRule; if (!string.IsNullOrEmpty(UnionType)) { sqlText += " AND UnionType =@UnionType"; } if (UnionID > -1) { sqlText += " AND UnionID=@UnionID"; } sqlText += " AND Status=@Status"; DataCommand command = new DataCommand(ConnectionString, GetDbCommand(sqlText, "Text")); if (!string.IsNullOrEmpty(UnionType)) { command.AddInputParameter("@UnionType", DbType.String, UnionType); } if (UnionID > -1) { command.AddInputParameter("@UnionID", DbType.Int32, UnionID); } command.AddInputParameter("@Status", DbType.Int32, 1); result = command.ExecuteEntityList <ContactInfo>(); return(result); }
public List <LineInfo> GetLineInfoByRule(int LineID, PagerInfo pager) { List <LineInfo> result = new List <LineInfo>(); StringBuilder builder = new StringBuilder(); if (LineID > -1) { builder.Append(" AND LineID=@LineID"); } string sqlText = LineStatement.GetAllLineInfoByRulePagerHeader + builder.ToString() + LineStatement.GetAllLineInfoByRulePagerFooter; DataCommand command = new DataCommand(ConnectionString, GetDbCommand(sqlText, "Text")); if (LineID > -1) { command.AddInputParameter("@LineID", DbType.Int32, LineID); } command.AddInputParameter("@PageIndex", DbType.Int32, pager.PageIndex); command.AddInputParameter("@PageSize", DbType.Int32, pager.PageSize); command.AddInputParameter("@recordCount", DbType.Int32, pager.SumCount); result = command.ExecuteEntityList <LineInfo>(); return(result); }
public int GetOrderDeliverPlanCount(int carrierID, string begindate, string enddate) { StringBuilder builder = new StringBuilder(); builder.Append(OrderDeliverPlanStatement.GetCount); if (carrierID > -1) { builder.Append(" AND CarrierID=@CarrierID"); } if (!string.IsNullOrEmpty(begindate) && !string.IsNullOrEmpty(enddate)) { builder.Append(" AND DeliverDate BETWEEN @begindate AND @enddate "); } DataCommand command = new DataCommand(ConnectionString, GetDbCommand(builder.ToString(), "Text")); if (carrierID > -1) { command.AddInputParameter("@CarrierID", DbType.Int32, carrierID); } if (!string.IsNullOrEmpty(begindate) && !string.IsNullOrEmpty(enddate)) { command.AddInputParameter("@begindate", DbType.String, begindate); command.AddInputParameter("@enddate", DbType.String, enddate); } var o = command.ExecuteScalar <object>(); return(Convert.ToInt32(o)); }
public List <StoreInfo> GetStoresByRule(string name, int status, PagerInfo pager) { List <StoreInfo> result = new List <StoreInfo>(); StringBuilder builder = new StringBuilder(); if (!string.IsNullOrEmpty(name)) { builder.Append(" AND SupplierName LIKE '%'+@key+'%'"); } if (status > -1) { builder.Append(" AND Status=@Status"); } string sqlText = StoreStatement.GetAllStoreInfoByRulePagerHeader + builder.ToString() + StoreStatement.GetAllStoreInfoByRulePagerFooter; DataCommand command = new DataCommand(ConnectionString, GetDbCommand(sqlText, "Text")); if (!string.IsNullOrEmpty(name)) { command.AddInputParameter("@key", DbType.String, name); } if (status > -1) { command.AddInputParameter("@Status", DbType.Int32, status); } command.AddInputParameter("@PageIndex", DbType.Int32, pager.PageIndex); command.AddInputParameter("@PageSize", DbType.Int32, pager.PageSize); command.AddInputParameter("@recordCount", DbType.Int32, pager.SumCount); result = command.ExecuteEntityList <StoreInfo>(); return(result); }
public List <StorageLocationInfo> GetAreaNoByStorageID(int storageID, int status) { List <StorageLocationInfo> result = new List <StorageLocationInfo>(); string sqlText = StorageLocationStatement.GetAreaNo; if (storageID > 0) { sqlText += " AND storageID=@storageID"; } if (status > -1) { sqlText += " AND Status=@Status"; } sqlText += " ORDER BY StorageAreaNo"; DataCommand command = new DataCommand(ConnectionString, GetDbCommand(sqlText, "Text")); if (storageID > 0) { command.AddInputParameter("@storageID", DbType.Int32, storageID); } if (status > -1) { command.AddInputParameter("@Status", DbType.Int32, status); } result = command.ExecuteEntityList <StorageLocationInfo>(); return(result); }
public int GetStoreCount(string name, int status) { StringBuilder builder = new StringBuilder(); builder.Append(StoreStatement.GetStoreCount); if (!string.IsNullOrEmpty(name)) { builder.Append(" AND SupplierName LIKE '%'+@key+'%'"); } if (status > -1) { builder.Append(" AND Status=@Status"); } DataCommand command = new DataCommand(ConnectionString, GetDbCommand(builder.ToString(), "Text")); if (!string.IsNullOrEmpty(name)) { command.AddInputParameter("@key", DbType.String, name); } if (status > -1) { command.AddInputParameter("@Status", DbType.Int32, status); } var o = command.ExecuteScalar <object>(); return(Convert.ToInt32(o)); }
public int EditOrderStatus(long oid, int status) { DataCommand command = new DataCommand(ConnectionString, GetDbCommand(OrderStatement.EditOrderStatus, "Text")); command.AddInputParameter("@OrderInnerID", DbType.Int64, oid); command.AddInputParameter("@Status", DbType.Int32, status); return(command.ExecuteNonQuery()); }
/// <summary> /// 更新下载(接单)状态 /// </summary> /// <param name="order"></param> /// <returns></returns> public int UpdateUploadStatus(OrderInfo order) { DataCommand command = new DataCommand(ConnectionString, GetDbCommand(OrderStatement.UpdateUploadStatus, "Text")); command.AddInputParameter("@UploadStatus", DbType.Int32, order.UploadStatus); command.AddInputParameter("@OrderID", DbType.Int32, order.OrderID); return(command.ExecuteNonQuery()); }
/// <summary> /// 更新配送时间 /// </summary> /// <param name="order"></param> /// <returns></returns> public int UpdateOrderArriverDate(OrderInfo order) { DataCommand command = new DataCommand(ConnectionString, GetDbCommand(OrderStatement.UpdateOrderArriverDate, "Text")); command.AddInputParameter("@ArriverDate", DbType.DateTime, order.ArriverDate); command.AddInputParameter("@OrderID", DbType.Int32, order.OrderID); return(command.ExecuteNonQuery()); }
/// <summary> /// 获取我的租赁/试驾信息 /// </summary> /// <param name="userid">用户ID</param> /// <param name="RType">ZL:汽车租赁 SJ:汽车试驾</param> /// <returns></returns> public DataSet MyReservation(string userid, string RType) { DataCommand command = new DataCommand(ConnectionString, GetDbCommand(CarStatement.MyReservation, "Text")); command.AddInputParameter("@CustomerID", DbType.String, userid); command.AddInputParameter("@RType", DbType.String, RType); return(command.ExecuteDataSet()); }
/// <summary> /// 修改密码 /// </summary> /// <param name="telephone"></param> /// <param name="password"></param> /// <param name="vcode"></param> /// <returns></returns> public int UpdatePassword(string telephone, string password, string vcode) { DataCommand command = new DataCommand(ConnectionString, GetDbCommand(CustomerStatement.UpdatePassword, "Text")); command.AddInputParameter("@CustomerCode", DbType.String, vcode); command.AddInputParameter("@Password", DbType.String, password); command.AddInputParameter("@Mobile", DbType.String, telephone); return(command.ExecuteNonQuery()); }
public int ModifyInventoryQuantity(InventoryInfo Inventory) { DataCommand command = new DataCommand(ConnectionString, GetDbCommand(InventoryStatement.ModifyInventoryQuantity, "Text")); command.AddInputParameter("@Quantity", DbType.Int32, Inventory.Quantity); command.AddInputParameter("@ChangeDate", DbType.DateTime, Inventory.ChangeDate); command.AddInputParameter("@InventoryID", DbType.Int64, Inventory.InventoryID); return(command.ExecuteNonQuery()); }
public int ModifyPassword(long userid, string password) { DataCommand command = new DataCommand(ConnectionString, GetDbCommand(UserStatement.ModifyPassword, "Text")); command.AddInputParameter("@UserID", DbType.Int64, userid); command.AddInputParameter("@Password", DbType.String, password); return(command.ExecuteNonQuery()); }
public int GetInventoryDetailCount(string name, string inventoryType, int StorageID, int customerID, string inventoryDate, string orderType) { StringBuilder builder = new StringBuilder(); builder.Append(InventoryDetailStatement.GetCount); if (!string.IsNullOrEmpty(name)) { } if (!string.IsNullOrEmpty(inventoryType)) { builder.Append(" AND inventoryType=@inventoryType"); } if (StorageID > 0) { builder.Append(" AND StorageID=@StorageID"); } if (customerID > 0) { builder.Append(" AND customerID=@customerID"); } if (!string.IsNullOrEmpty(orderType)) { builder.Append(" AND orderType=@orderType"); } builder.Append(" AND Quantity>0 ");//库存数量必须大于0 DataCommand command = new DataCommand(ConnectionString, GetDbCommand(builder.ToString(), "Text")); if (!string.IsNullOrEmpty(name)) { } if (!string.IsNullOrEmpty(inventoryType)) { command.AddInputParameter("@inventoryType", DbType.String, inventoryType); } if (StorageID > 0) { command.AddInputParameter("@StorageID", DbType.Int32, StorageID); } if (customerID > 0) { command.AddInputParameter("@customerID", DbType.Int32, customerID); } if (!string.IsNullOrEmpty(inventoryDate)) { } if (!string.IsNullOrEmpty(orderType)) { command.AddInputParameter("@orderType", DbType.String, orderType); } var o = command.ExecuteScalar <object>(); return(Convert.ToInt32(o)); }
/// <summary> /// 相同产品ID、相同批次号 /// </summary> /// <param name="goodsid"></param> /// <param name="storageID"></param> /// <param name="batchNumber"></param> /// <param name="DY0">是否查询大于0</param> /// <returns></returns> public List <InventoryInfo> GetInventoryByRule(int goodsid, int storageID, string batchNumber, int CustomerID, bool DY0, string keywords) { List <InventoryInfo> result = new List <InventoryInfo>(); string sqlText = InventoryStatement.GetAllInventoryByRule; if (!string.IsNullOrEmpty(keywords)) { sqlText += " and GoodsID in(select GoodsID from wms_GoodsInfo where GoodsName like '%" + keywords + "%')"; } if (goodsid > 0) { sqlText += " AND GoodsID=@GoodSID"; } if (storageID > 0) { sqlText += " AND StorageID=@StorageID"; } if (!string.IsNullOrEmpty(batchNumber)) { sqlText += " AND BatchNumber=@BatchNumber"; } if (CustomerID > 0) { sqlText += " AND CustomerID=@CustomerID"; } // 只查询大于0的库存数据 if (DY0) { sqlText += " AND Quantity>0"; } DataCommand command = new DataCommand(ConnectionString, GetDbCommand(sqlText, "Text")); if (goodsid > 0) { command.AddInputParameter("@GoodSID", DbType.String, goodsid); } if (storageID > 0) { command.AddInputParameter("@StorageID", DbType.String, storageID); } if (!string.IsNullOrEmpty(batchNumber)) { command.AddInputParameter("@BatchNumber", DbType.String, batchNumber); } if (CustomerID > 0) { command.AddInputParameter("@CustomerID", DbType.String, CustomerID); } result = command.ExecuteEntityList <InventoryInfo>(); return(result); }
/// <summary> /// 更新库位状态(是否锁定T/F) /// </summary> /// <param name="StorageLocationID"></param> /// <returns></returns> public int ModifyLock(long StorageLocationID, string isLock) { DataCommand command = new DataCommand(ConnectionString, GetDbCommand(StorageLocationStatement.ModifyLock, "Text")); command.AddInputParameter("@StorageLocationID", DbType.Int64, StorageLocationID); command.AddInputParameter("@IsLock", DbType.String, isLock); int result = command.ExecuteNonQuery(); return(result); }
/// <summary> /// 登录验证 /// </summary> /// <param name="telephone"></param> /// <param name="password"></param> /// <returns></returns> public CustomerInfo Login(string telephone, string password) { CustomerInfo result = new CustomerInfo(); DataCommand command = new DataCommand(ConnectionString, GetDbCommand(CustomerStatement.LoginSql, "Text")); command.AddInputParameter("@Mobile", DbType.String, telephone); command.AddInputParameter("@password", DbType.String, password); result = command.ExecuteEntity <CustomerInfo>(); return(result); }
/// <summary> /// 更新承运商信息 /// </summary> /// <param name="order"></param> /// <returns></returns> public int UpdateOrderCarrier(OrderInfo order) { DataCommand command = new DataCommand(ConnectionString, GetDbCommand(OrderStatement.UpdateOrderCarrier, "Text")); command.AddInputParameter("@CarrierID", DbType.Int32, order.CarrierID); command.AddInputParameter("@PlanID", DbType.Int32, order.PlanID); command.AddInputParameter("@DeliveryStatus", DbType.String, order.DeliveryStatus);//是否安排物流计划 T是/F否 command.AddInputParameter("@OrderID", DbType.Int32, order.OrderID); return(command.ExecuteNonQuery()); }
public int ModifyPileNum(int num, int bid) { DataCommand command = new DataCommand(ConnectionString, GetDbCommand(ChargeStatement.ModifyPileNum, "Text")); command.AddInputParameter("@ChargeNum", DbType.Int32, num); command.AddInputParameter("@ChargeBaseID", DbType.Int32, bid); int result = command.ExecuteNonQuery(); return(result); }
/// <summary> /// 判断手机号 VCODE 是否有效 /// </summary> /// <param name="telephone"></param> /// <param name="vcode"></param> /// <returns></returns> public VerificationCodeInfo CheckVerificationCode(string telephone, string vcode) { VerificationCodeInfo result = new VerificationCodeInfo(); DataCommand command = new DataCommand(ConnectionString, GetDbCommand(BaseDataStatement.CheckVerificationCodeSql, "Text")); command.AddInputParameter("@Mobile", DbType.String, telephone); command.AddInputParameter("@VCode", DbType.String, vcode); result = command.ExecuteEntity <VerificationCodeInfo>(); return(result); }
public UserInfo GetLoginUser(string name, string password) { UserInfo result = new UserInfo(); DataCommand command = new DataCommand(ConnectionString, GetDbCommand(UserStatement.GetLoginUser, "Text")); command.AddInputParameter("@UserName", DbType.String, name); command.AddInputParameter("@Password", DbType.String, password); result = command.ExecuteEntity <UserInfo>(); return(result); }
public List <StoreInfo> GetAllStorePager(PagerInfo pager) { List <StoreInfo> result = new List <StoreInfo>(); DataCommand command = new DataCommand(ConnectionString, GetDbCommand(StoreStatement.GetAllStorePager, "Text")); command.AddInputParameter("@PageIndex", DbType.Int32, pager.PageIndex); command.AddInputParameter("@PageSize", DbType.Int32, pager.PageSize); command.AddInputParameter("@recordCount", DbType.Int32, pager.SumCount); result = command.ExecuteEntityList <StoreInfo>(); return(result); }
public int ModifyRole(RoleInfo role) { DataCommand command = new DataCommand(ConnectionString, GetDbCommand(RoleStatement.ModifyRole, "Text")); command.AddInputParameter("@RoleID", DbType.Int32, role.RoleID); command.AddInputParameter("@RoleName", DbType.String, role.RoleName); command.AddInputParameter("@MenuIDs", DbType.String, role.MenuIDs); command.AddInputParameter("@Status", DbType.Int32, role.Status); return(command.ExecuteNonQuery()); }
public int ModifyCustomer(CustomerInfo customerInfo) { DataCommand command = new DataCommand(ConnectionString, GetDbCommand(CustomerStatement.ModifyCustomer, "Text")); command.AddInputParameter("@CustomerID", DbType.Int64, customerInfo.CustomerID); command.AddInputParameter("@CustomerName", DbType.String, customerInfo.CustomerName); command.AddInputParameter("@Name", DbType.String, customerInfo.Name); command.AddInputParameter("@Mobile", DbType.String, customerInfo.Mobile); command.AddInputParameter("@WXCode", DbType.String, customerInfo.WXCode); return(command.ExecuteNonQuery()); }
public int CreateNew(BrandInfo brand) { DataCommand command = new DataCommand(ConnectionString, GetDbCommand(BrandStatement.CreateBrand, "Text")); command.AddInputParameter("@BrandName", DbType.String, brand.BrandName); command.AddInputParameter("@BrandNameEN", DbType.String, brand.BrandNameEN); command.AddInputParameter("@ImageURL", DbType.String, brand.ImageURL); command.AddInputParameter("@Description", DbType.String, brand.Description); command.AddInputParameter("@IsUse", DbType.Int32, brand.IsUse); return(command.ExecuteNonQuery()); }
public int ModifyGroup(GroupInfo group) { DataCommand command = new DataCommand(ConnectionString, GetDbCommand(GroupStatement.ModifyGroup, "Text")); command.AddInputParameter("@GroupID", DbType.Int64, group.GroupID); command.AddInputParameter("@GroupName", DbType.String, group.GroupName); command.AddInputParameter("@MenuIDs", DbType.String, group.MenuIDs); command.AddInputParameter("@Status", DbType.Int32, group.Status); return(command.ExecuteNonQuery()); }
public int CreateNew(GroupInfo group) { DataCommand command = new DataCommand(ConnectionString, GetDbCommand(GroupStatement.CreateNewGroup, "Text")); command.AddInputParameter("@GroupName", DbType.String, group.GroupName); command.AddInputParameter("@MenuIDs", DbType.String, group.MenuIDs); command.AddInputParameter("@Status", DbType.Int32, group.Status); command.AddInputParameter("@CreateDate", DbType.DateTime, group.CreateDate); return(command.ExecuteNonQuery()); }
public int ModifyAdviseDealInfo(AdviseInfo adviseInfo) { DataCommand command = new DataCommand(ConnectionString, GetDbCommand(AdviseStatement.DealAdviseInfo, "Text")); command.AddInputParameter("@AdviseID", DbType.Int64, adviseInfo.AdviseID); command.AddInputParameter("@DealStatus", DbType.Int32, adviseInfo.DealStatus); command.AddInputParameter("@DealSummary", DbType.String, adviseInfo.DealSummary); command.AddInputParameter("@Operator", DbType.Int64, adviseInfo.Operator); command.AddInputParameter("@ModifyDate", DbType.DateTime, adviseInfo.ModifyDate); return(command.ExecuteNonQuery()); }