/// <summary>
/// 数据保存
/// </summary>
/// <returns></returns>
public override string Save()
{
string result = string.Empty;
int id = ConvertHelper.Cint0(hidId.Text);
try
{
#region 数据验证
if (string.IsNullOrEmpty(txtTitle.Text.Trim()))
{
return(txtTitle.Label + "不能为空！");
}
if (ddlInformationClass_Id.SelectedValue == "0")
{
return(ddlInformationClass_Id.Label + "为必选项，请选择！");
}
//判断是否重复
var sTitle = StringHelper.FilterSql(txtTitle.Text, true);
var icId = ConvertHelper.Cint0(ddlInformationClass_Id.SelectedValue);
if (
DataAccess.DataModel.Information.Exists(
x => x.Title == sTitle && x.InformationClass_Id == icId && x.Id != id))
{
return(txtTitle.Label + "已存在！请重新输入！");
}
#endregion
#region 赋值
//获取实体
var model = new Information(x => x.Id == id);
//------------------------------------------
//设置名称
model.Title = StringHelper.Left(txtTitle.Text, 100);
//取得分类
model.InformationClass_Id = ConvertHelper.Cint0(ddlInformationClass_Id.SelectedValue);
model.InformationClass_Root_Id =
ConvertHelper.Cint0(InformationClassBll.GetInstence()
.GetFieldValue(model.InformationClass_Id, InformationClassTable.ParentId));
if (model.InformationClass_Root_Id > 0)
{
model.InformationClass_Root_Name = InformationClassBll.GetInstence()
.GetName(this, model.InformationClass_Root_Id);
}
model.InformationClass_Name = StringHelper.Left(ddlInformationClass_Id.SelectedText, 20);
//重定向
model.RedirectUrl = StringHelper.Left(txtRedirectUrl.Text, 250);
//------------------------------------------
//编辑器
model.Content = StringHelper.Left(txtText.Text, 0, true, false);
model.Upload = StringHelper.Left(txtUpload.Text, 0, true, false);
//这里必须用回前端存放的Key，不然删除时无法同步删除编辑器上传的图片
RndKey = StringHelper.Left(txtRndKey.Text, 0);
//检查用户上传的文件和最后保存的文件是否有出入，
//如果上传的文件大于保存的文件，把不保存，但本次操作已经上传的文件删除。
model.Upload = UploadFileBll.GetInstence().FCK_BatchDelPic(model.Content, model.Upload);
//------------------------------------------
//其它值
model.NewsTime = dpNewsTime.SelectedDate ?? DateTime.Now;
model.AddYear = model.NewsTime.Year;
model.AddMonth = model.NewsTime.Month;
model.AddDay = model.NewsTime.Day;
model.Notes = StringHelper.Left(txtNotes.Text, 200);
model.Keywords = StringHelper.Left(txtKeywords.Text, 50);
model.Author = StringHelper.Left(txtAuthor.Text, 50);
model.FromName = StringHelper.Left(txtFromName.Text, 50);
model.SeoTitle = StringHelper.Left(txtSeoTitle.Text, 100);
model.SeoKey = StringHelper.Left(txtSeoKey.Text, 100);
model.SeoDesc = StringHelper.Left(txtSeoDesc.Text, 200);
model.Sort = 0;
//设定当前项是否显示
model.IsDisplay = ConvertHelper.StringToByte(rblIsDisplay.SelectedValue);
model.IsHot = ConvertHelper.StringToByte(rblIsHot.SelectedValue);
model.IsTop = ConvertHelper.StringToByte(rblIsTop.SelectedValue);
//------------------------------------------
//判断是否是新增
if (model.Id == 0)
{
//添加时间与用户
model.AddDate = DateTime.Now;
//修改时间与用户
model.UpdateDate = DateTime.Now;
}
else
{
//修改时间与用户
model.UpdateDate = DateTime.Now;
}
model.Manager_Id = OnlineUsersBll.GetInstence().GetManagerId();
model.Manager_CName = OnlineUsersBll.GetInstence().GetManagerCName();
#endregion
//------------------------------------------
#region 图片
if (this.filePhoto.HasFile && this.filePhoto.FileName.Length > 3)
{
int vid = 3; //3 文章封面
//---------------------------------------------------
var upload = new UploadFile();
result = new UploadFileBll().Upload_AspNet(this.filePhoto.PostedFile, vid, RndKey,
OnlineUsersBll.GetInstence().GetManagerId(), OnlineUsersBll.GetInstence().GetManagerCName(),
upload);
this.filePhoto.Dispose();
//---------------------------------------------------
if (result.Length == 0) //上传成功
{
model.FrontCoverImg = upload.Path;
}
else
{
CommonBll.WriteLog("上传出错：" + result); //收集异常信息
return("上传出错！" + result);
}
}
//如果是修改，检查用户是否重新上传过封面图片，如果是删除旧的图片
if (model.Id > 0)
{
UploadFileBll.GetInstence()
.Upload_DiffFile(InformationTable.Id, InformationTable.FrontCoverImg, InformationTable.TableName,
model.Id, model.FrontCoverImg);
//同步UploadFile上传表
UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, InformationTable.TableName, model.Id);
}
#endregion
//----------------------------------------------------------
//存储到数据库
InformationBll.GetInstence().Save(this, model);
#region 步更新上传图片表绑定Id
if (id == 0)
{
//同步UploadFile上传表记录，绑定刚刚上传成功的文件Id为当前记录Id
UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, InformationTable.TableName, model.Id);
}
#endregion
}
catch (Exception e)
{
result = "保存失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
}
return(result);
}
protected void btnImport_Click(object sender, EventArgs e)
{
//判断
FineUI.RadioButton RaddpUp_Date = Window2.FindControl("A").FindControl("RaddpUp_Date") as FineUI.RadioButton;
FineUI.RadioButton RadEXPECT_DATE = Window2.FindControl("B").FindControl("RadEXPECT_DATE") as FineUI.RadioButton;
if (RaddpUp_Date.Checked == false && RadEXPECT_DATE.Checked == false)
{
Alert.Show("请选择时间");
return;
}
string Start_Time = "";
string End_Time = "";
//参数
Random ran = new Random();
string SHOP_ID = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString();
string COL_ID = SHOP_ID + "CL" + DateTime.Now.ToString("yyyy-MM-dd") + +ran.Next(1000, 9999);
string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名
int IsTime = 1;
if (RaddpUp_Date.Checked)
{
//获取时间
DatePicker dpUp_DateBeg = Window2.FindControl("A").FindControl("dpUp_DateBeg") as DatePicker;
DateTime dt_up_date_bg = ConvertHelper.StringToDatetime(dpUp_DateBeg.SelectedDate.ToString());
DatePicker dpUp_DateEnd = Window2.FindControl("A").FindControl("dpUp_DateEnd") as DatePicker;
DateTime dt_up_date_end = ConvertHelper.StringToDatetime(dpUp_DateEnd.SelectedDate.ToString());
IsTime = 0;
Start_Time = dt_up_date_bg.ToString();
End_Time = dt_up_date_end.ToString();
}
if (RadEXPECT_DATE.Checked)
{
DatePicker dpEXPECT_DATEBeg = Window2.FindControl("B").FindControl("dpEXPECT_DATEBeg") as DatePicker;
DateTime dt_expect_date_bg = ConvertHelper.StringToDatetime(dpEXPECT_DATEBeg.SelectedDate.ToString());
DatePicker dpEXPECT_DATEEnd = Window2.FindControl("B").FindControl("dpEXPECT_DATEEnd") as DatePicker;
DateTime dt_expect_date_end = ConvertHelper.StringToDatetime(dpEXPECT_DATEEnd.SelectedDate.ToString());
IsTime = 1;
Start_Time = dt_expect_date_bg.ToString();
End_Time = dt_expect_date_end.ToString();
}
int ex_int = TAKEIN00Bll.GetInstence().LeadIntoProductPlanList(Start_Time, End_Time, IsTime.ToString(), SHOP_ID, manager_LoginName);
if (ex_int == 0)
{
Alert.Show("引入成功！");
}
else
{
Alert.Show("引入失败！请重新引入！");
}
LoadData();
}
/// <summary>
/// 主表保存
/// </summary>
/// <returns></returns>
public string MAINEdit()
{
string _TAKEIN_ID = tbxTAKEIN_ID.Text;
try
{
var model = new TAKEIN10(x => x.TAKEIN_ID == _TAKEIN_ID);
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
string _SHOP_ID = ddlSHOP_NAME.SelectedValue;
if (String.IsNullOrEmpty(_TAKEIN_ID))
{
model.SetIsNew(true);
model.CRT_DATETIME = DateTime.Now;
model.CRT_USER_ID = OlUser.Manager_LoginName;
DataTable dt = new DataTable();
dt = (DataTable)SPs.Get_ORDER_SEED(_SHOP_ID, "TAKEIN10").ExecuteDataTable();
_TAKEIN_ID = dt.Rows[0]["PLANE_ID"].ToString();
tbxTAKEIN_ID.Text = _TAKEIN_ID;
//var model = Purchase00.SingleOrDefault(x => x.Purchase_ID == _Pur00_id);
}
model.SHOP_ID = _SHOP_ID;
model.TAKEIN_ID = _TAKEIN_ID.ToString();
model.STATUS = ConvertHelper.Cint(ddlStatus.SelectedValue);
model.INPUT_DATE = ConvertHelper.StringToDatetime(dpINPUT_DATE.SelectedDate.ToString());
if (String.IsNullOrEmpty(ddlSUP_ID.SelectedValue))
{
model.SUP_ID = "";
}
else
{
model.SUP_ID = ddlSUP_ID.SelectedValue;
}
model.STOCK_ID = ddlSTOCK_ID.SelectedValue;
model.USER_ID = OlUser.Manager_LoginName;
model.APP_USER = OlUser.Manager_LoginName;
model.APP_DATETIME = tbxAPP_DATETIME.Text == "" ? DateTime.Parse("1900-01-01 00:00:00") : DateTime.Now;
string _RELATE_ID = tbxRELATE_ID.Text;
model.RELATE_ID = _RELATE_ID;
//if (!String.IsNullOrEmpty(_RELATE_ID))
//{
// var modelOrder = new OUT_BACK00(x => x.BK_ID == _RELATE_ID);
// modelOrder.Exported = 1;
// modelOrder.Exported_ID = _TAKEIN_ID;
// modelOrder.Save();
//}
model.Memo = tbxMemo.Text;
model.LOCKED = ConvertHelper.StringToByte(ckLOCKED.Checked ? "1" : "0");
model.MOD_DATETIME = DateTime.Now;
model.MOD_USER_ID = OlUser.Manager_LoginName;
model.LAST_UPDATE = DateTime.Now;
model.Trans_STATUS = 0;
TAKEIN10Bll.GetInstence().Save(this, model);
LoadMAIN();
}
catch (Exception err)
{
return(err.Message);
}
return("");
}
/// <summary>
/// 数据保存
/// </summary>
/// <returns></returns>
public override string Save()
{
string result = string.Empty;
int id = ConvertHelper.Cint0(hidId.Text);
try
{
#region 数据验证
if (string.IsNullOrEmpty(CATE_ID.Text.Trim()))
{
return(CATE_ID.Label + "不能为空！");
}
if (string.IsNullOrEmpty(CATE_NAME.Text.Trim()))
{
return(CATE_NAME.Label + "不能为空！");
}
if (string.IsNullOrEmpty(DEP_ID.SelectedValue) || DEP_ID.SelectedValue == "0")
{
return(DEP_ID.Label + "不能为空！");
}
var sCate_id = StringHelper.Left(CATE_ID.Text, 50);
if (PROD_CateBll.GetInstence().Exist(x => x.CATE_ID == sCate_id) && id == 0)
{
return(CATE_ID.Label + "已存在！请重新输入！");
}
//var sMeno = StringHelper.Left(UNIT_MENO.Text, 40);
//if (UNIT_MENO.Text.Trim().Length > 40)
//{
// return UNIT_MENO.Label + "超长！";
//}
#endregion
#region 赋值
var model = new PROD_Cate(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.CATE_ID = CATE_ID.Text;
model.CATE_NAME = CATE_NAME.Text;
model.CATE_MEMO = CATE_MEMO.Text;
model.ENABLE = ConvertHelper.StringToByte(ENABLE.SelectedValue);
model.DEP_ID = DEP_ID.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 = false;
#endregion
////----------------------------------------------------------
////存储到数据库
PROD_CateBll.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(txtLoginName.Text.Trim()))
{
return(txtLoginName.Label + "不能为空！");
}
if (SHOPdll.SelectedText.Trim() == "请选择分店")
{
return(SHOPdll.Label + "不能为空！");
}
var sName = StringHelper.Left(txtLoginName.Text, 50);
if (ManagerBll.GetInstence().Exist(x => x.LoginName == sName && x.Id != id))
{
return(txtLoginName.Label + "已存在！请重新输入！");
}
if (string.IsNullOrEmpty(txtPwd.Text.Trim()))
{
return(txtPwd.Label + "不能为空！");
}
#endregion
#region 赋值
//读取指定部门资料
var model = new Manager(x => x.Id == id);
model.LoginName = txtLoginName.Text;
model.LoginPass = model.LoginPass == txtPwd.Text.Trim()?model.LoginPass: Encrypt.Md5(Encrypt.Md5(txtPwd.Text));//:model.LoginPass; model.LoginPass == null?
model.LoginTime = DateTime.Now;
model.LoginIp = "1::";
model.LoginCount = 1;
model.CreateTime = DateTime.Now;
model.UpdateTime = DateTime.Now;
int branch_id = ConvertHelper.Cint0(Brachddl.SelectedValue);
var model_b = BranchBll.GetInstence().GetModelForCache(x => x.Id == branch_id);
model.Branch_Id = model_b.Id;
model.Branch_Code = model_b.Code;
model.Branch_Name = model_b.Name;
model.IsMultiUser = ConvertHelper.StringToByte(rblIsMultiUser.SelectedValue.ToString());
model.IsWork = ConvertHelper.StringToByte(rblIsWork.SelectedValue);
model.IsEnable = ConvertHelper.StringToByte(rblIsEnable.SelectedValue);
var model_p = PositionBll.GetInstence().GetModelForCache(x => x.Id == ConvertHelper.Cint0(Positionddl.SelectedValue));
model.Position_Id = model_p.Id.ToString();
model.Position_Name = model_p.Name;
model.CName = txtCName.Text;
model.EName = txtEName.Text;
model.Sex = rblSex.SelectedValue.ToString();
model.PhotoImg = "";
model.Birthday = Birthday.SelectedDate.ToString();
model.NativePlace = txtNativePlace.Text;
model.NationalName = txtNationalName.Text;
model.Record = txtRecord.Text;
model.GraduateCollege = txtGraduateCollege.Text;
model.GraduateSpecialty = txtGraduateSpecialty.Text;
model.Tel = txtTel.Text;
model.Tel = txtMobile.Text;
model.Email = txtEmail.Text;
model.Qq = txtQq.Text;
model.Msn = "";
model.Address = txtAddress.Text;
model.Content = txtContent.Text;
model.Manager_Id = OnlineUsersBll.GetInstence().GetManagerId();
model.Manager_CName = OnlineUsersBll.GetInstence().GetManagerCName();
model.SHOP_ID = SHOPdll.SelectedValue;
model.SHOP_NAME1 = SHOPdll.SelectedText;
#endregion
//----------------------------------------------------------
//存储到数据库
ManagerBll.GetInstence().Save(this, model);
}
catch (Exception e)
{
result = "保存失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
}
return(result);
}
/// <summary>
/// Grid点击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid1_RowCommand(object sender, FineUI.GridCommandEventArgs e)
{
GridRow gr = Grid1.Rows[e.RowIndex];
//获取当前点击列的主键ID
object id = gr.DataKeys[0];
//因为要记录修改人，修改时间跟最后更新时间，所以将单字段更新换成多字段更新
switch (e.CommandName)
{
case "ENABLE":
try
{
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == OnlineUsersBll.GetInstence().GetUserHashKey());
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("ENABLE", ConvertHelper.StringToByte(e.CommandArgument));
dic.Add("MOD_DATETIME", ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")));
dic.Add("MOD_USER_ID", OlUser.Manager_LoginName);
dic.Add("LAST_UPDATE", ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")));
if (ConvertHelper.Cint0(id) > 0)
{
PROD_DEPBll.GetInstence().UpdateValue(this, ConvertHelper.Cint0(id), dic);
}
LoadData();
//PROD_KINDBll.GetInstence().Save(this, model);
}
catch (Exception err)
{
//出现异常，保存出错日志信息
CommonBll.WriteLog("保存失败", err);
}
//更新状态
//PROD_KINDBll.GetInstence().UpdateENABLE(this, ConvertHelper.Cint0(id), ConvertHelper.Cint0(e.CommandArgument));
//重新加载
//LoadData();
break;
case "ButtonEdit":
//打开编辑窗口
Window1.IFrameUrl = "ProdDepEdit.aspx?Id=" + id + "&" + MenuInfoBll.GetInstence().PageUrlEncryptStringNoKey(id + "");
Window1.Hidden = false;
break;
}
}
public void btnEditCon_Click(Object sender, EventArgs e)
{
try
{
//int Grid3RowIndex = ConvertHelper.Cint(Grid3Rowindex.Text);
string _CONTRACT_ID = tbxCONTRACT_ID.Text.ToString();
if (String.IsNullOrEmpty(_CONTRACT_ID))
{
FineUI.Alert.ShowInParent("未选择商品", FineUI.MessageBoxIcon.Information);
return;
}
FineUI.Grid Grid4 = Window3.FindControl("PanelGrid4").FindControl("Grid4") as FineUI.Grid;
int[] selections = Grid4.SelectedRowIndexArray;
if (selections.Length == 0)
{
FineUI.Alert.ShowInParent("请选择一行", FineUI.MessageBoxIcon.Information);
return;
}
foreach (int i in selections)
{
int _Id = ConvertHelper.Cint(Grid4.DataKeys[i][0].ToString());
if (_Id > 0)
{
JObject defaultObj = new JObject();
var model = new PRODUCT00(x => x.Id == _Id);
//暂时保留后期可能优化
string _UserHashKey = Session[OnlineUsersTable.UserHashKey].ToString();
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
DataSet dsCom = (DataSet)SPs.Get_CONTRACT01_PRODUCT01(_UserHashKey, model.PROD_ID).ExecuteDataSet();
if (dsCom.Tables.Count > 0)
{
if (dsCom.Tables[0].Rows.Count > 0)
{
defaultObj.Add("Id01", 0);
defaultObj.Add("CONTRACT_ID01", _CONTRACT_ID);
defaultObj.Add("PROD_ID01", model.PROD_ID);
defaultObj.Add("PROD_NAME01", model.PROD_NAME1);
defaultObj.Add("CONTRACT_PRICE01", dsCom.Tables[0].Rows[0]["COST"].ToString());
defaultObj.Add("CONTRACT_PRICE101", dsCom.Tables[0].Rows[0]["COST1"].ToString());
defaultObj.Add("CONTRACT_PRICE201", dsCom.Tables[0].Rows[0]["COST2"].ToString());
defaultObj.Add("USABLE01", true);
defaultObj.Add("Meno01", "");
defaultObj.Add("CRT_USER_ID01", OlUser.Manager_LoginName);
defaultObj.Add("CRT_DATETIME01", DateTime.Now.ToString());
defaultObj.Add("MOD_USER_ID01", OlUser.Manager_LoginName);
defaultObj.Add("MOD_DATETIME01", DateTime.Now.ToString());
Grid2.AddNewRecord(defaultObj, true);
}
else
{
FineUI.Alert.ShowInParent("添加失败", FineUI.MessageBoxIcon.Information);
}
}
else
{
FineUI.Alert.ShowInParent("添加失败", FineUI.MessageBoxIcon.Information);
}
}
}
}
catch (Exception err)
{
FineUI.Alert.ShowInParent("添加失败:" + err.Message, FineUI.MessageBoxIcon.Information);
}
}
public void ProcessRequest(HttpContext context)
{
//---------------------------------------------------
var m_r = new UploadFile();
int vid = 0, userId = 0;
const int userType = 1;
string key = "", msg = "", userName = "";
//---------------------------------------------------
bool isSwf = (RequestHelper.PostText("swf", 1) == "1");
if (isSwf)
{
vid = RequestHelper.PostInt0("vid");
key = RequestHelper.PostText("key", 20);
if (!StringHelper.IsRndKey(key))
{
key = "";
}
if (vid < 1 || key.Length < 10)
{
ShowMsg_Swf("缺少参数:key或sid");
return;
}
//---------------------------------------------------
#region 判断权限
userId = RequestHelper.PostInt0("uid");
if (userId < 1)
{
ShowMsg_Swf("缺少参数:uid");
return;
}
string uk = RequestHelper.PostText("uk", 32);
if (uk.Length < 10)
{
ShowMsg_Swf("缺少参数:uk");
return;
}
string userKey = OnlineUsersBll.GetInstence().GetMd5(ConvertHelper.Cint0(userId));
if (userKey != uk)
{
ShowMsg_Swf("还未登陆，权限不足！");
return;
}
userName = OnlineUsersBll.GetInstence().GetManagerCName(ConvertHelper.Cint0(userId));
#endregion
//---------------------------------------------------
msg = new UploadFileBll().Upload_Web(vid, key, userId, userName, m_r, "imgFile", userType, false, true);
//---------------------------------------------------
if (msg.Length > 0)
{
ShowMsg_Swf(msg);
}
else
{
//上传成功，输出结果
ShowMsg_Swf("", 0, ConvertHelper.Cint0(m_r.Id),
m_r.Name, m_r.Path, m_r.Src);
}
}
else
{
//---------------------------------------------------
bool isEditor = (RequestHelper.GetQueryString("act") == "edit");
vid = RequestHelper.GetInt0("vid");
key = RequestHelper.GetKeyChar("key", 20);
if (vid < 1 || key.Length < 10)
{
ShowMsg_Swf("缺少参数:key或sid");
return;
}
//---------------------------------------------------
#region 判断权限
if (SessionHelper.GetSession("UserHashKey") != null)
{
var uinfo = OnlineUsersBll.GetInstence().GetOnlineUsersModel();
userId = uinfo.Manager_Id;
userName = uinfo.Manager_CName;
}
else
{
msg = "还未登陆，权限不足！";
if (isEditor)//编辑器 (ke4)
{
ShowMsg_Editor(msg);
}
else
{
//RequestHelper.AlertUtf8(msg, 3, "");
FineUI.Alert.Show(msg, "提示", MessageBoxIcon.Warning, "history.back();");
}
return;
}
#endregion
//---------------------------------------------------
msg = new UploadFileBll().Upload_Web(vid, key, userId, userName, m_r, "imgFile", userType, isEditor, false);
if (msg.Length > 0)
{
if (isEditor)//编辑器 (ke4)
{
ShowMsg_Editor(msg);
}
else
{
//RequestHelper.AlertUtf8(msg, 3, "");
FineUI.Alert.Show(msg, "提示", MessageBoxIcon.Warning, "history.back();");
}
}
else
{
//上传成功，输出结果
if (isEditor)//编辑器 (ke4)
{
ShowMsg_Editor("上传成功", m_r.Path);
}
else
{
//RequestHelper.AlertUtf8("window.parent.OnUploadCompleted('" + m_r.Name + "','" + m_r.Path + "'," + m_r.Id.ToString() + ",'" + m_r.Src + "');", 7, "");
FineUI.Alert.Show("上传失败", "提示", MessageBoxIcon.Warning, "window.parent.OnUploadCompleted('" + m_r.Name + "','" + m_r.Path + "'," + m_r.Id.ToString() + ",'" + m_r.Src + "');");
}
}
}
Write("系统暂时禁止上传文件！");
return;
}
/// <summary>
/// 数据保存
/// </summary>
/// <returns></returns>
public override string Save()
{
string result = string.Empty;
string order_id = hidId.Text;
try
{
#region 数据验证
// FineUI.DropDownList dddlPROD_NAME1 = Window2.FindControl("ddlPROD_NAME1") as FineUI.DropDownList;
if (ddlPROD_NAME1.SelectedText == "请选择")
{
return(ddlPROD_NAME1.Label + "请选择！");
}
// FineUI.TextBox ttxtPROD_ID = Window2.FindControl("txtPROD_ID") as FineUI.TextBox;
if (string.IsNullOrEmpty(txtPROD_ID.Text.Trim()))
{
return(txtPROD_ID.Label + "不能为空！");
}
// FineUI.TextBox ttxtPROD_UNIT = Window2.FindControl("txtPROD_UNIT") as FineUI.TextBox;
if (string.IsNullOrEmpty(txtPROD_UNIT.Text.Trim()))
{
return(txtPROD_UNIT.Label + "不能为空！");
}
// FineUI.TextBox ttxtTotal = Window2.FindControl("txtTotal") as FineUI.TextBox;
if (string.IsNullOrEmpty(txtTotal.Text.Trim()))
{
return(txtTotal.Label + "不能为空！");
}
// FineUI.TextBox ttxtU_Cost = Window2.FindControl("txtU_Cost") as FineUI.TextBox;
if (string.IsNullOrEmpty(txtU_Cost.Text.Trim()))
{
return(txtU_Cost.Label + "不能为空！");
}
// FineUI.TextBox ttxtOrder_QUAN = Window2.FindControl("txtOrder_QUAN") as FineUI.TextBox;
if (string.IsNullOrEmpty(txtOrder_QUAN.Text.Trim()))
{
return(txtOrder_QUAN.Label + "不能为空！");
}
// FineUI.TextBox ttxtON_QUAN = Window2.FindControl("txtON_QUAN") as FineUI.TextBox;
if (string.IsNullOrEmpty(txtON_QUAN.Text.Trim()) || txtON_QUAN.Text == "0")
{
return(txtON_QUAN.Label + "不能为空或者0！");
}
// FineUI.TextBox ttxtMemo = Window2.FindControl("txtMemo") as FineUI.TextBox;
#endregion
#region 赋值
int id = ConvertHelper.Cint0(SNo.Text);
//读取资料
var model_0 = new ORDER00(x => x.ORDER_ID == order_id);
//序号
conditionList = new List <ConditionFun.SqlqueryCondition>();
conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, ORDER01Table.ORDER_ID, Comparison.Equals, order_id, false, false));
if (IsEdit)
{
id = ConvertHelper.Cint0(GridViewHelper.GetSelectedKey(Grid2, true));
}
else
{
id = ORDER01Bll.GetInstence().GetRecordCount(conditionList) + 1;
}
var model = new ORDER01(x => x.ORDER_ID == order_id && x.SNo == id);
model.SHOP_ID = model_0.SHOP_ID;//分店编号
model.SNo = id;
model.PROD_ID = txtPROD_ID.Text.Trim();
model.ORDER_ID = order_id;
model.ON_QUAN = ConvertHelper.StringToDecimal(txtON_QUAN.Text.Trim());
model.QUAN1 = ConvertHelper.StringToDecimal(txtTotal.Text);
model.QUAN2 = 0;
model.COST_PRICE = 0;
model.STD_UNIT = txtPROD_UNIT.Text;
model.STD_CONVERT = 0;
model.QUANTITY = model.STD_QUAN * model.STD_CONVERT;
model.STD_QUAN = ConvertHelper.StringToDecimal(txtON_QUAN.Text);
model.STD_PRICE = ConvertHelper.StringToDecimal(txtU_Cost.Text);
model.Memo = txtMemo.Text;
model.CRT_DATETIME = DateTime.Now;
model.CRT_USER_ID = OnlineUsersBll.GetInstence().GetManagerCName();
model.MOD_DATETIME = DateTime.Now;
model.MOD_USER_ID = OnlineUsersBll.GetInstence().GetManagerCName();
#endregion
//----------------------------------------------------------
//存储到数据库
ORDER01Bll.GetInstence().Save(this, model);
// Window2.Hidden = true;
BindGrid2();
MessageBox.Show(this, "保存成功!");
// PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
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 数据验证
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 + "不能为空！");
}
var sOrder_UNIT = Order_UNIT.SelectedValue;
if (string.IsNullOrEmpty(sOrder_UNIT) || sOrder_UNIT == "0")
{
return(Order_UNIT.Label + "不能为空！");
}
var sOrder_Quan = Order_QUAN.Text;
if (string.IsNullOrEmpty(sOrder_Quan) || sOrder_Quan == "0")
{
return(Order_QUAN.Label + "不能为空！");
}
if (!ConvertHelper.IsInt(sOrder_Quan))
{
return(Order_QUAN.Label + "必须为整数！");
}
var sPurchase_UNIT = Purchase_UNIT.SelectedValue;
if (string.IsNullOrEmpty(sPurchase_UNIT) || sPurchase_UNIT == "0")
{
return(Purchase_UNIT.Label + "不能为空！");
}
var sPurchase_QUAN = Purchase_QUAN.Text;
if (string.IsNullOrEmpty(sPurchase_QUAN))
{
return(Purchase_QUAN.Label + "不能为空！");
}
if (!ConvertHelper.IsInt(sPurchase_QUAN))
{
return(Purchase_QUAN.Label + "必须为整数！");
}
var sSAFE_QUAN = SAFE_QUAN.Text;
if (string.IsNullOrEmpty(sSAFE_QUAN))
{
return(SAFE_QUAN.Label + "不能为空！");
}
if (!ConvertHelper.IsInt(sSAFE_QUAN))
{
return(SAFE_QUAN.Label + "必须为整数！");
}
sPROD_ID = StringHelper.Left(sPROD_ID, 50);
if (PRODUCT00Bll.GetInstence().Exist(x => x.PROD_ID == sPROD_ID) && id == 0)
{
return(PROD_ID.Label + "已存在！请重新输入！");
}
//var sMeno = StringHelper.Left(UNIT_MENO.Text, 40);
//if (UNIT_MENO.Text.Trim().Length > 40)
//{
// return UNIT_MENO.Label + "超长！";
//}
#endregion
#region 赋值
var model = new PRODUCT00(x => x.Id == id);
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
model.PROD_ID = sPROD_ID;
model.PROD_NAME1 = PROD_NAME1.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
////----------------------------------------------------------
////存储到数据库
PRODUCT00Bll.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(txtLoginName.Text.Trim()))
{
return(txtLoginName.Label + "不能为空！");
}
var logName = StringHelper.Left(txtLoginName.Text, 20);
if (Manager.Exists(x => x.LoginName == logName && x.Id != id))
{
return(txtLoginName.Label + "已存在！请重新输入！");
}
//新增用户时，密码不能为空
if (id == 0 && string.IsNullOrEmpty(txtLoginPass.Text.Trim()))
{
return("密码不能为空！");
}
//密码长度不能短于6位
if (!string.IsNullOrEmpty(txtLoginPass.Text.Trim()) && txtLoginPass.Text.Trim().Length < 6)
{
return("密码长度必须6位以上，请重新输入！");
}
if (!txtLoginPass.Text.Equals(txtLoginPassaAgin.Text))
{
return("两次输入的密码不一样，请重新输入！");
}
if (string.IsNullOrEmpty(txtCName.Text.Trim()))
{
return(txtCName.Label + "不能为空！");
}
//所属部门
if (ConvertHelper.Cint0(ddlBranch_Id.SelectedValue) < 1)
{
return(ddlBranch_Id.Label + "为必选项，请选择！");
}
//所属职位
if (string.IsNullOrEmpty(hidPositionId.Text))
{
return(txtPosition.Label + "为必选项，请选择！");
}
#endregion
#region 赋值
//获取实体
var model = new Manager(x => x.Id == id);
model.LoginName = logName;
//如果是添加管理员
if (id == 0)
{
model.CreateTime = DateTime.Now;
model.UpdateTime = DateTime.Now;
model.Manager_Id = OnlineUsersBll.GetInstence().GetManagerId();
model.Manager_CName = OnlineUsersBll.GetInstence().GetManagerCName();
model.LoginPass = Encrypt.Md5(Encrypt.Md5(txtLoginPass.Text));
model.IsWork = 1;
}
else
{
//修改时间与管理员
model.UpdateTime = DateTime.Now;
model.Manager_Id = OnlineUsersBll.GetInstence().GetManagerId();
model.Manager_CName = OnlineUsersBll.GetInstence().GetManagerCName();
//修改用户时，填写了密码，则更新密码
if (txtLoginPass.Text.Trim().Length >= 6)
{
model.LoginPass = Encrypt.Md5(Encrypt.Md5(txtLoginPass.Text));
}
}
model.Branch_Id = ConvertHelper.Cint0(ddlBranch_Id.SelectedValue);
var branch = BranchBll.GetInstence().GetModelForCache(x => x.Id == model.Branch_Id);
if (branch != null)
{
model.Branch_Code = branch.Code;
model.Branch_Name = branch.Name;
}
model.Position_Id = StringHelper.Left(hidPositionId.Text, 100);
model.Position_Name = StringHelper.Left(txtPosition.Text, 500);
model.CName = StringHelper.Left(txtCName.Text, 20);
model.EName = StringHelper.Left(txtEName.Text, 50);
model.Sex = StringHelper.Left(rblSex.SelectedValue, 4);
model.Birthday = StringHelper.Left(dpBirthday.Text, 20);
model.Record = StringHelper.Left(txtRecord.Text, 25);
model.GraduateCollege = StringHelper.Left(txtGraduateCollege.Text, 30);
model.GraduateSpecialty = StringHelper.Left(txtGraduateSpecialty.Text, 50);
model.Tel = StringHelper.Left(txtTel.Text, 30);
model.Mobile = StringHelper.Left(txtMobile.Text, 30);
model.Email = StringHelper.Left(txtEmail.Text, 50);
model.Qq = StringHelper.Left(txtQq.Text, 30);
model.Msn = StringHelper.Left(txtMsn.Text, 30);
model.Address = StringHelper.Left(txtAddress.Text, 100);
model.IsEnable = ConvertHelper.Ctinyint(rblIsEnable.SelectedValue);
model.IsMultiUser = ConvertHelper.Ctinyint(rblIsMultiUser.SelectedValue);
model.Content = StringHelper.Left(txtContent.Text, 0);
model.NationalName = StringHelper.Left(txtNationalName.Text, 50);
model.NativePlace = StringHelper.Left(txtNativePlace.Text, 100);
#region 图片
if (this.fuSinger_AvatarPath.HasFile && this.fuSinger_AvatarPath.FileName.Length > 3)
{
int vid = 1; //1 管理员头像(头像图片)
//---------------------------------------------------
var upload = new UploadFile();
result = new UploadFileBll().Upload_AspNet(this.fuSinger_AvatarPath.PostedFile, vid, RndKey, OnlineUsersBll.GetInstence().GetManagerId(), OnlineUsersBll.GetInstence().GetManagerCName(), upload);
this.fuSinger_AvatarPath.Dispose();
//---------------------------------------------------
if (result.Length == 0)//上传成功
{
model.PhotoImg = upload.Path;
}
else
{
CommonBll.WriteLog("上传管理员头像图片未成功：" + result, null);//收集异常信息
return("上传管理员头像图片未成功！" + result);
}
}
//如果是修改，检查用户是否重新上传过封面图片，如果是删除旧的图片
if (model.Id > 0)
{
UploadFileBll.GetInstence().Upload_DiffFile(ManagerTable.Id, ManagerTable.PhotoImg, ManagerTable.TableName, model.Id, model.PhotoImg);
//同步UploadFile上传表
UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, ManagerTable.TableName, model.Id);
}
#endregion
#endregion
//----------------------------------------------------------
//存储到数据库
ManagerBll.GetInstence().Save(this, model);
#region 步更新上传图片表绑定Id
if (id == 0)
{
//同步UploadFile上传表记录，绑定刚刚上传成功的文件Id为当前记录Id
UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, ManagerTable.TableName, model.Id);
}
#endregion
}
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(txtName.Text.Trim()))
{
return(txtName.Label + "不能为空！");
}
var sName = StringHelper.Left(txtName.Text, 50);
if (AdvertisingPositionBll.GetInstence().Exist(x => x.Name == sName && x.Id != id))
{
return(txtName.Label + "已存在！请重新输入！");
}
if (string.IsNullOrEmpty(txtKey.Text.Trim()))
{
return(txtKey.Label + "不能为空！");
}
var sKeyword = StringHelper.Left(txtKey.Text, 50);
if (AdvertisingPositionBll.GetInstence().Exist(x => x.Keyword == sKeyword && x.Id != id))
{
return(txtKey.Label + "已存在！请重新输入！");
}
#endregion
#region 赋值
//定义是否更新其他关联表变量
bool isUpdate = false;
//读取当前地址信息
var model = new AdvertisingPosition(x => x.Id == id);
//判断是否更新关联表
if (model.Id > 0 && sName != model.Name)
{
isUpdate = true;
}
//设置名称
model.Name = StringHelper.Left(txtName.Text, 50);
//KEY
model.Keyword = StringHelper.Left(txtKey.Text, 50);
//对应的父类id
model.ParentId = ConvertHelper.Cint0(txtParent.Text);
//由于限制了编辑时不能修改父节点，所以这里只对新建记录时处理
if (id == 0)
{
//设定当前的深度与设定当前的层数级
if (model.ParentId == 0)
{
//设定当前的层数级
model.Depth = 0;
}
else
{
//设定当前的层数
model.Depth = ConvertHelper.Cint0(AdvertisingPositionBll.GetInstence().GetFieldValue(ConvertHelper.Cint0(ddlParentId.SelectedValue), AdvertisingPositionTable.Depth)) + 1;
}
//限制分类层数只能为2层
if (model.Depth > 2)
{
return("广告位置只能创建2层分类！");
}
}
//设置排序
if (txtSort.Text == "0")
{
model.Sort = AdvertisingPositionBll.GetInstence().GetSortMax(model.ParentId) + 1;
}
else
{
model.Sort = ConvertHelper.Cint0(txtSort.Text);
}
//设定当前项是否显示
model.IsDisplay = ConvertHelper.StringToByte(rblIsDisplay.SelectedValue);
//广告宽与高
model.Width = ConvertHelper.Cint0(txtWidth.Text);
model.Height = ConvertHelper.Cint0(txtHeight.Text);
//添加最后修改人员
model.Manager_Id = OnlineUsersBll.GetInstence().GetManagerId();
model.Manager_CName = OnlineUsersBll.GetInstence().GetManagerCName();
model.AddDate = DateTime.Now;
#endregion
#region 图片
//上传广告位置图
if (this.MapImg.HasFile && this.MapImg.FileName.Length > 3)
{
int vid = 5; //5 广告位置图
//---------------------------------------------------
var upload = new UploadFile();
result = new UploadFileBll().Upload_AspNet(this.MapImg.PostedFile, vid, RndKey, OnlineUsersBll.GetInstence().GetManagerId(), OnlineUsersBll.GetInstence().GetManagerCName(), upload);
this.MapImg.Dispose();
//---------------------------------------------------
if (result.Length == 0)//上传成功
{
model.MapImg = upload.Path;
}
else
{
CommonBll.WriteLog("上传出错：" + result, null);//收集异常信息
return("上传出错！" + result);
}
}
//如果是修改，检查用户是否重新上传过新图片，如果是删除旧的图片
if (model.Id > 0)
{
UploadFileBll.GetInstence().Upload_DiffFile(AdvertisingPositionTable.Id, AdvertisingPositionTable.MapImg, AdvertisingPositionTable.TableName, model.Id, model.MapImg);
//同步UploadFile上传表
UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, AdvertisingPositionTable.TableName, model.Id);
}
//——————————————————————————————————————————————————————————————————————
//上传广告默认图
if (this.PicImg.HasFile && this.PicImg.FileName.Length > 3)
{
int vid = 6; //6 广告默认图
//---------------------------------------------------
var upload = new UploadFile();
result = new UploadFileBll().Upload_AspNet(this.PicImg.PostedFile, vid, RndKey, OnlineUsersBll.GetInstence().GetManagerId(), OnlineUsersBll.GetInstence().GetManagerCName(), upload);
this.PicImg.Dispose();
//---------------------------------------------------
if (result.Length == 0)//上传成功
{
model.PicImg = upload.Path;
}
else
{
CommonBll.WriteLog("上传出错：" + result, null);//收集异常信息
return("上传出错！" + result);
}
}
//如果是修改，检查用户是否重新上传过默认图片，如果是删除旧的图片
if (model.Id > 0)
{
UploadFileBll.GetInstence().Upload_DiffFile(AdvertisingPositionTable.Id, AdvertisingPositionTable.PicImg, AdvertisingPositionTable.TableName, model.Id, model.PicImg);
//同步UploadFile上传表
UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, AdvertisingPositionTable.TableName, model.Id);
}
#endregion
//----------------------------------------------------------
//存储到数据库
AdvertisingPositionBll.GetInstence().Save(this, model);
#region 步更新上传图片表绑定Id
if (id == 0)
{
//同步UploadFile上传表记录，绑定刚刚上传成功的文件Id为当前记录Id
UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, AdvertisingPositionTable.TableName, model.Id);
}
#endregion
//如果本次修改改变了相关名称，则同步更新其他关联表的对应名称
if (isUpdate)
{
AdvertisementBll.GetInstence().UpdateValue_For_AdvertisingPosition_Id(this, model.Id, AdvertisementTable.AdvertisingPosition_Name, model.Name);
}
}
catch (Exception e)
{
result = "保存失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
}
return(result);
}
/////
/////取消
//public override void Cancel()
//{
//}
#region 保存
/// <summary>
/// 数据保存
/// </summary>
/// <returns></returns>
public override string Save()
{
string result = string.Empty;
int id = ConvertHelper.Cint0(hidId.Text);
try
{
#region 数据验证
if (string.IsNullOrEmpty(txtAREA_NAME.Text.Trim()))
{
return(txtAREA_NAME.Label + "不能为空！");
}
if (string.IsNullOrEmpty(txtAREA_ID.Text.Trim()))
{
return(txtAREA_ID.Label + "不能为空！");
}
int area_id = ConvertHelper.Cint0(txtAREA_ID.Text.Trim());
Expression <Func <DataAccess.Model.GROUPAREA, bool> > list = null;
list = x => x.AREA_ID == area_id;
if (GROUPAREABll.GetInstence().Exist(list))
{
return(txtAREA_ID.Label + "区域ID不能重复！");
}
//var sUrl = StringHelper.Left(txtUrl.Text, 400);
//if (BranchBll.GetInstence().Exist(x => x.Url == sUrl && x.Id != id))
//{
// return txtUrl.Label + "已存在！请重新输入！";
//}
#endregion
int userId = OnlineUsersBll.GetInstence().GetManagerId();
#region 赋值
//读取资料
var model = new GROUPAREA(x => x.Id == id);
model.AREA_ID = ConvertHelper.Cint0(txtAREA_ID.Text);
model.AREA_NAME = txtAREA_NAME.Text;
model.AREA_ADD = txtAREA_ADD.Text;
model.AREA_TEL = txtAREA_TEL.Text;
model.AREA_EMAIL = txtAREA_EMAIL.Text;
model.AREA_CONTECT = txtAREA_CONTECT.Text;
model.AREA_MEMO = txtAREA_MEMO.Text;
model.AREA_STATUS = ConvertHelper.StringToByte(ddlAREA_STATUS.SelectedValue);
model.CRT_DATETIME = DateTime.Now.ToString();
model.CRT_USER_ID = userId.ToString();
model.MOD_DATETIME = DateTime.Now;
model.MOD_USER_ID = userId.ToString();
model.LAST_UPDATE = DateTime.Now;
model.STATUS = 0;
#endregion
//----------------------------------------------------------
//存储到数据库
GROUPAREABll.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(txtName.Text.Trim()))
{
return(txtName.Label + "不能为空！");
}
var sName = StringHelper.Left(txtName.Text, 20);
if (UploadConfigBll.GetInstence().Exist(x => x.Name == sName && x.Id != id))
{
return(txtName.Label + "已存在！请重新输入！");
}
if (string.IsNullOrEmpty(txtJoinName.Text.Trim()))
{
return(txtJoinName.Label + "不能为空！");
}
if (ddlUploadTypeId.SelectedValue == "0")
{
return(ddlUploadTypeId.Label + "为必选项，请选择后再保存！");
}
if (string.IsNullOrEmpty(txtPicSize.Text.Trim()))
{
return(txtPicSize.Label + "不能为空！");
}
if (string.IsNullOrEmpty(txtFileSize.Text.Trim()))
{
return(txtFileSize.Label + "不能为空！");
}
if (string.IsNullOrEmpty(txtSaveDir.Text.Trim()))
{
return(txtSaveDir.Label + "不能为空！");
}
#endregion
#region 赋值
//获取实体
var model = new UploadConfig(x => x.Id == id);
model.Name = sName;
model.JoinName = StringHelper.Left(txtJoinName.Text, 30);
model.UserType = (byte)ConvertHelper.Cint1(rblUserType.SelectedValue);
//读取上传类型
model.UploadType_Id = ConvertHelper.Cint0(ddlUploadTypeId.SelectedValue);
var uploadTypeModel = UploadTypeBll.GetInstence().GetModelForCache(model.UploadType_Id);
if (uploadTypeModel != null)
{
model.UploadType_Name = uploadTypeModel.Name;
model.UploadType_TypeKey = uploadTypeModel.TypeKey;
}
//上传限制
model.PicSize = ConvertHelper.Cint0(txtPicSize.Text);
model.FileSize = ConvertHelper.Cint0(txtFileSize.Text);
model.SaveDir = StringHelper.Left(txtSaveDir.Text, 50);
model.IsPost = ConvertHelper.Ctinyint(rblIsPost.SelectedValue);
model.IsEditor = ConvertHelper.Ctinyint(rblIsEditor.SelectedValue);
model.IsSwf = ConvertHelper.Ctinyint(rblIsSwf.SelectedValue);
model.IsChkSrcPost = ConvertHelper.Ctinyint(brlIsChkSrcPost.SelectedValue);
//按比例生成
model.IsFixPic = ConvertHelper.Ctinyint(rblIsFixPic.SelectedValue);
model.CutType = ConvertHelper.Cint0(ddlCutType.SelectedValue);
model.PicWidth = ConvertHelper.Cint0(txtPicWidth.Text);
model.PicHeight = ConvertHelper.Cint0(txtPicHeight.Text);
model.PicQuality = ConvertHelper.Cint0(txtPicQuality.Text);
//大图
model.IsBigPic = ConvertHelper.Ctinyint(rblIsBigPic.SelectedValue);
model.BigWidth = ConvertHelper.Cint0(txtBigWidth.Text);
model.BigHeight = ConvertHelper.Cint0(txtBigHeight.Text);
model.BigQuality = ConvertHelper.Cint0(txtBigQuality.Text);
//中图
model.IsMidPic = ConvertHelper.Ctinyint(rblIsMidPic.SelectedValue);
model.MidWidth = ConvertHelper.Cint0(txtMidWidth.Text);
model.MidWidth = ConvertHelper.Cint0(txtMidWidth.Text);
model.MidHeight = ConvertHelper.Cint0(txtMidHeight.Text);
//小图
model.IsMinPic = ConvertHelper.Ctinyint(rblIsMinPic.SelectedValue);
model.MinWidth = ConvertHelper.Cint0(txtMinWidth.Text);
model.MinWidth = ConvertHelper.Cint0(txtMinWidth.Text);
model.MinHeight = ConvertHelper.Cint0(txtMinHeight.Text);
//推荐图
model.IsHotPic = ConvertHelper.Ctinyint(rblIsHotPic.SelectedValue);
model.HotWidth = ConvertHelper.Cint0(txtHotWidth.Text);
model.HotWidth = ConvertHelper.Cint0(txtHotWidth.Text);
model.HotHeight = ConvertHelper.Cint0(txtHotHeight.Text);
//加水印
model.IsWaterPic = ConvertHelper.Ctinyint(rblIsWaterPic.SelectedValue);
//修改时间与管理员
model.UpdateDate = DateTime.Now;
model.Manager_Id = OnlineUsersBll.GetInstence().GetManagerId();
model.Manager_CName = OnlineUsersBll.GetInstence().GetManagerCName();
#endregion
//----------------------------------------------------------
//存储到数据库
UploadConfigBll.GetInstence().Save(this, model);
}
catch (Exception e)
{
result = "保存失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
}
return(result);
}
/// <summary>
/// 核准按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void BtnPur00_Approval(Object sender, EventArgs e)
{
string Pur00_ID = tbxPurchase_ID.Text.ToString();
var model = Purchase00.SingleOrDefault(x => x.Purchase_ID == Pur00_ID);
if (model == null)
{
FineUI.Alert.ShowInParent("订单单号不存在", FineUI.MessageBoxIcon.Information);
return;
}
if (model.STATUS == 1)
{
DataTable dsCom = (DataTable)SPs.Get_MAX_Inventory_DATE().ExecuteDataTable();
DateTime dtInput = DateTime.Parse(dsCom.Rows[0]["INPUT_DATE"].ToString());
if (model.INPUT_DATE.CompareTo(dtInput) <= 0)
{
FineUI.Alert.ShowInParent("单据小于盘点日期，不允许盘点。盘点日期为:" + dsCom.Rows[0]["INPUT_DATE"].ToString() + "", FineUI.MessageBoxIcon.Information);
return;
}
}
//1 = 存档 2 = 核准 3 = 作废 4 = 已引入(供应商进货)
switch (model.STATUS)
{
case 1: model.STATUS = 2; break;
case 2: model.STATUS = 1; break;
case 3: FineUI.Alert.ShowInParent("订单已作废，无法进行核准", FineUI.MessageBoxIcon.Information); return;
case 4: FineUI.Alert.ShowInParent("订单已引入，无法进行核准", FineUI.MessageBoxIcon.Information); return;
default: FineUI.Alert.ShowInParent("订单状态有误，无法核准", FineUI.MessageBoxIcon.Information); return;
}
ddlStatus.SelectedValue = model.STATUS.ToString();
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
model.MOD_DATETIME = DateTime.Now;
model.LAST_UPDATE = DateTime.Now;
model.MOD_USER_ID = OlUser.Manager_LoginName;
string result = "";
try
{
Purchase00Bll.GetInstence().Save(this, model);
}
catch (Exception err)
{
result = err.Message;
}
//BtnPur01_Edit(sender, e);
//string result = Pur01_Edit();
if (String.IsNullOrEmpty(result))
{
result = Pur_Edit();
}
LoadPur();
LoadDataPur01();
FineUI.Alert.ShowInParent(result, FineUI.MessageBoxIcon.Error);
//FineUI.Alert.ShowInParent("核准成功", FineUI.MessageBoxIcon.Information);
}
/// <summary>
/// 子表保存
/// </summary>
/// <returns></returns>
public string DetailEdit()
{
JArray jarr = Grid2.GetMergedData();
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
string result = "";
int n = 0;
for (int i = 0; i < jarr.Count; i++)
{
try
{
var model2 = new PREPARE01();
//string str = jarr[i]["status"].ToString();
if (jarr[i]["status"].ToString().Equals("modified"))
{
model2.SetIsNew(false);
}
else if (jarr[i]["status"].ToString().Equals("unchanged"))
{
continue;
}
else
{
model2.SetIsNew(true);
}
model2.SHOP_ID = jarr[i]["values"]["SHOP_ID01"].ToString();
if (!String.IsNullOrEmpty(jarr[i]["values"]["PREPARE_ID01"].ToString()))
{
model2.PREPARE_ID = jarr[i]["values"]["PREPARE_ID01"].ToString();
}
else
{
return("保存失败");
}
model2.SNo = ConvertHelper.Cint(jarr[i]["values"]["SNo01"].ToString());
model2.PROD_ID = jarr[i]["values"]["PROD_ID01"].ToString();
model2.QUANTITY = ConvertHelper.StringToDecimal(jarr[i]["values"]["QUANTITY01"].ToString());
model2.STD_UNIT = jarr[i]["values"]["STD_UNIT01"].ToString();
model2.STD_CONVERT = ConvertHelper.Cint(jarr[i]["values"]["STD_CONVERT01"].ToString());
model2.STD_QUAN = ConvertHelper.StringToDecimal(jarr[i]["values"]["STD_QUAN01"].ToString());
model2.STD_PRICE = ConvertHelper.StringToDecimal(jarr[i]["values"]["STD_PRICE01"].ToString());
model2.COST = ConvertHelper.StringToDecimal(jarr[i]["values"]["COST01"].ToString());
model2.QUAN1 = 0;
model2.QUAN2 = 0;
model2.sProd_ID = jarr[i]["values"]["sProd_ID01"].ToString();
model2.BAT_NO = ConvertHelper.Cint(jarr[i]["values"]["BAT_NO01"].ToString());
model2.IsScales = ConvertHelper.StringToByte(jarr[i]["values"]["IsScales01"].ToString());
model2.IsFlag = ConvertHelper.StringToByte(jarr[i]["values"]["IsFlag01"].ToString());
model2.Scales_User = jarr[i]["values"]["Scales_User01"].ToString();
model2.Scale_Date = DateTime.Now;
model2.MEMO = jarr[i]["values"]["MEMO01"].ToString();
PREPARE01Bll.GetInstence().Save(this, model2);
}
catch (Exception err)
{
n++;
result = "明细保存失败" + n + "条";
}
}
return(result);
}
/// <summary>
/// 采购主表更新
/// </summary>
/// <returns></returns>
public string Pur01_Edit()
{
#region 校验数据
string _SHOP_ID = ddlSHOP_NAME.SelectedValue;
if (String.IsNullOrEmpty(_SHOP_ID))
{
//FineUI.Alert.ShowInParent("分店编码不允许为空", FineUI.MessageBoxIcon.Error);
return("分店编码不允许为空");
}
//string _EXPECT_DATE = dpAPP_DATETIME.SelectedDate.ToString();
//if (dpAPP_DATETIME.SelectedDate < DateTime.Now)
//{
// //FineUI.Alert.ShowInParent("期望日期不能小于当前时间", FineUI.MessageBoxIcon.Error);
// return "期望日期不能小于当前时间";
//}
string _SUP_ID = ddlSHOP_NAME.SelectedValue;
if (String.IsNullOrEmpty(_SUP_ID))
{
//FineUI.Alert.ShowInParent("厂商不能为空", FineUI.MessageBoxIcon.Error);
return("厂商不能为空");
}
#endregion
string _Pur00_id = tbxPurchase_ID.Text;
var model = Purchase00.SingleOrDefault(x => x.Purchase_ID == _Pur00_id);
if (model == null)
{
//FineUI.Alert.ShowInParent("采购单号已存在不允许添加", FineUI.MessageBoxIcon.Error);
return("该订单不存在");
}
else
{
try
{
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
//model = new Purchase00();
model.SHOP_ID = _SHOP_ID;
model.STATUS = 1;
model.INPUT_DATE = DateTime.Now;
model.EXPECT_DATE = ConvertHelper.StringToDatetime(dpEXPECT_DATE.SelectedDate.ToString());
model.SUP_ID = ddlSUP_NAME.SelectedValue.ToString();
model.PAY_STATUS = ConvertHelper.Cint(ddlPAY_STATUS.SelectedValue);
model.USER_ID = OlUser.Manager_LoginName;
model.APP_USER = "";
model.APP_DATETIME = ConvertHelper.StringToDatetime("1900-01-01 00:00:00");
model.TOT_AMOUNT = 0;
model.TOT_TAX = ConvertHelper.StringToDecimal(numTOT_QTY.Text);
model.TOT_QTY = 0;
model.PRE_PAY = 0;
model.PRE_PAY_ID = "";
model.EXPORTED = 0;
model.EXPORTED_ID = "";
model.LOCKED = 0;
model.CRT_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToLongDateString());
model.CRT_USER_ID = OlUser.Manager_LoginName;
model.MOD_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToLongDateString());
model.MOD_USER_ID = OlUser.Manager_LoginName;
model.LAST_UPDATE = ConvertHelper.StringToDatetime(DateTime.Now.ToLongDateString());
model.SetIsNew(false);
Purchase00Bll.GetInstence().Save(this, model);
LoackPur01();
//FineUI.Alert.ShowInParent("保存成功", FineUI.MessageBoxIcon.Error);
return("");
}
catch (Exception err)
{
return(err.Message);
}
}
}
/// <summary>
/// 数据保存
/// </summary>
/// <returns></returns>
public override string Save()
{
string result = string.Empty;
string order_id = hidId.Text;
try
{
#region 数据验证
if (ddlPROD_NAME1.Text.Trim() == "请选择商品名称")
{
return(ddlPROD_NAME1.Label + "请选择商品名称！");
}
if (string.IsNullOrEmpty(txtPROD_ID.Text.Trim()))
{
return(txtPROD_ID.Label + "不能为空！");
}
if (string.IsNullOrEmpty(txtPROD_UNIT.Text.Trim()))
{
return(txtPROD_UNIT.Label + "不能为空！");
}
if (string.IsNullOrEmpty(txtU_Cost.Text.Trim()))
{
return(txtU_Cost.Label + "不能为空！");
}
if (string.IsNullOrEmpty(txtOrder_QUAN.Text.Trim()))
{
return(txtOrder_QUAN.Label + "不能为空！");
}
#endregion
#region 赋值
int id = ConvertHelper.Cint0(RequestHelper.GetQueryString("Id"));
//读取资料
var model_0 = new ORDER00(x => x.ORDER_ID == order_id);
var model = new ORDER01(x => x.ORDER_ID == order_id && x.Id == id);
model.SHOP_ID = model_0.SHOP_ID;//分店编号
//序号
conditionList = new List <ConditionFun.SqlqueryCondition>();
conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, ORDER01Table.ORDER_ID, Comparison.Equals, order_id, false, false));
model.SNo = ORDER01Bll.GetInstence().GetRecordCount(conditionList) + 1;
model.PROD_ID = txtPROD_ID.Text.Trim();
model.ORDER_ID = order_id;
model.ON_QUAN = ConvertHelper.StringToDecimal(txtON_QUAN.Text.Trim());
model.QUAN1 = 0;
model.QUAN2 = 0;
model.COST_PRICE = 0;
model.STD_UNIT = txtPROD_UNIT.Text;
model.STD_CONVERT = 0;
model.QUANTITY = model.STD_QUAN * model.STD_CONVERT;
model.STD_QUAN = ConvertHelper.StringToDecimal(txtON_QUAN.Text);
model.STD_PRICE = ConvertHelper.StringToDecimal(txtU_Cost.Text);
model.Memo = txtMemo.Text;
model.CRT_DATETIME = DateTime.Now;
model.CRT_USER_ID = OnlineUsersBll.GetInstence().GetManagerCName();
model.MOD_DATETIME = DateTime.Now;
model.MOD_USER_ID = OnlineUsersBll.GetInstence().GetManagerCName();
#endregion
//----------------------------------------------------------
//存储到数据库
ORDER01Bll.GetInstence().Save(this, model);
// PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
catch (Exception e)
{
result = "保存失败！";
//出现异常，保存出错日志信息
// CommonBll.WriteLog(result, e);
}
return(result);
}
/// <summary>
/// Contract00保存与更新
/// </summary>
/// <param name="isNew"></param>
/// <returns></returns>
public string Contract00Edit(bool isNew)
{
string result = "";
result = CheckContract00();
if (!String.IsNullOrEmpty(result))
{
return(result);
}
try
{
CONTRACT00 model = null;
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
if (isNew == true)
{
model = new CONTRACT00();
model.SetIsNew(true);
model.CONTRACT_ID = tbxCONTRACT_ID.Text;
model.CRT_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
model.CRT_USER_ID = OlUser.Manager_LoginName;
}
else
{
int _id = ConvertHelper.Cint(hidId.Text.ToString());
model = new CONTRACT00(x => x.Id == _id);
model.SetIsNew(false);
model.CONTRACT_ID = model.CONTRACT_ID;
}
model.MOD_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
model.MOD_USER_ID = OlUser.Manager_LoginName;
model.CONTRACT_TITLE = tbxCONTRACT_TITLE.Text;
if (cbxUSABLE.Checked == true)
{
model.USABLE = 1;
}
else
{
model.USABLE = 0;
}
if (cbxLOCK.Checked == true)
{
model.LOCK = 1;
}
else
{
model.LOCK = 0;
}
model.CONTRACTP_SIGN = ConvertHelper.StringToDatetime(dpkCONTRACTP_SIGN.Text.ToString());
model.CONTRACTP_STARTTIME = ConvertHelper.StringToDatetime(dpkCONTRACTP_STARTTIME.Text.ToString());
model.CONTRACTP_ENDTIME = ConvertHelper.StringToDatetime(dpkCONTRACTP_ENDTIME.Text.ToString());
model.FIRST_PARTY = tbxFIRST_PARTY.Text;
model.SECEND_PARTY = tbxSECEND_PARTY.SelectedValue.ToString();
model.Meno = tbxMeno.Text;
CONTRACT00Bll.GetInstence().Save(this, model);
result = "";
}
catch (Exception err)
{
result = "保存失败";
}
return(result);
}
/// <summary>
/// 数据保存
/// </summary>
/// <returns></returns>
public override string Save()
{
string result = string.Empty;
var branchId = ConvertHelper.Cint0(hidBranchId.Text);
var positionId = ConvertHelper.Cint0(hidPositionId.Text);
try
{
#region 数据验证
if (branchId == 0)
{
return("非法路径进入！");
}
if (string.IsNullOrEmpty(txtName.Text.Trim()))
{
return(txtName.Label + "不能为空！");
}
//同一个部门里职位不能样同，不同部门可以有同名称的职位
var sName = StringHelper.Left(txtName.Text, 30);
if (PositionBll.GetInstence().Exist(x => x.Branch_Id == branchId && x.Name == sName && x.Id != positionId))
{
return(txtName.Label + "已存在！请重新输入！");
}
#endregion
#region 赋值
//定义是否更新其他关联表变量
bool isUpdate = false;
//获取实体
var model = new Position(x => x.Id == positionId);
//判断是否有改变名称
if (positionId > 0 && sName != model.Name)
{
isUpdate = true;
}
//修改时间与管理员
model.UpdateDate = DateTime.Now;
model.Manager_Id = OnlineUsersBll.GetInstence().GetManagerId();
model.Manager_CName = OnlineUsersBll.GetInstence().GetManagerCName();
//设置名称
model.Name = sName;
//设置部门
var branchModel = BranchBll.GetInstence().GetModelForCache(branchId);
model.Branch_Id = branchId;
model.Branch_Name = branchModel.Name;
model.Branch_Code = branchModel.Code;
//设置职位权限
//从树列表中获取勾选的节点
GetCheckTreeNode(MenuTree.Nodes);
//赋予权限
model.PagePower = StringHelper.FilterSql(_hidPositionPagePower);
model.ControlPower = StringHelper.FilterSql(_hidPositionControlPower);
#endregion
//----------------------------------------------------------
//存储到数据库
PositionBll.GetInstence().Save(this, model);
//如果本次修改改变了相关名称，则同步更新其他关联表的对应名称
if (isUpdate)
{
ManagerBll.GetInstence().UpdatePositionName(model.Id, model.Name);
}
}
catch (Exception e)
{
result = "保存失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
}
return(result);
}
/// <summary>
/// 退出系统
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnExit_Click(object sender, EventArgs e)
{
OnlineUsersBll.GetInstence().UserExit(this);
FineUI.Alert.ShowInTop("成功退出系统！", "安全退出", MessageBoxIcon.Information, "top.location='Login.aspx'");
}
/// <summary>
/// 数据保存
/// </summary>
/// <returns></returns>
public override string Save()
{
string result = string.Empty;
int id = ConvertHelper.Cint0(hidId.Text);
try
{
//判断
if (ddlShop.SelectedValue == "0")
{
return(ddlShop.Label + "不能为空！");
}
if (ddlOUT_SHOP.SelectedValue == "0")
{
return(ddlOUT_SHOP.Label + "不能为空！");
}
if (ddlORDER_DEP.SelectedValue == "0")
{
return(ddlORDER_DEP.Label + "不能为空！");
}
//订单编号
if (txtORDER_ID.Text == "")
{
Random ran = new Random();
txtORDER_ID.Text = ddlShop.SelectedValue + "OR" + DateTime.Now.ToString("yyyy-MM-dd").Replace("-", "") + ran.Next(1000, 9999);
}
string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名
txtAPP_USER.Text = manager_LoginName;
txtAPP_DATE.SelectedDate = DateTime.Now;
string ORDER_ID = txtORDER_ID.Text; // GridViewHelper.GetSelectedKey(Grid2, true);
//获取价格区域
string shop_id = ddlShop.SelectedValue;// OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString();
var model_SHOP = new SHOP00(x => x.SHOP_ID == shop_id);
string prcarea_id = model_SHOP.SHOP_Price_Area;
// 复制原始表格的结构
DataTable newTable = GetSourceData(ORDER_ID, prcarea_id).Clone();
DataRow newRow;
JArray mergedData = Grid1.GetMergedData();
int i = 0;
foreach (JObject mergedRow in mergedData)
{
string status = mergedRow.Value <string>("status");
int rowIndex = mergedRow.Value <int>("index");
JObject values = mergedRow.Value <JObject>("values");
i = i + 1;
newRow = newTable.NewRow();
newRow[0] = rowIndex;//i;////j;// rowIndex; // 将行标识符设置为行索引号
newRow[1] = values.Value <string>("PROD_ID");
newRow[2] = values.Value <string>("PROD_NAME1");
newRow[3] = values.Value <string>("PROD_SPEC");
newRow[4] = values.Value <string>("PROD_UNIT");
newRow[5] = values.Value <string>("ON_QUAN");
newRow[6] = values.Value <string>("STD_PRICE");
newRow[7] = values.Value <string>("QUAN1");
newTable.Rows.Add(newRow);
}
// 更新数据源
Session[KEY_FOR_DATASOURCE_SESSION] = newTable;
labResult.Text = ""; // String.Format("用户修改的数据：<pre>{0}</pre>", Grid1.GetModifiedData().ToString(Newtonsoft.Json.Formatting.Indented));
// MessageBox.Show(this,String.Format("用户修改的数据：<pre>{0}</pre>", Grid1.GetModifiedData().ToString(Newtonsoft.Json.Formatting.Indented)));
// DataTable table = GetSourceData();
Grid1.DataSource = (DataTable)Session[KEY_FOR_DATASOURCE_SESSION];// table;
Grid1.DataBind();
#region 数据验证
//判断列表
DataTable dt = (DataTable)Session[KEY_FOR_DATASOURCE_SESSION];
if (dt.Rows.Count <= 0 || Session[KEY_FOR_DATASOURCE_SESSION] == null)
{
return("要货明细不能为空!");
}
#endregion
//改变界面
ddlStatus.SelectedValue = "1" + "";
#region 赋值 主表
var model = new ORDER00(x => x.ORDER_ID == ORDER_ID);
model.SHOP_ID = ddlShop.SelectedValue;
model.ORDER_ID = txtORDER_ID.Text;
model.INPUT_DATE = DateTime.Now; // ConvertHelper.StringToDatetime(txtINPUT_DATE.Text);
model.ORD_USER = txtORD_USER.Text;
model.EXPECT_DATE = DateTime.Now; // ConvertHelper.StringToDatetime(txtEXPECT_DATE.Text);
model.STATUS = 1;
model.ORD_TYPE = ConvertHelper.Cint0(ddlORD_TYPE.SelectedValue);
model.OUT_SHOP = ddlOUT_SHOP.SelectedValue;
model.EXPORTED_ID = txtEXPORTED_ID.Text;
model.EXPORTED = ConvertHelper.StringToByte(txtEXPORTED.Text);
model.APP_USER = txtAPP_USER.Text;
model.APP_DATE = DateTime.Now;//ConvertHelper.StringToDatetime(txtAPP_DATE.Text);
model.Memo = txtMemo.Text;
model.LOCKED = ConvertHelper.StringToByte(cbLOCKED.Checked.ToString());
model.ORD_DEP_ID = ddlORDER_DEP.SelectedValue;
model.CRT_DATETIME = DateTime.Now; //ConvertHelper.StringToDatetime(txtCRT_DATETIME.Text);
model.CRT_USER_ID = txtCRT_USER_ID.Text;
model.MOD_DATETIME = DateTime.Now; //ConvertHelper.StringToDatetime(txtMOD_DATETIME.Text);
model.MOD_USER_ID = txtMOD_USER_ID.Text;
model.LAST_UPDATE = DateTime.Now; //ConvertHelper.StringToDatetime(txtLAST_UPDATE.Text);
model.Trans_STATUS = 0;
#endregion
//----------------------------------------------------------
//存储到数据库
ORDER00Bll.GetInstence().Save(this, model);
//清空子表
ORDER00Bll.GetInstence().Delete(model.ORDER_ID);
#region 添加子表
JArray mergedData1 = Grid1.GetMergedData();
int f = mergedData.Count;
int k = 0;
foreach (JObject mergedRow in mergedData1)
{
string status = mergedRow.Value <string>("status");
int rowIndex = mergedRow.Value <int>("index");
JObject values = mergedRow.Value <JObject>("values");
k = k + 1;
try
{
var model_1 = new ORDER01(x => x.SNo == k && x.ORDER_ID == txtORDER_ID.Text.Trim());
model_1.SNo = k;// rowIndex + 1;
model_1.SHOP_ID = ddlShop.SelectedValue;
model_1.ORDER_ID = txtORDER_ID.Text.Trim();
model_1.PROD_ID = values.Value <string>("PROD_ID");
model_1.QUANTITY = 0;
model_1.ON_QUAN = ConvertHelper.StringToDecimal(values.Value <string>("ON_QUAN"));
model_1.QUAN1 = ConvertHelper.StringToDecimal(values.Value <string>("QUAN1"));//小计
model_1.QUAN2 = 0;
model_1.COST_PRICE = ConvertHelper.StringToDecimal(values.Value <string>("STD_PRICE"));
model_1.STD_UNIT = "1";//最小订货单位 Prod_UnitList.UNIT_ID;
model_1.STD_CONVERT = 0;
model_1.STD_QUAN = ConvertHelper.StringToDecimal(values.Value <string>("ON_QUAN"));
model_1.STD_PRICE = ConvertHelper.StringToDecimal(values.Value <string>("STD_PRICE"));
model_1.Memo = "";
model_1.CRT_DATETIME = DateTime.Now;
model_1.CRT_USER_ID = txtCRT_USER_ID.Text;
model_1.MOD_DATETIME = DateTime.Now;
model_1.MOD_USER_ID = txtMOD_USER_ID.Text;
// model_1.STD_TYPE = "";
ORDER01Bll.GetInstence().Save(this, model_1);
} catch (Exception ee) {
result = "保存失败！";
CommonBll.WriteLog(result + ":" + DateTime.Now.ToString(), ee);
}
//----------------------------------------------------------
//存储到数据库
}
///grid2
conditionList = new List <ConditionFun.SqlqueryCondition>();
user = OnlineUsersBll.GetInstence().GetPosition_Name(this, OnlineUsersBll.GetInstence().GetManagerId(), false);
if (user.Contains("管理员"))
{
conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "1", Comparison.Equals, "1", false, false));
}
else
{
conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, ORDER00Table.SHOP_ID, Comparison.Equals, shop_id, false, false));
}
ORDER00Bll.GetInstence().BindGrid(Grid2, 0, 0, conditionList, sortList);
#endregion
}
catch (Exception e)
{
result = "保存失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
}
//设置不可更改
txtINPUT_DATE.Enabled = true;
ddlEXPECT_DATE.Enabled = true;
ddlORDER_DEP.Enabled = true;
ddlORD_TYPE.Enabled = true;
ddlEXPECT_DATE.Enabled = true;
ddlOUT_SHOP.Enabled = true;
txtMemo.Enabled = true;
ButtonApproval.Enabled = true;
btnNew.Enabled = true;
btnDelete.Enabled = true;
Grid1.Enabled = true;
// Grid1.Rows.Clear();
// ButtonPowers();
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(SUP_ID.Text.Trim()))
{
return(SUP_ID.Label + "不能为空！");
}
if (string.IsNullOrEmpty(SUP_NAME.Text.Trim()))
{
return(SUP_NAME.Label + "不能为空！");
}
if (string.IsNullOrEmpty(SUP_NICKNAME.Text.Trim()))
{
return(SUP_NICKNAME.Label + "不能为空！");
}
if (string.IsNullOrEmpty(SUP_TYPE.SelectedValue) || SUP_TYPE.SelectedValue == "0")
{
return(SUP_TYPE.Label + "不能为空！");
}
var sSUP_ID = StringHelper.Left(SUP_ID.Text, 50);
if (SUPPLIERSBll.GetInstence().Exist(x => x.SUP_ID == sSUP_ID) && id == 0)
{
return(SUP_ID.Label + "已存在！请重新输入！");
}
var sSUP_NAME = StringHelper.Left(SUP_NAME.Text, 50);
if (SUPPLIERSBll.GetInstence().Exist(x => x.SUP_NAME == sSUP_NAME) && id == 0)
{
return(SUP_NAME.Label + "已存在！请重新输入！");
}
//var sMeno = StringHelper.Left(UNIT_MENO.Text, 40);
//if (UNIT_MENO.Text.Trim().Length > 40)
//{
// return UNIT_MENO.Label + "超长！";
//}
#endregion
#region 赋值
var model = new SUPPLIERS(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.SUP_ID = sSUP_ID;
model.SUP_NAME = sSUP_NAME;
model.SUP_NICKNAME = SUP_NICKNAME.Text;
model.SUP_TYPE = ConvertHelper.Cint(SUP_TYPE.SelectedValue);
model.SUP_ADD = SUP_ADD.Text;
model.SUP_TEL = SUP_TEL.Text;
model.SUP_Email = SUP_Email.Text;
model.SUP_ZIP = SUP_ZIP.Text;
model.SUP_Contact = SUP_Contact.Text;
model.SUP_Mobile = SUP_Mobile.Text;
model.SUP_CODE_ID = SUP_CODE_ID.Text;
model.SUP_BankName = SUP_BankName.Text;
model.SUP_BankID = SUP_BankID.Text;
model.SUP_PASSWORD = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(SUP_PASSWORD.Text, "MD5");
model.Send_DAY = ConvertHelper.Cint(Send_DAY.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"));
#endregion
////----------------------------------------------------------
////存储到数据库
SUPPLIERSBll.GetInstence().Save(this, model);
}
catch (Exception e)
{
result = "保存失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
}
return(result);
}
protected void btnSubmit1_Click(object sender, EventArgs e)
{
Grid2.Rows.Clear();
//判断
FineUI.RadioButton RaddpUp_Date = Window2.FindControl("A").FindControl("RaddpUp_Date") as FineUI.RadioButton;
FineUI.RadioButton RadEXPECT_DATE = Window2.FindControl("B").FindControl("RadEXPECT_DATE") as FineUI.RadioButton;
if (RaddpUp_Date.Checked == false && RadEXPECT_DATE.Checked == false)
{
Alert.Show("请选择时间");
return;
}
string Start_Time = "";
string End_Time = "";
//获取时间
DatePicker dpUp_DateBeg = Window2.FindControl("A").FindControl("dpUp_DateBeg") as DatePicker;
DateTime dt_up_date_bg = ConvertHelper.StringToDatetime(DateTime.Parse(dpUp_DateBeg.SelectedDate.ToString()).ToString("yyyy-MM-dd 00:00:00"));
DatePicker dpUp_DateEnd = Window2.FindControl("A").FindControl("dpUp_DateEnd") as DatePicker;
DateTime dt_up_date_end = ConvertHelper.StringToDatetime(DateTime.Parse(dpUp_DateEnd.SelectedDate.ToString()).ToString("yyyy-MM-dd 23:59:59"));
DatePicker dpEXPECT_DATEBeg = Window2.FindControl("B").FindControl("dpEXPECT_DATEBeg") as DatePicker;
DateTime dt_expect_date_bg = ConvertHelper.StringToDatetime(DateTime.Parse(dpEXPECT_DATEBeg.SelectedDate.ToString()).ToString("yyyy-MM-dd 00:00:00"));
DatePicker dpEXPECT_DATEEnd = Window2.FindControl("B").FindControl("dpEXPECT_DATEEnd") as DatePicker;
DateTime dt_expect_date_end = ConvertHelper.StringToDatetime(DateTime.Parse(dpEXPECT_DATEEnd.SelectedDate.ToString()).ToString("yyyy-MM-dd 23:59:59"));
int IsTime = 1;
if (RaddpUp_Date.Checked)
{
IsTime = 0;
Start_Time = dt_up_date_bg.ToString();
End_Time = dt_up_date_end.ToString();
}
if (RadEXPECT_DATE.Checked)
{
IsTime = 1;
Start_Time = dt_expect_date_bg.ToString();
End_Time = dt_expect_date_end.ToString();
}
string shop_id = SHOP_hidId.Text.Trim();
string shop_name = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_NAME1").ToString();
string shop_idStr = ORDER00Table.SHOP_ID;
// string user = OnlineUsersBll.GetInstence().GetPosition_Name(this, OnlineUsersBll.GetInstence().GetManagerId(), false);
user = OnlineUsersBll.GetInstence().GetPosition_Name(this, OnlineUsersBll.GetInstence().GetManagerId(), false);
if (user.Contains("区域管理员"))
{
IsTime = -1;
}
Session["SerchPars_session_Orders"] = Session["SerchPars_session"] = IsTime + "," + Start_Time + "," + End_Time;
BandGrid2(shop_name, shop_idStr, shop_id, Start_Time, End_Time, IsTime);
Window2.Hidden = true;
}
/// <summary>
/// 数据保存
/// </summary>
/// <returns></returns>
public override string Save()
{
string result = string.Empty;
int id = ConvertHelper.Cint0(hidId.Text);
try
{
#region 数据验证
if (string.IsNullOrEmpty(UNIT_ID.Text.Trim()))
{
return(UNIT_ID.Label + "不能为空！");
}
if (string.IsNullOrEmpty(UNIT_NAME.Text.Trim()))
{
return(UNIT_NAME.Label + "不能为空！");
}
var sName = StringHelper.Left(UNIT_NAME.Text, 50);
if (PROD_UNITBll.GetInstence().Exist(x => x.UNIT_NAME == sName) && id == 0)
{
return(UNIT_NAME.Label + "已存在！请重新输入！");
}
var sUNIT_ID = StringHelper.Left(UNIT_ID.Text, 50);
if (PROD_UNITBll.GetInstence().Exist(x => x.UNIT_ID == sUNIT_ID) && id == 0)
{
return(UNIT_ID.Label + "已存在！请重新输入！");
}
var sMeno = StringHelper.Left(UNIT_MENO.Text, 40);
if (UNIT_MENO.Text.Trim().Length > 40)
{
return(UNIT_MENO.Label + "超长！");
}
#endregion
#region 赋值
var model = new PROD_UNIT(x => x.Id == id);
//var OlUser = new OnlineUsers(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
//var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
var OlUser = OnlineUsers.SingleOrDefault(x => x.UserHashKey == OnlineUsersBll.GetInstence().GetUserHashKey());
//设置名称
model.UNIT_ID = UNIT_ID.Text;
model.UNIT_NAME = sName;
model.UNIT_MEMO = sMeno;
model.CRT_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
model.CRT_USER_ID = OlUser.Manager_LoginName;
//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
//----------------------------------------------------------
//存储到数据库
PROD_UNITBll.GetInstence().Save(this, model);
}
catch (Exception e)
{
result = "保存失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
}
return(result);
}
public override void Add()
{
string shop_id = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString(); // SHOP_hidId.Text.Trim();
int managerId = OnlineUsersBll.GetInstence().GetManagerId(); //获取登录名
//表头
SHOP00Bll.GetInstence().GetShopList(this, shop_id, ddlShop); //.BandDropDownListShowShop(this, ddlShop, shop_id); //分店名称
SHOP00Bll.GetInstence().BandDropDownListShowShop1(this, ddlOUT_SHOP); //供货分店
// ORDER_DEP00Bll.GetInstence().BandDropDownList(this, ddlORDER_DEP, shop_id);//订货部门
BranchBll.GetInstence().BandDropDownList(this, ddlORDER_DEP);
string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名
txtCRT_USER_ID.Text = manager_LoginName;
txtORD_USER.Text = manager_LoginName;
txtAPP_USER.Text = ""; // manager_LoginName;
txtMOD_USER_ID.Text = ""; // manager_LoginName;
txtINPUT_DATE.SelectedDate = DateTime.Now; //单据时间
txtManage.Text = manager_LoginName;
ddlStatus.SelectedValue = "0";//状态
ddlEXPECT_DATE.SelectedDate = DateTime.Now.AddDays(1);
txtCRT_DATETIME.SelectedDate = DateTime.Now;
txtMOD_DATETIME.SelectedDate = DateTime.Now;
txtEXPORTED_ID.Text = "";
txtMemo.Text = "";
cbTrans_STATUS.Checked = false;
ddlShop.SelectedValue = shop_id;
HiddenShop_Id.Text = ddlShop.SelectedValue;// ddlORDER_DEP.SelectedValue;
Random ran = new Random();
txtORDER_ID.Text = ddlShop.SelectedValue + "OR" + DateTime.Now.ToString("yyyy-MM-dd").Replace("-", "") + ran.Next(1000, 9999);
ddlStatus.SelectedIndex = 0;
txtEXPORTED_ID.Text = "";
txtEXPORTED.Checked = false;
txtCRT_DATETIME.Text = DateTime.Now.ToString();
txtLAST_UPDATE.Text = DateTime.Now.ToString();
txtMOD_DATETIME.Text = DateTime.Now.ToString();
//设置不可更改
txtINPUT_DATE.Enabled = true;
ddlEXPECT_DATE.Enabled = true;
ddlORDER_DEP.Enabled = true;
ddlORD_TYPE.Enabled = true;
ddlEXPECT_DATE.Enabled = true;
ddlOUT_SHOP.Enabled = true;
txtMemo.Enabled = true;
ButtonApproval.Enabled = true;
btnNew.Enabled = true;
btnDelete.Enabled = true;
Grid1.Enabled = true;
Grid1.Rows.Clear();
// txtManage.Text = OnlineUsersBll.GetInstence().GetManager_LoginName(this, managerId, true);
}
/// <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 (AdvertisementBll.GetInstence().Exist(x => x.Name == sName && x.Id != id))
{
return(txtName.Label + "已存在！请重新输入！");
}
if (ddlAdvertisingPosition.SelectedValue == "0")
{
return(ddlAdvertisingPosition.Label + "为必选项，请选择！");
}
if (dpStartTime.SelectedDate == null || TimeHelper.IsDateTime(dpStartTime.SelectedDate) == false)
{
return("请选择" + dpStartTime.Label);
}
if (dpEndTime.SelectedDate == null || TimeHelper.IsDateTime(dpEndTime.SelectedDate) == false)
{
return("请选择" + dpEndTime.Label);
}
if (dpStartTime.SelectedDate > dpEndTime.SelectedDate)
{
return(dpStartTime.Label + "不能大于" + dpEndTime.Label);
}
#endregion
#region 赋值
//获取实体
var model = new Advertisement(x => x.Id == id);
//------------------------------------------
//设置名称
model.Name = sName;
model.Keyword = StringHelper.Left(txtKeyword.Text, 50);
model.Url = StringHelper.Left(txtUrl.Text, 200, true, false);
//说明
model.Content = StringHelper.Left(txtContent.Text, 100);
//取得位置
model.AdvertisingPosition_Id = ConvertHelper.Cint0(ddlAdvertisingPosition.SelectedValue);
model.AdvertisingPosition_Name = StringHelper.Left(ddlAdvertisingPosition.SelectedText, 50);
//开始时间与结束时间
model.StartTime = dpStartTime.SelectedDate ?? DateTime.Now;
model.EndTime = dpEndTime.SelectedDate ?? DateTime.Now.AddDays(1);
//设定当前项是否显示
model.IsDisplay = ConvertHelper.StringToByte(rblIsDisplay.SelectedValue);
model.Sort = ConvertHelper.Cint0(txtSort.Text);;
//修改时间与用户
model.UpdateDate = DateTime.Now;
model.Manager_Id = OnlineUsersBll.GetInstence().GetManagerId();
model.Manager_CName = OnlineUsersBll.GetInstence().GetManagerCName();
#endregion
//------------------------------------------
#region 图片
//判断前端的ASP.NET上传控件是否选择有上传文件
if (this.filePhoto.HasFile && this.filePhoto.FileName.Length > 3)
{
//将当前页面上传文件绑定上传配置表Id为7的记录，给上传组件的逻辑层函数调用
int vid = 7; //7 广告
//---------------------------------------------------
//创建上传实体
var upload = new UploadFile();
//调用ASP.NET上传控件上传函数，并获取上传成功或失败信息
result = new UploadFileBll().Upload_AspNet(this.filePhoto.PostedFile, vid, RndKey,
OnlineUsersBll.GetInstence().GetManagerId(), OnlineUsersBll.GetInstence().GetManagerCName(),
upload);
this.filePhoto.Dispose();
//---------------------------------------------------
//没有返回信息时表示上传成功
if (result.Length == 0)
{
//将上传到服务器后的路径赋给广告实体对应字段
model.AdImg = upload.Path;
}
else
{
//将出错写入日志中
CommonBll.WriteLog("上传出错：" + result); //收集异常信息
//弹出出错提示
return("上传出错！" + result);
}
}
//如果是修改，检查用户是否重新上传过广告图片，如果是删除旧的图片
if (model.Id > 0)
{
//删除旧图片
UploadFileBll.GetInstence()
.Upload_DiffFile(AdvertisementTable.Id, AdvertisementTable.AdImg, AdvertisementTable.TableName,
model.Id, model.AdImg);
//同步UploadFile上传表记录，绑定刚刚上传成功的文件Id为当前记录Id
UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, AdvertisementTable.TableName, model.Id);
}
#endregion
//----------------------------------------------------------
//存储到数据库
AdvertisementBll.GetInstence().Save(this, model);
#region 步更新上传图片表绑定Id
if (id == 0)
{
//同步UploadFile上传表记录，绑定刚刚上传成功的文件Id为当前记录Id
UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, AdvertisementTable.TableName, model.Id);
}
#endregion
//这里放置清空前端页面缓存的代码（如果前端使用了页面缓存的话，必须进行清除操作）
}
catch (Exception e)
{
result = "保存失败！";
//出现异常，保存出错日志广告
CommonBll.WriteLog(result, e);
}
return(result);
}
/// <summary>
/// 汇整
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnArchive_Click(object sender, EventArgs e)
{
//判断
FineUI.RadioButton RaddpUp_Date = Window2.FindControl("A").FindControl("RaddpUp_Date") as FineUI.RadioButton;
FineUI.RadioButton RadEXPECT_DATE = Window2.FindControl("B").FindControl("RadEXPECT_DATE") as FineUI.RadioButton;
if (RaddpUp_Date.Checked == false && RadEXPECT_DATE.Checked == false)
{
Alert.Show("请选择时间");
return;
}
string Start_Time = "";
string End_Time = "";
//获取时间
DatePicker dpUp_DateBeg = Window2.FindControl("A").FindControl("dpUp_DateBeg") as DatePicker;
DateTime dt_up_date_bg = ConvertHelper.StringToDatetime(dpUp_DateBeg.SelectedDate.ToString());
DatePicker dpUp_DateEnd = Window2.FindControl("A").FindControl("dpUp_DateEnd") as DatePicker;
DateTime dt_up_date_end = ConvertHelper.StringToDatetime(dpUp_DateEnd.SelectedDate.ToString());
DatePicker dpEXPECT_DATEBeg = Window2.FindControl("B").FindControl("dpEXPECT_DATEBeg") as DatePicker;
DateTime dt_expect_date_bg = ConvertHelper.StringToDatetime(dpEXPECT_DATEBeg.SelectedDate.ToString());
DatePicker dpEXPECT_DATEEnd = Window2.FindControl("B").FindControl("dpEXPECT_DATEEnd") as DatePicker;
DateTime dt_expect_date_end = ConvertHelper.StringToDatetime(dpEXPECT_DATEEnd.SelectedDate.ToString());
//参数
Random ran = new Random();
string SHOP_ID = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString();
string COL_ID = SHOP_ID + "CL" + DateTime.Now.ToString("yyyy-MM-dd") + +ran.Next(1000, 9999);
string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名
int IsTime = 1;
if (RaddpUp_Date.Checked)
{
IsTime = 0;
Start_Time = dt_up_date_bg.ToString();
End_Time = dt_up_date_end.ToString();
}
if (RadEXPECT_DATE.Checked)
{
IsTime = 1;
Start_Time = dt_expect_date_bg.ToString();
End_Time = dt_expect_date_end.ToString();
}
string ORD_DEP_ID_C = "";//汇整者的 部门
int ex_int = Col_Order00Bll.GetInstence().ADD_ARCHIVEORDERS(manager_LoginName, ORD_DEP_ID_C, SHOP_ID, Start_Time, End_Time, IsTime);
if (ex_int == 0)
{
Alert.Show("汇整成功！");
}
else
{
Alert.Show("汇整失败！请重新汇整！");
}
LoadData();
}
/// <summary>
/// 子表保存
/// </summary>
/// <returns></returns>
public string DetailEdit()
{
JArray jarr = Grid2.GetMergedData();
string result = "";
result = DetailChecked(jarr);
if (!String.IsNullOrEmpty(result))
{
return(result);
}
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
int n = 0;
for (int i = 0; i < jarr.Count; i++)
{
try
{
int id = ConvertHelper.Cint(jarr[i]["values"]["Id01"].ToString());
var model2 = new TAKEIN11(x => x.Id == id);
//string str = jarr[i]["status"].ToString();
if (jarr[i]["status"].ToString().Equals("modified"))
{
model2.SetIsNew(false);
}
else if (jarr[i]["status"].ToString().Equals("unchanged"))
{
continue;
}
else
{
model2.SetIsNew(true);
}
model2.SHOP_ID = jarr[i]["values"]["SHOP_ID01"].ToString();
if (!String.IsNullOrEmpty(jarr[i]["values"]["TAKEIN_ID01"].ToString()))
{
model2.TAKEIN_ID = jarr[i]["values"]["TAKEIN_ID01"].ToString();
}
else
{
return("保存失败");
}
model2.SNo = ConvertHelper.Cint(jarr[i]["values"]["TAKEIN_ID01"].ToString());
model2.PROD_ID = jarr[i]["values"]["PROD_ID01"].ToString();
model2.QUANTITY = ConvertHelper.StringToDecimal(jarr[i]["values"]["QUANTITY01"].ToString());
model2.STD_UNIT = jarr[i]["values"]["STD_UNIT01"].ToString();
model2.STD_CONVERT = ConvertHelper.Cint(jarr[i]["values"]["STD_CONVERT01"].ToString());
model2.STD_QUAN = ConvertHelper.StringToDecimal(jarr[i]["values"]["STD_QUAN01"].ToString());
model2.STD_PRICE = ConvertHelper.StringToDecimal(jarr[i]["values"]["STD_PRICE01"].ToString());
model2.Tax = ConvertHelper.StringToDecimal(jarr[i]["values"]["Tax01"].ToString());
//model2.COST = ConvertHelper.StringToDecimal(jarr[i]["values"]["COST01"].ToString());
model2.QUAN1 = ConvertHelper.StringToDecimal(jarr[i]["values"]["QUAN101"].ToString());
model2.QUAN2 = ConvertHelper.StringToDecimal(jarr[i]["values"]["QUAN201"].ToString());
model2.Item_DISC_Amt = 0;
model2.MEMO = jarr[i]["values"]["MEMO01"].ToString();
model2.BAT_NO = jarr[i]["values"]["BAT_NO"].ToString();
model2.Exp_DateTime = DateTime.Now;
TAKEIN11Bll.GetInstence().Save(this, model2);
}
catch (Exception err)
{
n++;
result = "明细保存失败" + n + "条";
}
}
LoadDETAIL();
return(result);
}
///// <summary>
///// 更换分店事件
///// </summary>
///// <param name="sender"></param>
///// <param name="e"></param>
//protected void shopIdDropdown_SelectedIndexChanged(object sender, EventArgs e)
//{
// LoadData();
//}
/// <summary>
/// 汇整出货单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Archive_Click(object sender, EventArgs e)
{
archiveWindow.Hidden = true;
//获取登录用户
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
//登录名
string userId = OlUser.Manager_LoginName;
//获取用户所属shop
shopId = OlUser.SHOP_ID;
DatePicker dpStart = archiveWindow.FindControl("archiveDatePanel").FindControl("outStartDate") as DatePicker;
DatePicker dpEnd = archiveWindow.FindControl("archiveDatePanel").FindControl("outEndDate") as DatePicker;
//拼接查询条件
List <ConditionFun.SqlqueryCondition> conditionList = QueryOutListCondition(shopId, dpStart.Text, dpEnd.Text);
//1.查询总部出货表
// 1)出货单状态为 2=核准
// 2)SHOP_ID = 当前登录用户的总部编号
// 3)在指定日期范围内
//2.遍历结果
//3.更新出货单状态为5=月结(关单)， 并且锁定出货单(LOCKED=1)
//4.更新成功后查询出货单明细更新到应收明细表
//5.保存应收主信息
//6.保存应收明细
int total = 0;
//循环查询
while (true)
{
//1.查询满足条件的出货单
DataTable dataTable = OUT00Bll.GetInstence().GetDataTable(false, 100, null, 0, 100, conditionList, null);
if (dataTable == null || dataTable.Rows.Count == 0)
{
break;
}
//2.遍历查询结果
foreach (DataRow row in dataTable.Rows)
{
try
{
//3.更新出货单状态为5=月结(关单)
int retValue = updaterHelper.Update(string.Format("update OUT00 set STATUS = 5, LOCKED = 1 where id = {0} and STATUS = 2", row["Id"]));
//更新成功 汇整出货单
if (retValue == 1)
{
//4.查询出货单明细
//明细查询条件
List <ConditionFun.SqlqueryCondition> itemConditionList = new List <ConditionFun.SqlqueryCondition>();
itemConditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "SHOP_ID", Comparison.Equals, row["SHOP_ID"], false, false));
itemConditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.And, "OUT_ID", Comparison.Equals, row["OUT_ID"], false, false));
//执行查询
List <OUT01> outItemList = selectHelper.Select <OUT01>(false, 0, null, itemConditionList, new List <string>()
{
"SNo"
}).ExecuteTypedList <OUT01>();
if (outItemList == null || outItemList.Count == 0)
{
CommonBll.WriteLog(string.Format("出货单{0}未查询到明细", row["OUT_ID"]), null);
continue;
}
//出货价格
decimal price = 0;
//出货成本
decimal cost = 0;
//遍历出货单明细插入
foreach (OUT01 item in outItemList)
{
//累加出货价
price += item.STD_PRICE;
//累加成本
cost += item.COST;
//应收明细
RECEIVABLES01 receiveItem = new RECEIVABLES01();
//出货批号
receiveItem.BAT_NO = item.BAT_NO;
//出货成本
receiveItem.COST = item.COST;
//明细备注
receiveItem.MEMO = item.MEMO;
//出货单ID
receiveItem.OUT_ID = item.OUT_ID;
//商品编号
receiveItem.PROD_ID = item.PROD_ID;
//验收量
receiveItem.QUAN1 = item.QUAN1;
//取消量
receiveItem.QUAN2 = item.QUAN2;
//总店编号
receiveItem.SHOP_ID = item.SHOP_ID;
//明细序号
receiveItem.SNo = item.SNo;
//出货价格
receiveItem.STD_PRICE = item.STD_PRICE;
//出货量
receiveItem.STD_QUAN = item.STD_QUAN;
//出货单位
receiveItem.STD_UNIT = item.STD_UNIT;
//6.保存明细
receiveItem.Save();
}
RECEIVABLES00 receiveMain = new RECEIVABLES00();
//receiveMain.APP_DATETIME
//receiveMain.APP_USER = "";
//建档时间
receiveMain.CRT_DATETIME = DateTime.Now;
//建档人员
receiveMain.CRT_USER_ID = userId;
//出货单日期
receiveMain.INPUT_DATE = (DateTime)row["INPUT_DATE"];
//分店编号
receiveMain.IN_SHOP = row["IN_SHOP"].ToString();
//最后修改日期
receiveMain.LAST_UPDATE = DateTime.Now;
//备注
receiveMain.MEMO = row["Memo"].ToString();
//修改时间
receiveMain.MOD_DATETIME = DateTime.Now;
//修改人
receiveMain.MOD_USER_ID = userId;
//出货单号
receiveMain.OUT_ID = row["OUT_ID"].ToString();
//总店编号
receiveMain.SHOP_ID = row["SHOP_ID"].ToString();
//新建存档状态
receiveMain.STATUS = 1;
//出货单的建单人
receiveMain.USER_ID = row["USER_ID"].ToString();
//出货总价
receiveMain.BILL_AMOUNT = price;
//出货总成本
receiveMain.BILL_COST = cost;
//5.保存应收账单
receiveMain.Save();
total++;
}
}
catch (Exception ex)
{
CommonBll.WriteLog(string.Format("汇整出货单{0}发生错误。", row["OUT_ID"]), ex);
}
}
//已处理到最后一页
if (dataTable.Rows.Count < 100)
{
break;
}
//等待2秒
Thread.Sleep(2000);
}
Thread.Sleep(5000);
Alert.Show(string.Format("汇整完成，共汇整{0}条出货单.", total));
}
