public List <StoreBasicInfo> GetStores(int pageSize = 10, string code = "", string name = "")
{
var list = StoreBasicInfo.Search(o => (string.IsNullOrEmpty(code) || o.StoreCode.StartsWith(code)) &&
(string.IsNullOrEmpty(name) || o.NameENUS.Contains(name) || o.NameZHCN.Contains(name))).OrderBy(o => o.NameENUS).Take(pageSize).ToList();
return(list);
}
public IHttpActionResult Authority(string usCode)
{
bool enableView = false;
bool enableEdit = false;
var adminUsers = Employee.GetEmployeesByRole(RoleCode.System_Admin);
if (adminUsers.Any(i => i.Code == ClientCookie.UserCode))
{
enableView = true;
enableEdit = true;
}
else
{
var storeInfo = StoreBasicInfo.GetStorInfo(usCode);
using (var amdb = new McdAMEntities())
{
var org = amdb.Organization.FirstOrDefault(i => i.Code == storeInfo.RegionCode && i.Type == 102);
if (org.DL.HasValue && org.DL.Value)
{
enableView = true;
var repUsers = Employee.GetStoreAssetRepByStoreCode(usCode);
if (repUsers.Any(i => i.Code == ClientCookie.UserCode))
{
enableEdit = true;
}
}
}
}
return(Ok(new
{
EnableView = enableView,
EnableEdit = enableEdit
}));
}
private void SendEmail(string ProjectId, string SerialNumber, int?ProcInstID, string receiverUserCode)
{
var project = ProjectInfo.Get(ProjectId, FlowCode.Reimage_ConsInvtChecking);
var storeBasic = StoreBasicInfo.FirstOrDefault(s => s.StoreCode == project.USCode);
using (EmailServiceClient emailClient = new EmailServiceClient())
{
EmailMessage email = new EmailMessage();
//邮件模板中的数据
Dictionary <string, string> bodyValues = new Dictionary <string, string>();
//邮件内容中的键值对
bodyValues.Add("ApproverName", ClientCookie.UserNameENUS);
bodyValues.Add("ApplicantName", ClientCookie.UserNameENUS);//--提交人
bodyValues.Add("WorkflowName", "Reimage");
bodyValues.Add("StoreCode", storeBasic.StoreCode);
bodyValues.Add("StoreName", storeBasic.NameENUS + @" \ " + storeBasic.NameZHCN);
bodyValues.Add("WorkflowName", Constants.Reimage_ConsInvtChecking); ////--流程名称
bodyValues.Add("ProjectName", Constants.Reimage); //项目名称
var viewPage = string.Format("{0}/Reimage/Main#/ConsInvtChecking/Process/Approval?projectId={1}&SN={2}&ProcInstID={3}",
HttpContext.Current.Request.Url.AbsolutePath, ProjectId, SerialNumber, ProcInstID);
bodyValues.Add("FormUrl", viewPage);
email.EmailBodyValues = bodyValues;
List <string> emailAddresses = Employee.Search(e => e.Code == receiverUserCode).Select(e => e.Mail).ToList();
emailAddresses.Add("*****@*****.**");
emailAddresses.Add("*****@*****.**");
emailAddresses.Add("*****@*****.**");
email.To = string.Join(";", emailAddresses);
emailClient.SendNotificationEmail(email);
}
}
public IHttpActionResult GetStoreDetails(string usCode, string eid)
{
//var resultStoreAllInfo = storeBll.GetStoreDetailsByEID(eid, usCode);
var resultStoreAllInfo = StoreBasicInfo.GetStore(usCode);
return(Ok(resultStoreAllInfo));
}
/// <summary>
/// 更新企业(商家)基本信息
/// </summary>
public static void UpdateStoreBasicInfo(StoreBasicInfo entity)
{
DataCommand cmd = DataCommandManager.GetDataCommand("UpdateStoreBasicInfo");
cmd.SetParameterValue <StoreBasicInfo>(entity);
cmd.ExecuteNonQuery();
}
public ActionResult StoreSTLicenseQuery(string _USCode)
{
List <StoreSTLicense> lsStoreSTLicense = new List <StoreSTLicense>();
lsStoreSTLicense = StoreSTLicense.Search(o => o.StoreCode == _USCode).OrderBy(o => o.Title).ToList <StoreSTLicense>();
if (lsStoreSTLicense.Count == 0)
{
var licenseList = new List <StoreSTLicense>();
var store = StoreBasicInfo.FirstOrDefault(i => i.StoreCode == _USCode);
foreach (var dicItem in licenseDict)
{
var storeLicense = new StoreSTLicense();
storeLicense.Id = Guid.NewGuid();
storeLicense.StoreID = store.StoreID;
storeLicense.StoreCode = _USCode;
storeLicense.Title = dicItem.Key;
storeLicense.CreatedTime = DateTime.Now;
storeLicense.DocType = dicItem.Value;
licenseList.Add(storeLicense);
}
StoreSTLicense.Add(licenseList.ToArray());
lsStoreSTLicense = licenseList;
}
string result = JsonConvert.SerializeObject(lsStoreSTLicense);
return(Content(result));
}
public static EmailSendingResultType SendLegalReviewEmail(TempClosureLegalReview entity)
{
var project = ProjectInfo.Get(entity.ProjectId, FlowCode.TempClosure_ClosurePackage);
var storeBasic = StoreBasicInfo.GetStorInfo(project.USCode);
var legal = ProjectUsers.GetProjectUser(entity.ProjectId, ProjectUserRoleCode.Legal);
var actor = ProjectUsers.GetProjectUser(entity.ProjectId, ProjectUserRoleCode.AssetActor);
using (EmailServiceClient emailClient = new EmailServiceClient())
{
EmailMessage email = new EmailMessage();
//邮件模板中的数据
Dictionary <string, string> bodyValues = new Dictionary <string, string>();
//邮件内容中的键值对
bodyValues.Add("ApproverName", legal.UserNameENUS);
bodyValues.Add("ApplicantName", ClientCookie.UserNameENUS);//--提交人
bodyValues.Add("StoreCode", storeBasic.StoreCode);
bodyValues.Add("StoreName", storeBasic.NameENUS + @" \ " + storeBasic.NameZHCN);
bodyValues.Add("Actor", actor.UserNameENUS); ////--呈递人
bodyValues.Add("WorkflowName", Constants.TempClosure_LegalReview); ////--流程名称
bodyValues.Add("ProjectName", Constants.TempClosure); //项目名称
var viewPage = string.Format("{0}/TempClosure/Main#/ClosurePackage/View/param?projectId={1}",
HttpContext.Current.Request.Url.AbsolutePath, entity.ProjectId);
bodyValues.Add("FormUrl", viewPage);
email.EmailBodyValues = bodyValues;
List <string> emailAddresses = Employee.Search(e => e.Code == legal.UserAccount).Select(e => e.Mail).ToList();
emailAddresses.Add("*****@*****.**");
emailAddresses.Add("*****@*****.**");
emailAddresses.Add("*****@*****.**");
email.To = string.Join(";", emailAddresses);
//return emailClient.SendNotificationEmail(email);
return(new EmailSendingResultType());
}
}
public IHttpActionResult EditMultipleProjects(PostEditProjects postEditProjects)
{
if (postEditProjects.EditProjects.Count > 0)
{
using (TransactionScope tranScope = new TransactionScope())
{
var projectId = postEditProjects.ProjectId;
var parentCode = postEditProjects.EditProjects[0].ParentCode;
var projects = ProjectInfo.Search(pi => pi.ProjectId == projectId).ToList();
var usCode = projects[0].USCode;
var store = StoreBasicInfo.GetStorInfo(usCode);
var minExecuteSequence = postEditProjects.EditProjects.Min(p => p.ExecuteSequence);
var maxExecuteSequance = postEditProjects.EditProjects.Max(p => p.ExecuteSequence);
foreach (TopNavigator nav in postEditProjects.EditProjects)
{
var workflow = BaseWFEntity.GetWorkflowEntity(postEditProjects.ProjectId, nav.Code);
workflow.Edit();
}
string[] cancelWorkflowCodes = FlowInfo.Search(f => f.ParentCode == parentCode && f.ExecuteSequence <= maxExecuteSequance + 1).Select(f => f.Code).ToArray();
TaskWork.Cancel(t => cancelWorkflowCodes.Contains(t.TypeCode) && t.RefID == postEditProjects.ProjectId && t.Status != TaskWorkStatus.Finished);
postEditProjects.EditProjects.Where(n => n.ExecuteSequence == minExecuteSequence).ToList().ForEach(n =>
{
var project = projects.FirstOrDefault(pi => pi.FlowCode == n.Code);
var originator = Employee.GetSimpleEmployeeByCode(project.CreateUserAccount);
var source = FlowInfo.Get(n.ParentCode);
var taskType = FlowInfo.Get(n.Code);
TaskWork task = new TaskWork();
task.Id = Guid.NewGuid();
task.SourceCode = source.Code;
task.SourceNameENUS = source.NameENUS;
task.SourceNameZHCN = source.NameZHCN;
task.Status = TaskWorkStatus.UnFinish;
task.StatusNameZHCN = "任务";
task.StatusNameENUS = "任务";
task.Title = TaskWork.BuildTitle(postEditProjects.ProjectId, store.NameZHCN, store.NameENUS);
task.RefID = postEditProjects.ProjectId;
task.StoreCode = usCode;
task.ReceiverAccount = originator.Code;
task.ReceiverNameENUS = originator.NameENUS;
task.ReceiverNameZHCN = originator.NameZHCN;
task.TypeCode = taskType.Code;
task.TypeNameENUS = taskType.NameENUS;
task.TypeNameZHCN = taskType.NameZHCN;
task.Url = TaskWork.BuildUrl(n.Code, projectId, "");
task.CreateTime = DateTime.Now;
task.CreateUserAccount = ClientCookie.UserCode;
task.Sequence = 0;
task.ActivityName = "Start";
task.Add();
});
tranScope.Complete();
}
return(Ok());
}
else
{
return(BadRequest("you must select projects to be edited！"));
}
}
public PagedDataSource GetStores(int pageIndex, int pageSize, string userCode, string code = "", string name = "")
{
var bll = new StoreBasicInfo();
int totalRecords = 0;
var list = bll.GetStoresByEmployeeCode(pageIndex, pageSize, userCode, name, code, out totalRecords).ToArray();
return(new PagedDataSource(totalRecords, list));
}
/// <summary>
/// 加载企业(商家)基本信息
/// </summary>
public static StoreBasicInfo LoadStoreBasicInfo(int SysNo)
{
DataCommand cmd = DataCommandManager.GetDataCommand("LoadStoreBasicInfo");
cmd.SetParameterValue("@SysNo", SysNo);
StoreBasicInfo result = cmd.ExecuteEntity <StoreBasicInfo>();
return(result);
}
private StoreBasicInfoModel Transformstoreinfo(StoreBasicInfo storeinfo)
{
StoreBasicInfoModel result = new StoreBasicInfoModel();
result.Address = storeinfo.Address;
result.BrandAuthorize = storeinfo.BrandAuthorize;
result.ContactName = storeinfo.ContactName;
result.CooperationMode = storeinfo.CooperationMode;
result.CurrentECChannel = storeinfo.CurrentECChannel;
result.ECExpValue = storeinfo.ECExpValue;
result.EditDate = storeinfo.EditDate;
result.EditUserName = storeinfo.EditUserName;
result.EditUserSysNo = storeinfo.EditUserSysNo;
result.Email = storeinfo.Email;
result.ExportExpValue = storeinfo.ExportExpValue;
result.HaveECExp = storeinfo.HaveECExp;
result.HaveExportExp = storeinfo.HaveExportExp;
result.InDate = storeinfo.InDate;
result.InUserName = storeinfo.InUserName;
result.InUserSysNo = storeinfo.InUserSysNo;
result.MainBrand = storeinfo.MainBrand;
result.MainProductCategory = storeinfo.MainProductCategory;
result.Mobile = storeinfo.Mobile;
result.Name = storeinfo.Name;
result.Phone = storeinfo.Phone;
result.QQ = storeinfo.QQ;
result.Remark = storeinfo.Remark;
result.SellerSysNo = storeinfo.SellerSysNo;
result.Site = storeinfo.Site;
result.Status = storeinfo.Status;
result.StoreName = storeinfo.StoreName;
result.SysNo = storeinfo.SysNo;
result.ValidDate = storeinfo.ValidDate;
//构造商品图片
ImageSize imageSizeMiddle = ImageUrlHelper.GetImageSize(ImageType.Middle);
result.LogoURL = ProductFacade.BuildProductImage(imageSizeMiddle, storeinfo.LogoURL);
//是否被收藏
#region 是否被收藏
LoginUser CurrUser = UserMgr.ReadUserInfo();
bool StoreIsWished = false;
if (CurrUser == null || CurrUser.UserSysNo < 0)
{
StoreIsWished = false;
}
else
{
StoreIsWished = CustomerFacade.IsMyFavoriteSeller(CurrUser.UserSysNo, storeinfo.SellerSysNo.Value);
}
#endregion
result.StoreIsWished = StoreIsWished;
return(result);
}
/// <summary>
/// 创建企业(商家)基本信息
/// </summary>
public static int InsertStoreBasicInfo(StoreBasicInfo entity)
{
DataCommand cmd = DataCommandManager.GetDataCommand("InsertStoreBasicInfo");
cmd.SetParameterValue <StoreBasicInfo>(entity);
cmd.ExecuteNonQuery();
int sysNo = (int)cmd.GetParameterValue("@SysNo");
return(sysNo);
}
public void U_IMssd(StoreBasicInfo storebasicinfo)//编辑出入库系列detail
{
SqlParameter[] parm = new SqlParameter[2];
parm[0] = new SqlParameter("@IMSSbd_ID", SqlDbType.UniqueIdentifier);
parm[0].Value = storebasicinfo.IMSSBD_ID;
parm[1] = new SqlParameter("@IMSSbd_Detail", SqlDbType.VarChar, 200);
parm[1].Value = storebasicinfo.IMSSBD_Detail;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_U_IMssBd", parm);
}
/////////////////////////////////////////////////////////////////////////////////
#region // StoreAllInfoQuery Test
public ActionResult StoreAllInfoQuery(string _USCode)
{
List <StoreBasicInfo> lsStoreBasicInfo = new List <StoreBasicInfo>();
StoreBasicInfo mStoreBasicInfo = new StoreBasicInfo();
lsStoreBasicInfo = StoreBasicInfo.Search(o => o.StoreCode.Contains(_USCode)).ToList <StoreBasicInfo>();
if (lsStoreBasicInfo.Count > 0)
{
mStoreBasicInfo = lsStoreBasicInfo[0];
}
List <StoreDevelop> lsStoreDevelop = new List <StoreDevelop>();
StoreDevelop mStoreDevelop = new StoreDevelop();
lsStoreDevelop = StoreDevelop.Search(o => o.StoreCode.Contains(_USCode)).ToList <StoreDevelop>();
if (lsStoreDevelop.Count > 0)
{
mStoreDevelop = lsStoreDevelop[0];
}
List <StoreOps> lsStoreOp = new List <StoreOps>();
StoreOps mStoreOp = new StoreOps();
lsStoreOp = StoreOps.Search(o => o.StoreCode.Contains(_USCode)).ToList <StoreOps>();
if (lsStoreOp.Count > 0)
{
mStoreOp = lsStoreOp[0];
}
List <StoreContractInfo> lsStoreContractInfo = new List <StoreContractInfo>();
StoreContractInfo mStoreContractInfo = new StoreContractInfo();
lsStoreContractInfo = StoreContractInfo.Search(o => o.StoreCode.Contains(_USCode)).ToList <StoreContractInfo>();
if (lsStoreContractInfo.Count > 0)
{
mStoreContractInfo = lsStoreContractInfo[0];
}
var resultStoreAllInfo = new
{
StoreBasicInfo = mStoreBasicInfo,
StoreDevelop = mStoreDevelop,
StoreOp = mStoreOp,
StoreContractInfo = new
{
StoreContractInfo = mStoreContractInfo,
StoreContractRevision = "",
StoreContractInfoAttached = ""
}
};
string result = JsonConvert.SerializeObject(resultStoreAllInfo);
return(Content(result));
}
public IHttpActionResult CheckStoreFlow(string code, string flowCode)
{
var store = StoreBasicInfo.GetStorInfo(code);
return(Ok(new
{
Store = store,
StoreValid = ProjectInfo.CheckIfExistStore(code, flowCode),
//StoreValid = true,
}));
}
public void U_IMstore(StoreBasicInfo storebasicinfo)//更新库房
{
SqlParameter[] parm = new SqlParameter[3];
parm[0] = new SqlParameter("@IMS_StoreID", SqlDbType.UniqueIdentifier);
parm[0].Value = storebasicinfo.IMS_StoreID;
parm[1] = new SqlParameter("@IMS_ResponDepart", SqlDbType.VarChar, 200);
parm[1].Value = storebasicinfo.IMS_ResponDepart;
parm[2] = new SqlParameter("@IMS_ResponMan", SqlDbType.VarChar, 200);
parm[2].Value = storebasicinfo.IMS_ResponMan;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_U_IMStore", parm);
}
public IHttpActionResult GetOnline(string projectID)
{
var closure = ClosureInfo.GetByProjectId(projectID);
var store = StoreBasicInfo.GetStore(closure.USCode);
var toolEntity = ClosureTool.Get(closure.ProjectId);
var woEntity = ClosureWOCheckList.Get(closure.ProjectId);
List <StoreBEInfo> remoteBeList = new List <StoreBEInfo>();
List <StoreBEInfo> attachedBeList = new List <StoreBEInfo>();
StoreBEInfo mds = null;
StoreBEInfo mcCafe = null;
StoreBEInfo hour24 = null;
if (store.StoreBEInfoList.Count > 0)
{
foreach (var beInfo in store.StoreBEInfoList)
{
switch (beInfo.BETypeName)
{
case "Remote Kiosk":
remoteBeList.Add(beInfo);
break;
case "Attach Kiosk":
attachedBeList.Add(beInfo);
break;
case "MDS":
mds = beInfo;
break;
case "McCafe":
mcCafe = beInfo;
break;
case "24 Hour":
hour24 = beInfo;
break;
}
}
}
return(Ok(new
{
Store = store,
ClosureTool = toolEntity,
WOCheckList = woEntity,
RemoteBeList = remoteBeList,
AttachedBeList = attachedBeList,
MDS = mds,
McCafe = mcCafe,
Hour24 = hour24
}));
}
public IHttpActionResult CheckStore(string code)
{
var bll = new StoreBasicInfo();
string storeName = "";
var result = bll.CheckStore(code, out storeName);
return(Ok(new
{
StoreName = storeName,
StoreValid = result
}));
}
public static VendorBasicInfo ConvertStoreBasicToIPP3Vendor(StoreBasicInfo info)
{
var vendorBasicInfo = new VendorBasicInfo();
//vendorBasicInfo.VendorID = info.SellerSysNo.Value.ToString();
vendorBasicInfo.SellerID = info.SellerSysNo.Value.ToString();
vendorBasicInfo.VendorNameLocal = info.Name;
vendorBasicInfo.VendorStatus = VendorStatus.Available;
vendorBasicInfo.VendorType = VendorType.VendorPortal;
vendorBasicInfo.ConsignFlag = VendorConsignFlag.Sell;
vendorBasicInfo.VendorIsCooperate = VendorIsCooperate.No;
return(vendorBasicInfo);
}
public bool Add(MaterTrack materTrack)
{
using (TransactionScope tranScope = new TransactionScope())
{
materTrack.Id = Guid.NewGuid();
materTrack.CreateTime = DateTime.Now;
MaterTrack.Add(materTrack);
var project = ProjectInfo.Get(materTrack.WorkflowId, materTrack.WorkflowType);
var store = StoreBasicInfo.FirstOrDefault(s => s.StoreCode == project.USCode);
var Codes = materTrack.NodeType.Split('_');
var url = string.Format("/{0}/Main#/{1}/Process/View?projectId={2}", Codes[0], Codes[1], materTrack.WorkflowId);
//if (Codes[0] == "Closure") //临时改动 只针对Closure,因为Closure 用的还是老的URL
//{
// url = string.Format("/{0}/Main#/{0}/{1}/Process/View?projectId={2}", Codes[0], Codes[1], materTrack.WorkflowId);
//}
var title = TaskWork.BuildTitle(materTrack.WorkflowId, store.NameZHCN, store.NameENUS);
switch (materTrack.TrackType)
{
case MaterTrackType.Rep:
{
var actor = ProjectUsers.FirstOrDefault(pu => pu.ProjectId == materTrack.WorkflowId && pu.RoleCode == ProjectUserRoleCode.AssetActor);
TaskWork.SendTask(materTrack.WorkflowId, title, project.USCode, url, actor, materTrack.WorkflowType, materTrack.NodeType, "Start_MaterTrack_Rep");
}
break;
case MaterTrackType.Feedback:
{
var legal = ProjectUsers.FirstOrDefault(pu => pu.ProjectId == materTrack.WorkflowId && pu.RoleCode == ProjectUserRoleCode.Legal);
TaskWork.Finish(t => t.RefID == materTrack.WorkflowId && t.SourceCode == materTrack.WorkflowType && t.TypeCode == materTrack.NodeType && t.ActivityName == "Start_MaterTrack_Rep" && t.Status == TaskWorkStatus.UnFinish);
if (TaskWork.Count(t => t.RefID == materTrack.WorkflowId && t.SourceCode == materTrack.WorkflowType && t.TypeCode == materTrack.NodeType && t.ActivityName == "Start_MaterTrack_Feedback" && t.Status == TaskWorkStatus.UnFinish) == 0)
{
TaskWork.SendTask(materTrack.WorkflowId, title, project.USCode, url, legal, materTrack.WorkflowType, materTrack.NodeType, "Start_MaterTrack_Feedback");
}
}
break;
case MaterTrackType.Reply:
{
var actor = ProjectUsers.FirstOrDefault(pu => pu.ProjectId == materTrack.WorkflowId && pu.RoleCode == ProjectUserRoleCode.AssetActor);
TaskWork.Finish(t => t.RefID == materTrack.WorkflowId && t.SourceCode == materTrack.WorkflowType && t.TypeCode == materTrack.NodeType && t.ActivityName == "Start_MaterTrack_Feedback" && t.Status == TaskWorkStatus.UnFinish);
if (TaskWork.Count(t => t.RefID == materTrack.WorkflowId && t.SourceCode == materTrack.WorkflowType && t.TypeCode == materTrack.NodeType && t.ActivityName == "Start_MaterTrack_Rep" && t.Status == TaskWorkStatus.UnFinish) == 0)
{
TaskWork.SendTask(materTrack.WorkflowId, title, project.USCode, url, actor, materTrack.WorkflowType, materTrack.NodeType, "Start_MaterTrack_Rep");
}
}
break;
}
tranScope.Complete();
return(true);
}
}
public void I_IMssdOut(StoreBasicInfo storebasicinfo)//新增出库类型
{
SqlParameter[] parm = new SqlParameter[4];
parm[0] = new SqlParameter("@IMSSBD_Name", SqlDbType.VarChar, 50);
parm[0].Value = storebasicinfo.IMSSBD_Name;
parm[1] = new SqlParameter("@IMSSBD_Detail", SqlDbType.VarChar, 200);
parm[1].Value = storebasicinfo.IMSSBD_Detail;
parm[2] = new SqlParameter("@IMSSBD_Man", SqlDbType.VarChar, 20);
parm[2].Value = storebasicinfo.IMSSBD_Man;
parm[3] = new SqlParameter("@IMSSBD_Time", SqlDbType.Date);
parm[3].Value = storebasicinfo.IMSSBD_Time;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_IMssdOut", parm);
}
public IHttpActionResult GetStoreSTLocationInfo(string storeCode)
{
var entity = StoreSTLocation.GetStoreSTLocation(storeCode);
if (entity != null)
{
var storeBasicInfo = StoreBasicInfo.FirstOrDefault(e => e.StoreCode == entity.StoreCode);
if (storeBasicInfo != null)
{
entity.StoreTypeName = storeBasicInfo.StoreTypeName;
}
}
return(Ok(entity));
}
public void U_IMstore_Areal(StoreBasicInfo storebasicinfo)//更新区域
{
SqlParameter[] parm = new SqlParameter[4];
parm[0] = new SqlParameter("@IMSA_AreaID", SqlDbType.UniqueIdentifier);
parm[0].Value = storebasicinfo.IMSA_AreaID;
parm[1] = new SqlParameter("@IMSA_AreaName", SqlDbType.VarChar, 100);
parm[1].Value = storebasicinfo.IMSA_AreaName;
parm[2] = new SqlParameter("@IMSA_Remark", SqlDbType.VarChar, 400);
parm[2].Value = storebasicinfo.IMSA_Remark;
parm[3] = new SqlParameter("@IMSA_MakeMan", SqlDbType.VarChar, 20);
parm[3].Value = storebasicinfo.IMSA_MakeMan;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_U_IMStore_Areal", parm);
}
public ActionResult StoreBasicInfoQuery(string _USCode)
{
List <StoreBasicInfo> lsStoreBasicInfo = new List <StoreBasicInfo>();
StoreBasicInfo storeBasicInfo = new StoreBasicInfo();
lsStoreBasicInfo = StoreBasicInfo.Search(o => o.StoreCode.Contains(_USCode)).ToList <StoreBasicInfo>();
if (lsStoreBasicInfo.Count > 0)
{
storeBasicInfo = lsStoreBasicInfo[0];
}
string result = JsonConvert.SerializeObject(storeBasicInfo);
return(Content(result));
}
public IHttpActionResult GetStore(string usCode)
{
string _USCode = usCode;
var lsStoreBasicInfo = new List <StoreBasicInfo>();
var mStoreBasicInfo = new StoreBasicInfo();
lsStoreBasicInfo = StoreBasicInfo.Search(o => o.StoreCode.Contains(_USCode)).ToList <StoreBasicInfo>();
if (lsStoreBasicInfo.Count > 0)
{
mStoreBasicInfo = lsStoreBasicInfo[0];
}
return(Ok(mStoreBasicInfo));
}
/// <summary>
/// 更新店面状态
/// </summary>
/// <param name="info"></param>
private void UpdateStore(ScheduleLog info)
{
var storeInfo = StoreBasicInfo.GetStorInfo(info.USCode);
if (storeInfo == null)
{
return;
}
try
{
if (info.ProjectId.ToLower().Contains("closure"))
{
storeInfo.StoreStatus = "suoya301003";
storeInfo.statusName = "Closed";
storeInfo.CloseDate = info.ExecuteDate;
storeInfo.Update();
}
else if (info.ProjectId.ToLower().Contains("tpcls"))
{
storeInfo.StoreStatus = "suoya301005";
storeInfo.statusName = "TempClosed";
//storeInfo.CloseDate = info.UpdateDate;
storeInfo.Update();
}
else if (info.ProjectId.ToLower().Contains("reimage"))
{
storeInfo.StoreStatus = "suoya301001";
storeInfo.statusName = "Reimaging";
storeInfo.ReImageDate = info.ExecuteDate;
storeInfo.Update();
}
else if (info.ProjectId.ToLower().Contains("renewal"))
{
storeInfo.StoreStatus = "suoya301002";
storeInfo.statusName = "Renewal";
storeInfo.Update();
}
info.IsExecuted = true;
Log.WriteLog(storeInfo.NameZHCN + "(" + info.USCode + ")状态更新成功");
}
catch (Exception ex)
{
Log.WriteErrorMessage(ex);
Log.WriteLog(storeInfo.NameZHCN + "(" + info.USCode + ")状态更新失败");
}
}
public IHttpActionResult GetStoreBasic(string usCode)
{
string _USCode = usCode;
var lsStoreBasicInfo = new List <StoreBasicInfo>();
var mStoreBasicInfo = new StoreBasicInfo();
lsStoreBasicInfo = StoreBasicInfo.Search(o => o.StoreCode.Contains(_USCode)).ToList <StoreBasicInfo>();
if (lsStoreBasicInfo.Count > 0)
{
mStoreBasicInfo = lsStoreBasicInfo[0];
}
mStoreBasicInfo.ProjectContractRevision = StoreContractInfo.MappingProjectContractRevision(usCode);
return(Ok(mStoreBasicInfo));
}
public IHttpActionResult Get(string projectId)
{
var entity = ClosureMemo.Get(projectId);
bool editable = false;
var storeStatus = StoreBasicInfo.Search(s => s.StoreCode == entity.USCode).Select(s => s.statusName).FirstOrDefault();
if (storeStatus == "Closed")
{
editable = false;
}
else
{
if (TaskWork.Count(e => e.ReceiverAccount == ClientCookie.UserCode && e.SourceCode == FlowCode.Closure &&
e.TypeCode == FlowCode.Closure_Memo && e.RefID == projectId) > 0)
{
if (entity.Id == Guid.Empty)
{
editable = true;
}
else
{
if (entity.ClosureDate.Value < DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd") + " 00:00") && entity.ClosureNature == ClosureNatureType.Permanent)
{
editable = false;
}
else
{
editable = true;
}
}
}
else
{
editable = true;
}
}
var isActor = ProjectUsers.IsRole(projectId, ClientCookie.UserCode, ProjectUserRoleCode.AssetActor);
return(Ok(new
{
Entity = entity,
Editable = editable,
IsActor = isActor
}));
}
public void I_IMstore_new(StoreBasicInfo storebasicinfo)//新增库房
{
SqlParameter[] parm = new SqlParameter[5];
parm[0] = new SqlParameter("@IMS_StoreName", SqlDbType.VarChar, 50);
parm[0].Value = storebasicinfo.IMS_StoreName;
parm[1] = new SqlParameter("@IMS_ResponDepart", SqlDbType.VarChar, 100);
parm[1].Value = storebasicinfo.IMS_ResponDepart;
parm[2] = new SqlParameter("@IMS_ResponMan", SqlDbType.VarChar, 100);
parm[2].Value = storebasicinfo.IMS_ResponMan;
parm[3] = new SqlParameter("@Flag", SqlDbType.Decimal);
parm[3].Value = storebasicinfo.Flag;
parm[4] = new SqlParameter("@IMS_StoreID", SqlDbType.UniqueIdentifier);
parm[4].Value = storebasicinfo.IMS_StoreID;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_IMStore_new", parm);
}
public static StoreBasicInfo QueryStoreBasicInfoBySellerSysNo(int sellerSysNo)
{
DataCommand cmd = DataCommandManager.GetDataCommand("QueryStoreBasicInfoBySellerSysNo");
cmd.SetParameterValue("@SellerSysNo", sellerSysNo);
var ds = cmd.ExecuteDataSet();
List <string> BrandNames = new List <string>();
if (ds.Tables.Count > 0)
{
var dt0 = ds.Tables[0];
foreach (DataRow row in dt0.Rows)
{
BrandNames.Add(row[0].ToString());
}
}
List <string> CategoryNames = new List <string>();
if (ds.Tables.Count > 1)
{
var dt1 = ds.Tables[1];
foreach (DataRow row in dt1.Rows)
{
CategoryNames.Add(row[0].ToString());
}
}
StoreBasicInfo result = new StoreBasicInfo();
if (ds.Tables.Count > 2)
{
var dt2 = ds.Tables[2];
if (dt2.Rows.Count > 0)
{
DataMapper.AutoMap <StoreBasicInfo>(result, dt2.Rows[0]);
}
}
result.MainBrand = String.Join("/", BrandNames.ToArray());
result.MainProductCategory = String.Join("/", CategoryNames.ToArray());
return(result);
}
