/// <summary>
/// 删除记录
/// </summary>
/// <returns></returns>
public override string Delete()
{
//获取要删除的ID
int id = ConvertHelper.Cint0(GridViewHelper.GetSelectedKey(Grid1, true));
//如果没有选择记录，则直接退出
if (id == 0)
{
return("请选择要删除的记录。");
}
try
{
//删除前判断一下
if (PagePowerSignBll.GetInstence().Exist(x => x.Id == id))
{
return("删除失败，本菜单下面存在子菜单，不能直接删除！");
}
//删除前判断一下
if (PagePowerSignBll.GetInstence().Exist(x => x.MenuInfo_Id == id))
{
return("删除失败，本菜单已绑定有页面控件权限标志，不能直接删除！");
}
//删除记录
bll.Delete(this, id);
return("删除编号ID为[" + id + "]的数据记录成功。");
}
catch (Exception e)
{
string result = "尝试删除编号ID为[" + id + "]的数据记录失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
return(result);
}
}
/// <summary>
/// 删除记录
/// </summary>
/// <returns></returns>
public override string Delete()
{
//获取要删除的Id组
var id = GridViewHelper.GetSelectedKeyIntArray(Grid1);
//如果没有选择记录，则直接退出
if (id == null)
{
return("请选择要删除的记录。");
}
try
{
//逐个判断是否可以删除
foreach (var i in id)
{
//删除前检查
if (ManagerBll.GetInstence().Exist(x => x.Position_Id.Contains("," + i + ",")))
{
return("删除失败，Id为【" + i + "】的职位已有员工使用，不能直接删除！");
}
}
//删除记录
bll.Delete(this, id);
return("删除编号Id为[" + string.Join(",", id) + "]的数据记录成功。");
}
catch (Exception e)
{
string result = "尝试删除编号ID为[" + string.Join(",", id) + "]的数据记录失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
return(result);
}
}
private void DoAction(SendMsgStruct[] array)
{
if (array != null && array.Length > 0)
{
SMSSendListModel model = new SMSSendListModel();
DataTable dtWrite = model.Tables[0];
foreach (SendMsgStruct item in array)
{
DataRow dr = dtWrite.NewRow();
dr[SMSSendListModel.CSShortName] = item.CSShortName;
dr[SMSSendListModel.UserName] = item.UserName;
dr[SMSSendListModel.HName] = item.HName;
dr[SMSSendListModel.UniqueID] = item.UniqueID;
dr[SMSSendListModel.ReceiveTime] = new DateTime(item.ReceiveTime).ToString("yyyy-MM-dd HH:mm:ss");
dr[SMSSendListModel.TelNumber] = item.TelNumber;
dr[SMSSendListModel.Content] = item.Content;
dr[SMSSendListModel.BatchID] = item.BatchID;
dr[SMSSendListModel.SendTime] = new DateTime(item.SendTime).ToString("yyyy-MM-dd HH:mm:ss");
dr[SMSSendListModel.SendState] = item.SendState;
dr[SMSSendListModel.ErrorMsg] = item.ErrorMsg;
dtWrite.Rows.Add(dr);
}
CommonBll cBll = new CommonBll(SP.DataConnectType.CustomDBDataService);
if (cBll.BulkInsert(model))
{
LastExecTime = DateTime.Now;
}
else//error
{
AsyncHelper.RunSync <bool>(() => Manager.Instance.WriteLogFile("SendDBLogWorker_BulkInsert未插入"));
}
}
}
/// <summary>
/// 添加团订单消息信息
/// </summary>
/// <param name="teamDetailList"></param>
public void AddTeamOrderInformationInfo(IList <TeamDetailEntity> teamDetailList)
{
//LogHelper.Info("--------TeamPayAfter 消息插入循环进入前----");
foreach (TeamDetailEntity teamDetail in teamDetailList)
{
//LogHelper.Info("--------TeamPayAfter 消息插入循环----" + teamDetail.OrderCode);
ProductInfoModel productInfoModel = orderManager.GetOrderImage(teamDetail.OrderCode);
//LogHelper.Info("--------TeamPayAfter 获取商品图片结束----productInfoModel=" + productInfoModel);
InformationEntity InformationEntityTeam = new InformationEntity();
InformationEntityTeam.InfoType = 1;
InformationEntityTeam.WebInnerType = 3;
InformationEntityTeam.SendDest = CommonBll.GetUserRegion(teamDetail.UserId);
InformationEntityTeam.SendUserId = teamDetail.UserId;
InformationEntityTeam.TradeCode = teamDetail.TeamCode;
InformationEntityTeam.Title = InformationUtils.TeamJoinSuccTitle;
InformationEntityTeam.InfoContent = InformationUtils.TeamJoinSuccContent;
if (productInfoModel != null)
{
InformationEntityTeam.ImagePath = productInfoModel.ImagePath;
}
else
{
InformationEntityTeam.ImagePath = null;
}
InformationEntityTeam.Summary = null;
InformationEntityTeam.LinkUrl = "team/teamDetail?TeamCode=" + teamDetail.TeamCode + "&Flag=1";
InformationEntityTeam.StartTime = null;
InformationEntityTeam.EndTime = null;
InformationEntityTeam.LongTerm = 0;
InformationEntityTeam.CreateTime = DateTime.Now;
//LogHelper.Info("--------TeamPayAfter 消息插入开始----");
InformationBll.AddInformation(InformationEntityTeam);
}
}
protected void Page_Load(object sender, EventArgs e)
{
ac = Request.QueryString["ac"];
id = BasePage.GetRequestId(Request.QueryString["id"]);
if (!Page.IsPostBack)
{
((Literal)Master.FindControl("breadcrumbs")).Text = "<a href=\"searchkey.aspx\" class=\"home\">搜索关键词</a>";
string checklogin = new AdminBll().CheckLogin("no");
if (checklogin != "true")
{
BasePage.Alertback(checklogin);
Response.End();
}
if (id != 0)
{
SearchModel s = new SearchBll().GetModel(id);
txtkey.Text = s.keyword;
txtnum.Text = s.num.ToString();
txtpx.Text = s.px.ToString();
}
else
{
int PageSize = 30;
int PageIndex = BasePage.GetRequestId(Request.QueryString["Page"]);
string strwhere = "";
int all = new CommonBll().GetRecordCount(datatable, strwhere);
if (all > 0)
{
Repeater1.DataSource = new CommonBll().GetListPage("", datatable, strwhere, "px desc,num desc", PageSize, PageIndex);
Repeater1.DataBind();
if (all > PageSize)
{
fy.InnerHtml = GetPage.GetAspxPager(all, PageSize, PageIndex);
}
}
}
}
}
/// <summary>
/// 结账
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButtonCloseBill_Click(object sender, EventArgs e)
{
if (payMoney.Text.Trim().Length == 0)
{
Alert.Show("请输入付款金额");
return;
}
decimal money = 0;
try
{
money = Convert.ToDecimal(payMoney.Text);
}
catch (Exception ex)
{
CommonBll.WriteLog("付款金额不正确", ex);
Alert.Show("付款金额不正确");
return;
}
//更新数据库中未结账的记录
Confirm.Show("确认结账", "", MessageBoxIcon.Question);
}
/// <summary>自动排序，如果使用了缓存，保存成功后会清空本表的所有缓存记录，然后重新加载进缓存</summary>
/// <param name="page">当前页面指针</param>
/// <param name="strWhere">附加Where : " sid=1 "</param>
/// <param name="isExistsMoreLv">是否存在多级分类,一级时,请使用false,多级使用true，(一级不包括ParentID字段)</param>
/// <param name="pid">父级分类的ParentID</param>
/// <param name="fieldName">字段名:"SortId"</param>
/// <param name="fieldParentId">字段名:"ParentId"</param>
/// <returns>更新成功返回true，失败返回false</returns>
public bool UpdateAutoSort(Page page, string strWhere = "", bool isExistsMoreLv = false, int pid = 0, string fieldName = "Sort", string fieldParentId = "ParentId")
{
//更新排序
if (CommonBll.AutoSort("Id", "Article", strWhere, isExistsMoreLv, pid, fieldName, fieldParentId))
{
//判断是否启用缓存
if (CommonBll.IsUseCache())
{
//删除所有缓存
DelAllCache();
//重新载入缓存
GetList();
}
//添加用户操作记录
CommonBll.WriteLog("{0}对Article表进行了自动排序操作！");
//UseLogBll.GetInstence().Save(page, "{0}对Article表进行了自动排序操作！");
return(true);
}
return(false);
}
/// <summary>
/// 保存列表排序，如果使用了缓存，保存成功后会清空本表的所有缓存记录，然后重新加载进缓存
/// </summary>
/// <param name="page">当前页面指针</param>
/// <param name="grid1">页面表格</param>
/// <param name="tbxSort">表格中绑定排序的表单名</param>
/// <param name="sortName">排序字段名</param>
/// <returns>更新成功返回true，失败返回false</returns>
public bool UpdateSort(Page page, FineUI.Grid grid1, string tbxSort, string sortName = "Sort")
{
//更新排序
if (CommonBll.UpdateSort(page, grid1, tbxSort, "Article", sortName, "Id"))
{
//判断是否启用缓存
if (CommonBll.IsUseCache())
{
//删除所有缓存
DelAllCache();
//重新载入缓存
GetList();
}
//添加用户操作记录
CommonBll.WriteLog("{0}更新了Article表排序！");
//UseLogBll.GetInstence().Save(page, "{0}更新了Article表排序！");
return(true);
}
return(false);
}
/// <summary>
/// 删除记录
/// </summary>
/// <returns></returns>
public override string Delete()
{
//获取要删除的Id组
var id = GridViewHelper.GetSelectedKeyIntArray(Grid1);
//如果没有选择记录，则直接退出
if (id == null)
{
return("请选择要删除的记录。");
}
try
{
//逐个删除对应图片
foreach (var i in id)
{
//删除文章封面图片
InformationBll.GetInstence().DelFrontCoverImg(this, i);
//删除编辑器上传图片
UploadFileBll.Upload_BatDelPic(InformationTable.TableName, i);
}
//删除记录
bll.Delete(this, id);
return("删除编号Id为[" + string.Join(",", id) + "]的数据记录成功。");
}
catch (Exception e)
{
string result = "尝试删除编号ID为[" + string.Join(",", id) + "]的数据记录失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
return(result);
}
}
/// <summary>
/// 删除记录
/// </summary>
/// <returns></returns>
public override string Delete()
{
//获取要删除的Id组
var id = GridViewHelper.GetSelectedKeyIntArray(Grid1);
//如果没有选择记录，则直接退出
if (id == null)
{
return("请选择要删除的记录。");
}
try
{
//逐个文件删除
foreach (var i in id)
{
//获取文件路径
var path = UploadFileBll.GetInstence().GetFieldValue(i, UploadFileTable.Path) + "";
//删除文件与对应的记录
UploadFileBll.GetInstence().Upload_OneDelPic(path);
//删除记录
bll.Delete(this, i);
}
return("删除编号Id为[" + string.Join(",", id) + "]的数据记录成功。");
}
catch (Exception e)
{
string result = "尝试删除编号ID为[" + string.Join(",", id) + "]的数据记录失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
return(result);
}
}
/// <summary>
/// 删除Article表所有记录
/// </summary>
/// <param name="page">当前页面指针</param>
/// <param name="isAddUseLog">是否添加用户操作日志</param>
public void DeleteAll(Page page, bool isAddUseLog = true)
{
//设置Sql语句
var sql = string.Format("delete from {0}", ArticleTable.TableName);
//删除
var delete = new DeleteHelper();
delete.Delete(sql);
//判断是否启用缓存
if (CommonBll.IsUseCache())
{
//清空当前表所有缓存记录
DelAllCache();
}
if (isAddUseLog)
{
//添加用户操作记录
CommonBll.WriteLog("{0}删除了Article表记录！");
//UseLogBll.GetInstence().Save(page, "{0}删除了Article表所有记录！");
}
}
/// <summary>
/// 删除Article表记录
/// </summary>
/// <param name="page">当前页面指针</param>
/// <param name="id">记录的主键值</param>
/// <param name="isAddUseLog">是否添加用户操作日志</param>
public void Delete(Page page, int id, bool isAddUseLog = true)
{
//设置Sql语句
var sql = string.Format("delete from {0} where {1} = {2}", ArticleTable.TableName, ArticleTable.Id, id);
//删除
var delete = new DeleteHelper();
delete.Delete(sql);
//判断是否启用缓存
if (CommonBll.IsUseCache())
{
//删除缓存
DelCache(id);
}
if (isAddUseLog)
{
//添加用户操作记录
CommonBll.WriteLog("{0}删除了Article表id为【" + id + "】的记录！");
//UseLogBll.GetInstence().Save(page, "{0}删除了Article表id为【" + id + "】的记录！");
}
}
/// <summary>
/// 从IIS缓存中获取指定Id记录
/// </summary>
/// <param name="id">主键Id</param>
/// <returns>DataAccess.Model.Article</returns>
public DataAccess.Model.Article GetModelForCache(long id)
{
try
{
//从缓存中读取指定Id记录
var model = GetModelForCache(x => x.Id == id);
if (model == null)
{
//从数据库中读取
var tem = Article.SingleOrDefault(x => x.Id == id);
if (tem == null)
{
return(null);
}
else
{
//对查询出来的实体进行转换
model = Transform(tem);
SetModelForCache(model);
return(model);
}
}
else
{
return(model);
}
}
catch (Exception e)
{
//记录日志
CommonBll.WriteLog("从IIS缓存中获取Article表记录时出现异常", e);
return(null);
}
}
//GetClassName
protected string GetClassName(string PicUrl, string tid)
{
string ClassName = "";
//根据是否上传了图片显示不同的图标
if (!String.IsNullOrEmpty(PicUrl))
{
ClassName = "<span class=\"listpic\">";
}
else
{
ClassName = "<span class=\"listonpic\">";
}
//根据新闻ID取得栏目名称
bool b = new CommonBll().Exists("GL_Class", int.Parse(tid));
if (b)
{
ClassModel cm = new ClassBll().GetModel(int.Parse(tid));
ClassName += "[<a href=\"Products.aspx?mid=" + mid + "&cid=" + tid + "\">" + cm.ClassName + "</a>]</span> ";
}
return(ClassName);
}
public static string UpdateAppointment(string sid, string cv, string gv, string vv, string sv, string sdv)
{
string r = "";
B_AfterReModifyOrder b = new B_AfterReModifyOrder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
b.sid = sid;
if (cv == null || cv == "")
{
b.sdate = "2000-01-01";
}
else
{
b.sdate = CommonBll.GetBdate(cv);
}
b.senddate = CommonBll.GetBdate(sdv);
b.gofee = Convert.ToDecimal(gv);
b.servfee = Convert.ToDecimal(vv);
b.stext = sv;
if (basob.SetAppointment(b))
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = iv.badstr;
}
return(r);
}
public ActionResult PatientForm(int id = 0)
{
Patient pat = new Patient();
if (id > 0)
{
// get saved record..
}
ViewBag.Gender = new SelectList(CommonBll.Genders, "GenderId", "GenderName", pat.GenderId);
ViewBag.Titles = CommonBll.Titles;
ViewBag.Country = new SelectList(CommonBll.Countries, "CountryId", "CountryName", pat.CountryId);
ViewBag.MaritalStatus = new SelectList(CommonBll.MaritalStatus, "Id", "Value", pat.MaritalStatus);
ViewBag.Religion = new SelectList(CommonBll.Religion, "Id", "Value", pat.ReligionId);
ViewBag.Languages = new SelectList(CommonBll.GetLanguages(), "LanguageId", "LanguageName", pat.PreferredLanguage);
ViewBag.Ethnicities = new SelectList(CommonBll.Ethnicities, "Id", "Value", pat.EthnicGroup);
return(View(pat));
}
public static ArrayList QuerySetlmentList(string bdate, string code, string curpage, string edate, string emcode, string pagesize, string platform, string tabcode, string zt)
{
ArrayList r = new ArrayList();
DataTable lsr = new DataTable();
StringBuilder where = new StringBuilder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
int rcount = 0;
int pcount = 0;
if (code != "")
{
where.AppendFormat(" and scode like '%{0}%'", code);
}
if (platform != "")
{
where.AppendFormat(" and dname like '%{0}%'", platform);
}
if (bdate != "" && bdate != null)
{
where.AppendFormat(" and cdate >='{0}'", bdate);
}
if (edate != "" && edate != null)
{
where.AppendFormat(" and cdate <='{0}'", edate);
}
if (zt == "2")
{
where.AppendFormat(" and isetlment ={0}", zt);
}
Sys_ViewTable svt = svtb.QuerySelCols(emcode, tabcode, iv.u.rcode);
if (svt == null)
{
}
else
{
where.Append(CommonBll.SqlWhereReplace(iv.u, svt.sqlcondition));
string sfield = svt.sqlcols;
lsr = bsob.QueryList(Convert.ToInt32(curpage), Convert.ToInt32(pagesize), sfield, where.ToString(), "id desc", ref rcount, ref pcount);
if (lsr != null)
{
r.Add(pcount);
foreach (DataRow dr in lsr.Rows)
{
ArrayList al = new ArrayList();
foreach (DataColumn column in lsr.Columns)
{
switch (column.Caption)
{
case "ysmoney":
al.Add(0);
break;
default:
al.Add(dr[column].ToString());
break;
}
}
al.Add(bebb.QueryBtnListItems(emcode, iv.u.rcode, "LX", dr[1].ToString()));
r.Add(al);
}
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
/// <summary>树控件（Tree）
/// </summary>
/// <param name="dataTable">DataTable数据源</param>
/// <returns>树控件（Tree）</returns>
public void BandingTree(DataTable dataTable)
{
try
{
//检查指定的列是否在数据源中能否找到
if (dataTable.Rows.Count == 0)
{
return;
}
//筛选出全部一级节点
DataTable dtRoot = DataTableHelper.GetFilterData(dataTable, MenuInfoTable.ParentId, "0", MenuInfoTable.Sort, "Asc");
//判断是否有节点存在
if (dtRoot.Rows.Count != 0)
{
//循环读取节点
foreach (DataRow dr in dtRoot.Rows)
{
//判断当前节点是否有权限访问，没有则跳过本次循环
//暂时先注释掉权限判断，等添加相关权限后再开启
string s1 = "|" + dr[MenuInfoTable.Id].ToString() + "|";
string s2 = _pagePower;
if (s2.IndexOf(s1) < 0)
{
continue;
}
//创建树节点
var treenode = new FineUI.TreeNode();
//设置节点ID
treenode.NodeID = dr[MenuInfoTable.Id].ToString();
//设置节点名称
treenode.Text = dr[MenuInfoTable.Name].ToString();
treenode.Target = "mainRegion";
//判断当前节点是否为最终节点
if (int.Parse(dr[MenuInfoTable.IsMenu].ToString()) != 0)
{
//设置节点链接地址，并在Url后面添加页面加密参数
treenode.NavigateUrl = dr[MenuInfoTable.Url].ToString() + "?" + MenuInfoBll.GetInstence().PageUrlEncryptString();
treenode.Leaf = true;
}
else
{
treenode.NavigateUrl = "";
treenode.Leaf = false;
//设置树节点收缩起来
treenode.Expanded = false;
}
//添加子节点
AddChildrenNode(dataTable, treenode, dr[MenuInfoTable.Id].ToString());
//将节点加入树列表中
leftMenuTree.Nodes.Add(treenode);
}
}
}
catch (Exception ex)
{
CommonBll.WriteLog("", ex);
}
}
public static ArrayList QueryProdutionList(string bdate, string code, string curpage, string customer, string edate, string emcode, string fname, string pagesize, string platform, string tabcode)
{
ArrayList r = new ArrayList();
DataTable lsr = new DataTable();
StringBuilder where = new StringBuilder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
int rcount = 0;
int pcount = 0;
if (customer != "")
{
where.AppendFormat(" and customer like '%{0}%'", customer);
}
if (code != "")
{
where.AppendFormat(" and scode like '%{0}%'", code);
}
if (fname != "")
{
where.AppendFormat(" and fname like '%{0}%'", fname);
}
if (platform != "")
{
where.AppendFormat(" and dname like '%{0}%'", platform);
}
if (bdate != "" && bdate != null)
{
where.AppendFormat(" and edate >='{0}'", CommonBll.GetBdate(bdate));
}
if (edate != "" && edate != null)
{
where.AppendFormat(" and edate <='{0}'", Convert.ToDateTime(edate).AddDays(1).ToString("yyyy-MM-dd"));
}
Sys_ViewTable svt = svtb.QuerySelCols(emcode, tabcode, iv.u.rcode);
if (svt == null)
{
}
else
{
where.Append(CommonBll.SqlWhereReplace(iv.u, svt.sqlcondition));
string sfield = svt.sqlcols;
lsr = bsob.QueryList(Convert.ToInt32(curpage), Convert.ToInt32(pagesize), sfield, where.ToString(), " substring(scode,len(scode)-4,5) desc ", ref rcount, ref pcount);
if (lsr != null)
{
r.Add(pcount);
foreach (DataRow dr in lsr.Rows)
{
ArrayList al = new ArrayList();
al.Add(bebb.QueryBtnListItems(emcode, iv.u.rcode, "LX", dr[1].ToString()));
foreach (DataColumn column in lsr.Columns)
{
al.Add(dr[column].ToString());
}
r.Add(al);
}
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
/// <summary>
/// 更新
/// </summary>
/// <returns></returns>
public string Product00Update()
{
string result = "0";
string _id = GridViewHelper.GetSelectedKey(Grid1, true);
int id = ConvertHelper.Cint0(_id);
try
{
#region 数据验证
var sPROD_ID = PROD_ID.Text.Trim();
if (string.IsNullOrEmpty(PROD_ID.Text.Trim()))
{
PROD_ID.ShowRedStar = true;
return(PROD_ID.Label + "不能为空！");
}
if (string.IsNullOrEmpty(PROD_NAME1.Text.Trim()))
{
return(PROD_NAME1.Label + "不能为空！");
}
var sPROD_KIND = PROD_KIND.SelectedValue;
if (string.IsNullOrEmpty(sPROD_KIND) || sPROD_KIND == "0")
{
return(PROD_KIND.Label + "不能为空！");
}
var sPROD_DEP = PROD_DEP.SelectedValue;
if (string.IsNullOrEmpty(sPROD_DEP) || sPROD_DEP == "0")
{
return(PROD_DEP.Label + "不能为空！");
}
var sPROD_TYPE = PROD_TYPE.SelectedValue;
if (string.IsNullOrEmpty(sPROD_DEP))
{
return(PROD_TYPE.Label + "不能为空！");
}
var sPROD_Source = PROD_Source.SelectedValue;
if (string.IsNullOrEmpty(sPROD_Source))
{
return(PROD_Source.Label + "不能为空！");
}
var sINV_TYPE = INV_TYPE.SelectedValue;
if (string.IsNullOrEmpty(sINV_TYPE) || sINV_TYPE == "0")
{
return(INV_TYPE.Label + "不能为空！");
}
var sSTOCK_TYPE = STOCK_TYPE.SelectedValue;
if (string.IsNullOrEmpty(sSTOCK_TYPE) || sSTOCK_TYPE == "0")
{
return(STOCK_TYPE.Label + "不能为空！");
}
var sBOM_TYPE = BOM_TYPE.SelectedValue;
if (string.IsNullOrEmpty(sBOM_TYPE) || sBOM_TYPE == "0")
{
return(BOM_TYPE.Label + "不能为空！");
}
var sMarginControl = MarginControl.SelectedValue;
if (string.IsNullOrEmpty(sMarginControl) || sMarginControl == "0")
{
return(MarginControl.Label + "不能为空！");
}
var sPROD_RangTYPE = PROD_RangTYPE.SelectedValue;
if (string.IsNullOrEmpty(sPROD_RangTYPE) || sPROD_RangTYPE == "0")
{
return(PROD_RangTYPE.Label + "不能为空！");
}
var sPROD_iRang = PROD_iRang.Text;
if (string.IsNullOrEmpty(sPROD_iRang))
{
return(PROD_iRang.Label + "不能为空！");
}
if (!ConvertHelper.IsInt(sPROD_iRang))
{
return(PROD_iRang.Label + "必须为整数123！");
}
var sPROD_UNIT = PROD_UNIT.SelectedValue;
if (string.IsNullOrEmpty(sPROD_UNIT) || sPROD_UNIT == "0")
{
return(PROD_UNIT.Label + "不能为空！");
}
var sPROD_CONVERT1 = PROD_CONVERT1.Text;
if (string.IsNullOrEmpty(sPROD_CONVERT1))
{
return(PROD_CONVERT1.Label + "不能为空！");
}
if (!ConvertHelper.IsInt(sPROD_CONVERT1))
{
return(PROD_CONVERT1.Label + "必须为整数！");
}
var sPROD_UNIT1 = PROD_UNIT1.SelectedValue;
if (string.IsNullOrEmpty(sPROD_UNIT1) || sPROD_UNIT1 == "0")
{
return("包装单位不能为空！");
}
var sPROD_CONVERT2 = PROD_CONVERT2.Text;
if (string.IsNullOrEmpty(sPROD_CONVERT2))
{
return(PROD_CONVERT2.Label + "不能为空！");
}
if (!ConvertHelper.IsInt(sPROD_CONVERT2))
{
return(PROD_CONVERT2.Label + "必须为整数！");
}
var sPROD_UNIT2 = PROD_UNIT2.SelectedValue;
if (string.IsNullOrEmpty(sPROD_UNIT2) || sPROD_UNIT2 == "0")
{
return("外箱单位不能为空！");
}
var sReport_UNIT = Report_UNIT.SelectedValue;
if (string.IsNullOrEmpty(sReport_UNIT) || sReport_UNIT == "0")
{
return(Report_UNIT.Label + "不能为空！");
}
sPROD_ID = StringHelper.Left(sPROD_ID, 50);
if (!PRODUCT00Bll.GetInstence().Exist(x => x.PROD_ID == sPROD_ID) && id != 0)
{
return(PROD_ID.Label + "不存在！请重新输入！");
}
string sPROD_NAME1 = PROD_NAME1.Text.Trim();
if (PRODUCT00Bll.GetInstence().Exist(x => x.PROD_NAME1 == sPROD_NAME1 && x.PROD_ID != sPROD_ID) && id != 0)
{
return(PROD_NAME1.Label + "与其他商品重复！请重新输入！");
}
#endregion
#region 赋值
var model = new PRODUCT00(x => x.PROD_ID == sPROD_ID);
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
//if (model.PROD_ID == sPROD_ID)
//{
// model.SetIsNew(false);
//}
//else
//{
// model.SetIsNew(true);
//}
model.PROD_ID = sPROD_ID;
model.PROD_NAME1 = PROD_NAME1.Text;
model.PROD_NAME1_SPELLING = PROD_NAME1_SPELLING.Text;
model.PROD_NAME2 = PROD_NAME2.Text;
model.PROD_KIND = sPROD_KIND;
model.PROD_DEP = sPROD_DEP;
model.PROD_CATE = PROD_CATE.SelectedValue;
model.DIV_ID = DIV_ID.SelectedValue;
model.INV_TYPE = ConvertHelper.Cint(sINV_TYPE);
model.STOCK_TYPE = ConvertHelper.Cint(sSTOCK_TYPE);
model.BOM_TYPE = ConvertHelper.Cint(sBOM_TYPE);
model.MarginControl = ConvertHelper.Cint(sMarginControl);
model.PROD_RangTYPE = ConvertHelper.Cint(sPROD_RangTYPE);
model.PROD_iRang = ConvertHelper.Cint(sPROD_iRang);
model.PROD_SPEC = PROD_SPEC.Text;
model.PROD_Margin = PROD_Margin.Text;
model.PROD_BARCODE = PROD_BARCODE.Text;
model.PROD_UNIT = sPROD_UNIT;
model.PROD_UNIT1 = sPROD_UNIT1;
model.PROD_CONVERT1 = ConvertHelper.Cint(sPROD_CONVERT1);
model.PROD_UNIT2 = sPROD_UNIT2;
model.PROD_CONVERT2 = ConvertHelper.Cint(sPROD_CONVERT2);
model.Report_UNIT = ConvertHelper.Cint(sReport_UNIT);
model.PROD_MEMO = PROD_MEMO.Text;
if (id == 0)
{
model.CRT_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
model.CRT_USER_ID = OlUser.Manager_LoginName;
}
else
{
model.CRT_DATETIME = model.CRT_DATETIME;
model.CRT_USER_ID = model.CRT_USER_ID;
}
//model.CRT_USER_ID = "";
model.MOD_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
model.MOD_USER_ID = OlUser.Manager_LoginName;
//model.MOD_USER_ID = "";
model.LAST_UPDATE = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
model.STATUS = 0;
#endregion
////----------------------------------------------------------
////存储到数据库
model.SetIsNew(false);
//PRODUCT00Bll.GetInstence().Save(this, model, null, false, true);
result = result + "\r\n" + Product01Update();
if (!String.IsNullOrEmpty(result))
{
PRODUCT00Bll.GetInstence().Save(this, model);
PRODUCT00Bll.GetInstence().Insert_PRODUCT01(sPROD_ID, model.CRT_USER_ID);
result = "商品资料更新成功";
LoadData();
LoadData2(sPROD_ID);
}
}
catch (Exception e)
{
result = "更新失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
}
return(result);
}
public static string SavePreParePartOrder(string sid, ArrayList itemlist, string remark)
{
string r = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
B_WjOrder bwp = bsob.Query(" and sid='" + sid + "'");
if (bwp != null)
{
bool op = true;
bool wp = true;
B_WjPreparePartOrder bwpo = new B_WjPreparePartOrder();
bwpo.cdate = DateTime.Now.ToString();
bwpo.maker = iv.u.ename;;
bwpo.osid = bwp.msid;
bwpo.remark = remark;
bwpo.sid = CommonBll.GetSid();
bwpo.wsid = bwp.sid;
List <B_WjPreParePartGroupProduction> pbpp = new List <B_WjPreParePartGroupProduction>();
foreach (object[] al in itemlist)
{
B_WjPreParePartGroupProduction bpp = new B_WjPreParePartGroupProduction();
bpp.cdate = DateTime.Now.ToString();
bpp.icode = al[0].ToString();
bpp.iname = al[1].ToString();
bpp.maker = iv.u.ename;
bpp.osid = bwp.msid;
bpp.sid = bwpo.sid;
bpp.wsid = bwpo.wsid;
if (Convert.ToDecimal(al[5].ToString()) + Convert.ToDecimal(al[4].ToString()) < Convert.ToDecimal(al[3].ToString()))
{
bpp.pnum = Convert.ToDecimal(al[5].ToString());
op = false;
}
else
{
bpp.pnum = Convert.ToDecimal(al[3].ToString()) - Convert.ToDecimal(al[4].ToString());
}
if (Convert.ToDecimal(al[4].ToString()) > 0)
{
wp = false;
}
if (Convert.ToDecimal(al[5].ToString()) > 0)
{
bwpppgpb.Add(bpp);
}
}
if (op && wp)
{
bwpo.pcode = bwp.wcode;
}
else
{
bwpo.pcode = bwp.wcode + "-" + bwppb.GetOrderNum(sid).ToString().PadLeft(2, '0');
}
if (bwppb.Add(bwpo) > 0)
{
r = "S";
if (op)
{
cosb.UpState(sid, "iwjbh", 2);
cosb.UpState(bwp.osid, "iwjbh", 2);
}
else
{
cosb.UpState(sid, "iwjbh", 1);
cosb.UpState(bwp.osid, "iwjbh", 1);
}
}
else
{
r = "F";
}
}
}
else
{
r = iv.badstr;
}
return(r);
}
/// <summary>
/// 批量复制分项资料库图文档，作为任务书附件（没有历史版本）
/// </summary>
/// <param name="userId"></param>
/// <param name="pageId"></param>
/// <param name="arrId"></param>
/// <returns></returns>
public InvokeResult <List <int> > BatchCopyProjectDoc(int userId, int pageId, int[] arrId, List <string> thumbsImages)
{
InvokeResult <List <int> > res = new InvokeResult <List <int> >();
List <int> retIds = new List <int>();
try
{
using (TransactionScope trans = new TransactionScope())
{
StringBuilder thumbStr = new StringBuilder();
//thumbStr.Append("<root>");
foreach (int fileId in arrId)
{
var oldFile = this._ctx.FileLibraries.FirstOrDefault(r => r.fileId == fileId);
if (oldFile != null)
{
#region 制文件信息
FileLibrary fileLib = new FileLibrary
{
createData = DateTime.Now,
createUserId = userId,
name = oldFile.name,
ext = oldFile.ext,
sysObjId = 3,//已定义好的系统对象
localPath = oldFile.localPath,
tags = string.Empty,
lastVersion = 1,
size = oldFile.size,
hash = oldFile.hash
};
_ctx.FileLibraries.InsertOnSubmit(fileLib);
_ctx.SubmitChanges();
#endregion
#region 制版本信息
FileLibVersion version = new FileLibVersion()
{
fileId = fileLib.fileId,
fileName = fileLib.name,
localPath = fileLib.localPath,
createData = DateTime.Now,
createUserId = fileLib.createUserId,
fileVersion = 1,
ext = fileLib.ext,
hash = fileLib.hash
};
this._ctx.FileLibVersions.InsertOnSubmit(version);
this._ctx.SubmitChanges();
#endregion
#region 添加关联信息
PageFile pageFile = new PageFile()
{
pageId = pageId,
fileId = fileLib.fileId,
fileType = 1,
bizFileLibId = oldFile.fileId
};
this._ctx.PageFiles.InsertOnSubmit(pageFile);
this._ctx.SubmitChanges();
#endregion
#region 拷贝文件
string appPath = AppDomain.CurrentDomain.BaseDirectory;
string filePath = CommonBll.GetSysObjDir(oldFile.sysObjId.Value.ToString(), oldFile.sysObjId.Value, oldFile.createData);
string oldFileName = CommonBll.GetSysObjDocImg(oldFile.fileId, oldFile.hash, oldFile.lastVersion, "m");
string descPath = CommonBll.GetSysObjDir(fileLib.sysObjId.Value.ToString(), fileLib.sysObjId.Value, fileLib.createData);
string descPhyPath = FileExtension.CreateFolder(string.Format("{0}{1}", appPath, descPath));
string descFileName = CommonBll.GetSysObjDocImg(fileLib.fileId, fileLib.hash, fileLib.lastVersion, "m");
foreach (var s in thumbsImages)
{
string sourcePhyFileName = string.Format("{0}{1}{2}", appPath, filePath, oldFileName.Replace("_m.", "_" + s + "."));
string descPhyFileName = string.Format("{0}{1}", descPhyPath, descFileName.Replace("_m.", "_" + s + "."));
if (File.Exists(sourcePhyFileName) == true)
{
File.Copy(sourcePhyFileName, descPhyFileName);
}
}
#endregion
retIds.Add(fileLib.fileId);
//thumbStr.AppendFormat("<file hash=\"{0}\" size=\"{1}\" param=\"sysObject@{2}-{3}\" />", fileLib.hash, fileLib.size, fileLib.fileId, version.verId);
}
}
//thumbStr.Append("</root>");
trans.Complete();
res.Status = Status.Successful;
res.Message = thumbStr.ToString();
res.Value = retIds;
}
}
catch (Exception ex)
{
res.Message = ex.Message;
res.Status = Status.Failed;
}
return(res);
}
/// <summary>
/// 数据保存
/// </summary>
/// <returns></returns>
public override string Save()
{
string result = string.Empty;
int id = ConvertHelper.Cint0(hidId.Text);
try
{
#region 数据验证
if (string.IsNullOrEmpty(txtName.Text.Trim()))
{
return(txtName.Label + "不能为空！");
}
var sName = StringHelper.Left(txtName.Text, 50);
if (MenuInfoBll.GetInstence().Exist(x => x.Name == sName && x.Id != id))
{
return(txtName.Label + "已存在！请重新输入！");
}
if (string.IsNullOrEmpty(txtUrl.Text.Trim()))
{
return(txtUrl.Label + "不能为空！");
}
var sUrl = StringHelper.Left(txtUrl.Text, 250, true, false);
if (MenuInfoBll.GetInstence().Exist(x => x.Url == sUrl && x.Id != id))
{
return(txtUrl.Label + "已存在！请重新输入！");
}
#endregion
#region 赋值
//获取实体
var model = new MenuInfo(x => x.Id == id);
//设置名称
model.Name = sName;
//连接地址
model.Url = sUrl;
//对应的父类id
model.ParentId = ConvertHelper.Cint0(txtParent.Text);
//由于限制了编辑时不能修改父节点，所以这里只对新建记录时处理
if (id == 0)
{
//设定当前的深度与设定当前的层数级
if (model.ParentId == 0)
{
//设定当前的层数级
model.Depth = 0;
}
else
{
//设定当前的层数
model.Depth = ConvertHelper.Cint0(MenuInfoBll.GetInstence().GetFieldValue(ConvertHelper.Cint0(ddlParentId.SelectedValue), MenuInfoTable.Depth)) + 1;
}
}
//设置排序
if (txtSort.Text == "0")
{
model.Sort = MenuInfoBll.GetInstence().GetSortMax(model.ParentId) + 1;
}
else
{
model.Sort = ConvertHelper.Cint0(txtSort.Text);
}
//设定当前项属于菜单还是页面
model.IsMenu = ConvertHelper.StringToByte(rblIsMenu.SelectedValue);
//设定当前项是否显示
model.IsDisplay = ConvertHelper.StringToByte(rblIsDisplay.SelectedValue);
#endregion
//----------------------------------------------------------
//存储到数据库
MenuInfoBll.GetInstence().Save(this, model);
}
catch (Exception e)
{
result = "保存失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
}
return(result);
}
/// <summary>
/// 数据保存
/// </summary>
/// <returns></returns>
public override string Save()
{
string result = string.Empty;
int id = ConvertHelper.Cint0(hidId.Text);
try
{
#region 数据验证
if (string.IsNullOrEmpty(PRCAREA_ID.Text.Trim()))
{
return(PRCAREA_ID.Label + "不能为空！");
}
if (string.IsNullOrEmpty(PRCAREA_NAME.Text.Trim()))
{
return(PRCAREA_NAME.Label + "不能为空！");
}
var sPcarea_id = StringHelper.Left(PRCAREA_ID.Text, 50);
if (SHOP_PRICE_AREABll.GetInstence().Exist(x => x.PRCAREA_ID == sPcarea_id) && id == 0)
{
return(PRCAREA_ID.Label + "已存在！请重新输入！");
}
var sPcarea_name = StringHelper.Left(PRCAREA_NAME.Text, 50);
if (SHOP_PRICE_AREABll.GetInstence().Exist(x => x.PRCAREA_NAME == sPcarea_name) && id == 0)
{
return(PRCAREA_NAME.Label + "已存在！请重新输入！");
}
//byte sEnable = ConvertHelper.StringToByte(ENABLE.SelectedValue);
//if (sEnable == 0)
//{
// return ENABLE.Label + "必须选择一个！";
//}
#endregion
#region 赋值
var model = new SHOP_PRICE_AREA(x => x.Id == id);
//var OlUser = new OnlineUsers(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == OnlineUsersBll.GetInstence().GetUserHashKey());
//var OlUser = OnlineUsers.SingleOrDefault(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
model.PRCAREA_ID = PRCAREA_ID.Text;
model.PRCAREA_NAME = PRCAREA_NAME.Text;
model.PRCAREA_MEMO = PRCAREA_MEMO.Text;
model.ENABLE = ConvertHelper.StringToByte(ENABLE.SelectedValue);
if (id == 0)
{
model.CRT_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
model.CRT_USER_ID = OlUser.Manager_LoginName;
}
else
{
model.CRT_DATETIME = model.CRT_DATETIME;
model.CRT_USER_ID = model.CRT_USER_ID;
}
//model.CRT_USER_ID = "";
model.MOD_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
model.MOD_USER_ID = OlUser.Manager_LoginName;
//model.MOD_USER_ID = "";
model.LAST_UPDATE = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
model.STATUS = 0;
#endregion
////----------------------------------------------------------
////存储到数据库
SHOP_PRICE_AREABll.GetInstence().Save(this, model);
}
catch (Exception e)
{
result = "保存失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
}
return(result);
}
public static string AddProduction(string direction, string fixs, string ggy, string glasss, string gsize, string itype, string locks, string mname, string msname, string pd, string ph, string place, string pmsd, string pname, string pnum, string premark, string psid, string pw, string sid, string sitype, string stype)
{
string r = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
B_AfterGroupProduction ao = new B_AfterGroupProduction();
if (iv.f)
{
ao.direction = direction;
ao.fixs = fixs;
ao.glass = glasss;
ao.gsize = gsize;
ao.height = Convert.ToInt32(ph);
ao.width = Convert.ToInt32(pw);
ao.deep = Convert.ToInt32(pd);
ao.iheight = 0;
ao.iwidth = 0;
ao.ideep = 0;
ao.pnum = Convert.ToDecimal(pnum);
ao.itype = itype;
ao.locks = locks;
ao.mname = mname;
ao.place = place;
ao.pname = pname;
ao.remark = premark;
ao.sid = sid;
ao.stype = stype;
ao.msname = msname;
ao.sitype = sitype;
ao.maker = iv.u.ename;
ao.ggy = ggy;
ao.pmsd = pmsd;
ao.cdate = DateTime.Now.ToString();
if (psid == "")
{
ao.gnum = bagpb.GetGnum(" and sid='" + sid + "'");
ao.psid = CommonBll.GetSid();
if (bagpb.Add(ao) > 0)
{
r = "S";
}
else
{
r = "F";
}
}
else
{
ao.psid = psid;
if (bagpb.Update(ao))
{
r = "S";
}
else
{
r = "F";
}
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string SaveCustomerOrder(string address, string citycode, string cityname, string cmoney, string colortype, string distype, string customer, string gzname, string gztelephone,
string lxtype, string mname, string otype, string remark, string shopcode, string shopname, string sid, string source, string telephone, string wcode, string yxdate)
{
string r = "";
BusiWorkFlowBll bwfb = new BusiWorkFlowBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_SaleDiscount ssd = ssdb.Query(" and dcode='" + distype + "'");
B_CustormOrder bco = new B_CustormOrder();
bco.ccode = "";
bco.wcode = wcode;
bco.cmoney = Convert.ToDecimal(cmoney);
bco.customer = customer;
bco.telephone = telephone;
bco.community = "";
bco.address = address;
bco.aname = "";
bco.acode = "";
bco.dname = shopname;
bco.dcode = shopcode;
bco.e_city = cityname;
bco.e_citycode = citycode;
bco.e_citytype = "";
bco.gzname = gzname;
bco.gztelephone = gztelephone;
bco.saletelephone = "";
bco.otype = otype;
bco.state = false;
bco.mname = mname;
bco.source = source;
bco.ps = remark;
bco.maker = iv.u.ename;
bco.cdate = DateTime.Now.ToString();
bco.istax = false;
bco.isdf = false;
bco.yxdate = CommonBll.GetBdate(yxdate);
bco.lxtype = lxtype;
bco.colorpane = colortype;
if (distype != "")
{
bco.disactname = ssd != null ? ssd.dname : "";
bco.disactcode = distype;
}
else
{
bco.disactname = "";
bco.disactcode = "";
}
if (sid == "")
{
bco.csid = CommonBll.GetSid();
bco.ccode = cocb.SetCustomerOrderCode();
if (bcob.Add(bco) > 0)
{
bwfb.CreateWorkFlow(bco.csid, "0001");
r = bco.csid;
}
else
{
r = "F";
}
}
else
{
bco.csid = sid;
if (bcob.Update(bco))
{
r = bco.csid;
}
else
{
r = "F";
}
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string SaveOrder(string acity, string address, string aprovince, string bcode, string csid, string customer, string emcode, string gzname, string mdate, string mremark, ArrayList plist, string sid, string telephone)
{
string r = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
B_SaleOrder bso = bsob.Query(" and sid='" + sid + "'");
B_MeasureOrder bco = new B_MeasureOrder();
bco.acity = acity;
bco.address = address;
bco.aprovince = aprovince;
bco.customer = customer;
bco.gzname = gzname;
bco.maker = iv.u.ename;
bco.mdate = mdate;
bco.mremark = mremark;
bco.osid = sid;
bco.telephone = telephone;
bco.city = bso.city;
bco.citycode = bso.citycode;
bco.dcode = bso.dcode;
bco.dname = bso.dname;
bco.mname = bso.mname;
bco.cdate = DateTime.Now.ToString();
bco.sdcode = DateTime.Now.ToString("yyyymmddhhMMss");
if (csid == "")
{
bco.sid = CommonBll.GetSid();
}
else
{
bco.sid = csid;
}
List <B_MeasureProduction> lbp = new List <B_MeasureProduction>();
foreach (object[] o in plist)
{
B_MeasureProduction bmp = new B_MeasureProduction();
var p = o;
bmp.cdate = DateTime.Now.ToString();
bmp.maker = iv.u.ename;
bmp.pcname = p[0].ToString();
bmp.pcnum = Convert.ToInt32(p[1].ToString());
bmp.sid = bco.sid;
lbp.Add(bmp);
}
bco.bplist = lbp;
if (bmlb.CheckLimited(bco.dcode, bco.mdate))
{
r = "MOB";
}
else
{
if (csid == "")
{
CB_OrderState cos = new CB_OrderState();
bco.qtimg = qcb.CreateQtCode(System.Web.HttpContext.Current.Server.MapPath("/UpFile/OrderQt/"), CommonBll.GetHost() + "UIClient/SalesBusiness/DistributorOrder/SaleOrderDetail.htm?Sid=" + bco.sid);
if (bmob.Add(bco) > 0)
{
bwfb.CreateWorkFlow(bco.sid, emcode);
cos.sid = bco.sid;
cosb.Add(cos);
r = "S";
}
else
{
r = "F";
}
EventBtnDo.FireEventBtn(bco.sid, bcode, "1", " 保存测量单");
}
else
{
if (bmob.Update(bco))
{
r = "S";
}
else
{
r = "F";
}
EventBtnDo.FireEventBtn(bco.sid, bcode, "1", " 更改测量单");
}
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static ArrayList QueryOrderList(string bdate, string city, string code, string curpage, string dname, string edate, string emcode, string pagesize, string tabcode)
{
ArrayList r = new ArrayList();
DataTable lsr = new DataTable();
StringBuilder where = new StringBuilder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
int rcount = 0;
int pcount = 0;
if (code != "")
{
where.AppendFormat(" and scode like '%{0}%'", code);
}
if (city != "")
{
where.AppendFormat(" and city like '%{0}%'", city);
}
if (dname != "")
{
where.AppendFormat(" and dname like '%{0}%'", dname);
}
if (bdate != "" && bdate != null)
{
where.AppendFormat(" and cdate >='{0}'", bdate);
}
if (edate != "" && edate != null)
{
where.AppendFormat(" and cdate <='{0}'", edate);
}
where.AppendFormat(" and bdcode='{0}'", iv.u.dcode.Substring(0, 8));
Sys_ViewTable svt = svtb.QuerySelCols(emcode, tabcode, iv.u.rcode);
if (svt == null)
{
}
else
{
where.Append(CommonBll.SqlWhereReplace(iv.u, svt.sqlcondition));
string sfield = svt.sqlcols;
lsr = bsob.QueryList(Convert.ToInt32(curpage), Convert.ToInt32(pagesize), sfield, where.ToString(), "id desc", ref rcount, ref pcount);
if (lsr != null)
{
r.Add(pcount);
foreach (DataRow dr in lsr.Rows)
{
ArrayList al = new ArrayList();
al.Add(bebb.QueryBtnListItems(emcode, iv.u.rcode, "LX", dr[1].ToString()));
foreach (DataColumn column in lsr.Columns)
{
if (column.Caption == "zt")
{
al.Add("<span style='color:blue; font-weight:bolder'>" + cbeb.GetOrderState(dr[1].ToString()) + "</span>");
}
else
{
al.Add(dr[column].ToString());
}
}
r.Add(al);
}
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public ActionResult ConfirmOrder(string orderCode)
{
try
{
if (string.IsNullOrEmpty(orderCode))
{
return(this.HandleError("订单编号不能为空！"));
}
var model = Bll.ConfirmOrder(base.LoginUser.UserID, base.DeliveryRegion, base.language, orderCode);
if (model)
{
LogHelper.Info("--------ConfirmOrder----获取订单的商品图片开始---orderCode：" + orderCode);
/// 获取订单的商品图片
ProductInfoModel productInfoModel = orderManager.GetOrderImage(orderCode);
LogHelper.Info("--------ConfirmOrder----获取订单的商品图片结束---orderCode：" + orderCode);
LogHelper.Info("--------ConfirmOrder----设置对象参数开始");
InformationEntity InformationEntity = new InformationEntity();
InformationEntity.InfoType = 1;
InformationEntity.WebInnerType = 3;
InformationEntity.SendDest = CommonBll.GetUserRegion(base.LoginUser.UserID);
InformationEntity.SendUserId = base.LoginUser.UserID;
InformationEntity.TradeCode = orderCode;
InformationEntity.Title = InformationUtils.OrderTradeSuccTitle;
InformationEntity.InfoContent = InformationUtils.OrderTradeSuccContent_Prefix
+ orderCode + InformationUtils.OrderTradeSuccContent_suffix;
if (productInfoModel != null)
{
InformationEntity.ImagePath = productInfoModel.ImagePath;
}
else
{
InformationEntity.ImagePath = null;
}
InformationEntity.Summary = null;
InformationEntity.LinkUrl = "my/detail?orderCode=" + orderCode;
InformationEntity.StartTime = null;
InformationEntity.EndTime = null;
InformationEntity.LongTerm = 0;
InformationEntity.CreateTime = DateTime.Now;
LogHelper.Info("--------ConfirmOrder----设置对象参数结束");
LogHelper.Info("--------ConfirmOrder----执行消息表插入方法开始");
InformationBll.AddInformation(InformationEntity);
LogHelper.Info("--------ConfirmOrder----执行消息表插入方法结束");
return(this.HandleSuccess("ok"));
}
else
{
return(this.HandleError("系统异常请稍后再试！"));
}
}
catch (Exception ex)
{
return(this.HandleError(ex));
}
}
/// <summary>
/// 汇整进货单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ArchiveButton_Click(object sender, EventArgs e)
{
DatePicker dpStart = archiveWindow.FindControl("archiveDatePanel").FindControl("inStartDate") as DatePicker;
DatePicker dpEnd = archiveWindow.FindControl("archiveDatePanel").FindControl("inEndDate") as DatePicker;
//1.查询总部进货表TAKEIN10
// 1)进货单状态为 2=核准
// 2)进货单类型为一般进货 TAKEIN_TYPE=1
// 3)SHOP_ID = 当前登录用户的总部编号
// 4)在指定日期范围内
//2.遍历结果
//3.更新出货单状态为5=月结(关单)， 并且锁定出货单(LOCKED=1)
//4.更新成功后查询出货单明细更新到应收明细表
//5.保存应收主信息
List <ConditionFun.SqlqueryCondition> wheres = QueryTakeinListCondition(shopId, dpStart.Text, dpEnd.Text);
while (true)
{
List <TAKEIN10> inList = selectHelper.Select <TAKEIN10>(false, 0, null, 1, 100, wheres).ExecuteTypedList <TAKEIN10>();
if (inList == null || inList.Count == 0)
{
break;
}
//遍历进货单
foreach (TAKEIN10 row in inList)
{
try
{
//更新进货单
int retValue = updaterHelper.Update(string.Format("update TAKEIN10 set STATUS = 5, LOCKED = 1 where Id = {0}", row.Id));
//更新成功 则汇整进入总店应付账单表
if (retValue == 1)
{
List <ConditionFun.SqlqueryCondition> conditions = new List <ConditionFun.SqlqueryCondition>();
conditions.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "SHOP_ID", Comparison.Equals, row.SHOP_ID, false, false));
conditions.Add(new ConditionFun.SqlqueryCondition(ConstraintType.And, "TAKEIN_ID", Comparison.Equals, row.TAKEIN_ID, false, false));
//查询进货单明细
List <TAKEIN11> itemList = selectHelper.Select <TAKEIN11>(false, 0, null, conditions).ExecuteTypedList <TAKEIN11>();
if (itemList == null || itemList.Count == 0)
{
CommonBll.WriteLog(string.Format("进货单{0}未查询到明细", row.TAKEIN_ID), null);
continue;
}
//采购总金额
decimal amount = 0;
//税额
decimal tax = 0;
//
foreach (TAKEIN11 item in itemList)
{
DUE01 payItem = new DUE01();
//批次号
payItem.BAT_NO = item.BAT_NO;
//采购金额
payItem.COST = item.STD_PRICE * item.STD_QUAN;
//折价金额
payItem.ITEM_DISC_AMT = item.Item_DISC_Amt;
//备注
payItem.MEMO = item.MEMO;
//商品编号
payItem.PROD_ID = item.PROD_ID;
//采购量
payItem.QUAN1 = item.QUAN1;
//取消量
payItem.QUAN2 = item.QUAN2;
//分店编号
payItem.SHOP_ID = item.SHOP_ID;
//序号
payItem.SNO = item.SNo;
//标准单价
payItem.STD_PRICE = item.STD_PRICE;
//验收量
payItem.STD_QUAN = item.STD_QUAN;
//验收单位
payItem.STD_UNIT = item.STD_UNIT;
//进货单编号
payItem.TAKEIN_ID = item.TAKEIN_ID;
//税额
payItem.TAX = item.Tax;
//采购金额
amount += payItem.COST;
payItem.Save();
}
DUE00 payMain = new DUE00();
//进货单审核日期
payMain.APP_DATETIME = row.APP_DATETIME;
//进货单审核人
payMain.APP_USER = row.APP_USER;
//应付账单创建日期
payMain.CRT_DATETIME = DateTime.Now;
//应付账单创建人
payMain.CRT_USER_ID = userId;
//进货单日期
payMain.INPUT_DATE = row.INPUT_DATE;
//发票
payMain.INVOICE_ID = row.INVOICE_ID;
//应付账单最后修改日期
payMain.LAST_UPDATE = DateTime.Now;
//备注
payMain.Memo = row.Memo;
//更新时间
payMain.MOD_DATETIME = DateTime.Now;
//修改人
payMain.MOD_USER_ID = userId;
//预付款
payMain.PRE_PAY = row.PRE_PAY;
//预付款单号
payMain.PRE_PAY_ID = row.PRE_PAY_ID;
//关联ID
payMain.RELATE_ID = row.RELATE_ID;
//进货分店编号
payMain.SHOP_ID = row.SHOP_ID;
//待核准状态
payMain.STATUS = 1;
//供应商编号
payMain.SUP_ID = row.SUP_ID;
//进货单号
payMain.TAKEIN_ID = row.TAKEIN_ID;
//进货类型
payMain.TAKEIN_TYPE = 1; //一般进货
//进货单金额
payMain.TOT_AMOUNT = amount;
//进货单数量
payMain.TOT_QTY = row.TOT_QTY;
//税额
payMain.TOT_TAX = tax;
payMain.USER_ID = userId;
//保存主信息
payMain.Save();
//供应商关系已经存在
if (supDic.ContainsKey(payMain.SUP_ID))
{
continue;
}
try
{
//查询供应商
var sup = selectHelper.SelectSingle <SUPPLIERS>(false, null,
new List <ConditionFun.SqlqueryCondition>()
{
new ConditionFun.SqlqueryCondition(ConstraintType.Where, "SUP_ID", Comparison.Equals, payMain.SUP_ID)
});
if (sup != null)
{
//缓存供应商
supDic[sup.SUP_ID] = sup.SUP_NAME;
//分店和供应商关系
SHOP_SUPPLIER_RELATION relation = new SHOP_SUPPLIER_RELATION();
relation.CRT_DATETIME = DateTime.Now;
relation.MEMO = "来源汇整进货单";
relation.SHOP_ID = payMain.SHOP_ID;
relation.SUP_ID = sup.SUP_ID;
relation.SUP_NAME = sup.SUP_NAME;
//保存关联关系
relation.Save();
//
supList.Add(relation);
supDropdown.DataBind();
}
}catch (Exception ex)
{
CommonBll.WriteLog("查询供应商出错", ex);
}
//
}
}
catch (Exception ex)
{
CommonBll.WriteLog(string.Format("汇整进货单{0}发生异常", row.TAKEIN_ID), ex);
}
}
}
}
