private void BindlstReecntTimes()
{
BindControl.BindListBox(lstReecntTimes, new List <KVEntity>());
if (rdoOneTimes.Checked)
{
if (cbxOneTimesHour.SelectedIndex == 0 || cbxOneTimesMinute.SelectedIndex == 0)
{
return;
}
}
else
{
if (cbxMultiTimesMinute.SelectedIndex == 0)
{
return;
}
}
string cronString = QuartzHelper.GenerateCronExpression(BuildCronExpression());
List <DateTime> list = QuartzHelper.GetNextFireTime(cronString, 8);
List <KVEntity> kvList = list.Select(item => new KVEntity {
K = item.ToString(), V = item.ToString()
}).ToList();
BindControl.BindListBox(lstReecntTimes, kvList);
}
private void Bind()
{
BindControl bc = new BindControl();
bc.BindDdl(ddlOrderReceiptStatus, typeof(EnumData.EnumReceiptOrderStatus), EnumData.EnumReceiptOrderStatus.新建.ToString());
bc.BindDdl(ddlOrderReceiptType, typeof(EnumData.EnumReceiptOrderType), EnumData.EnumReceiptOrderType.采购入库.ToString());
}
public ActionResult GroupPurchaseEdit()
{
this.ViewData["texOtype"] = RequestBase.GetString("otype");
BindControl bc = new BindControl();
ViewData["IsHasFunRole"] = Rolemanager.IsHasFunRole(EmployeeBase.e_ID, "001001001");//是否拥有管理的权限
Model.vm_GroupInfo model = new Model.vm_GroupInfo();
if (RequestBase.GetString("otype") == "modify")
{
string ids = RequestBase.GetString("dli_id");
ViewData["hfPId"] = ids;
int id = int.Parse(ids.Split('|')[0]);
model = new BLL.vm_GroupInfo().GetModel(id);
ViewData["starttime"] = model.gp_StartTime;
ViewData["endtime"] = model.gp_EndTime;
ViewData["p_Name"] = model.p_Name;
ViewData["p_ID"] = new BLL.GroupPurchaseBase().GetModel(id).sku_ID;
return View(model);
}
else
{
string pids = RequestBase.GetString("dli_id");
ViewData["hfPId"] = pids;
return View();
}
}
private void BindDataGridView()
{
BindControl.InitDataGridView(dgvTaskList);
dgvTaskList.CellClick += DgvTaskList_CellClick;
dgvTaskList.CellMouseDown += DgvTaskList_CellMouseDown;
loadGridData(1);
}
private void BindDrowDownList()
{
BindControl.BindComboBox(cbxDataType, Common.GetDataTypeList());
BindControl.BindComboBox(cbxCycleType, Common.GetCycleTypeList());
BindControl.BindComboBox(cbxTaskStatus, Common.GetTaskStatusList());
BindControl.BindComboBox(cbxEnabledStatus, Common.GetTaskEnabledStatusList());
}
private void Bind()
{
Guid Id = Guid.Empty;
if (!string.IsNullOrWhiteSpace(Request.QueryString["Id"]))
{
Guid.TryParse(Request.QueryString["Id"], out Id);
}
BindControl bc = new BindControl();
var bll = new Product();
if (!Id.Equals(Guid.Empty))
{
var model = bll.GetModel(Id);
if (model != null)
{
hId.Value = model.Id.ToString();
hCategoryId.Value = model.CategoryId.ToString();
txtProductCode.Value = model.ProductCode;
txtProductName.Value = model.ProductName;
txtFullName.Value = model.FullName;
txtSpecs.Value = model.Specs;
txtPrice.Value = model.Price.ToString();
txtMaterialQuality.Value = model.MaterialQuality;
txtWeight.Value = model.Weight.ToString();
txtMaxStore.Value = model.MaxStore.ToString();
txtMinStore.Value = model.MinStore.ToString();
txtOutPackVolume.Value = model.OutPackVolume.ToString();
txtOutPackWeight.Value = model.OutPackWeight.ToString();
txtInPackVolume.Value = model.InPackVolume.ToString();
txtInPackWeight.Value = model.InPackWeight.ToString();
txtOutPackQty.Value = model.OutPackQty.ToString();
txtInPackQty.Value = model.InPackQty.ToString();
txtShelfLife.Value = model.ShelfLife.ToString();
cbbSupplier.Value = model.SupplierId.ToString();
txtSort.Value = model.Sort.ToString();
txtRemark.Value = model.Remark;
bc.BindDdl(ddlIsDisable, typeof(EnumData.EnumIsDisable), model.IsDisable ? "禁用":"启用", "");
}
}
else
{
bc.BindDdl(ddlIsDisable, typeof(EnumData.EnumIsDisable), "", "");
var categoryId = Guid.Empty;
if (!string.IsNullOrWhiteSpace(Request.QueryString["categoryId"]))
{
Guid.TryParse(Request.QueryString["categoryId"], out categoryId);
}
if (!categoryId.Equals(Guid.Empty))
{
txtProductCode.Value = bll.CreateCode(categoryId);
}
}
}
private void BindUnit()
{
BindControl bc = new BindControl();
bc.BindDdl(ddlPiece, typeof(EnumData.EnumUnitLevel), EnumData.EnumUnitLevel.件.ToString());
bc.BindDdl(ddlInsidePackage, typeof(EnumData.EnumUnitLevel), EnumData.EnumUnitLevel.内包装.ToString());
bc.BindDdl(ddlBox, typeof(EnumData.EnumUnitLevel), EnumData.EnumUnitLevel.箱.ToString());
bc.BindDdl(ddlTray, typeof(EnumData.EnumUnitLevel), EnumData.EnumUnitLevel.托盘.ToString());
}
private void Bind()
{
Guid Id = Guid.Empty;
if (!string.IsNullOrWhiteSpace(Request.QueryString["Id"]))
{
Guid.TryParse(Request.QueryString["Id"], out Id);
}
BindControl bc = new BindControl();
if (!Id.Equals(Guid.Empty))
{
var bll = new OrderReceiptProduct();
var model = bll.GetModelByJoin(Id);
if (model != null)
{
hOrderProductId.Value = model.Id.ToString();
hProductId.Value = model.ProductId.ToString();
hPackageId.Value = model.PackageId.ToString();
txtExpectedQty.Value = model.ExpectedQty.ToString();
txtReceiptQty.Value = model.ReceiptQty.ToString();
txtProductPurchaseOrderCode.Value = model.PurchaseOrderCode;
txtSort.Value = model.Sort.ToString();
txtaProductRemark.Value = model.Remark;
txtPackageName.Value = model.PackageName;
txtSupplierName.Value = model.SupplierName;
txtProduceDate.Value = model.ProduceDate;
txtQualityStatus.Value = model.QualityStatus;
txtCheckQuantity.Value = model.CheckQuantity.ToString();
txtRejectQuantity.Value = model.RejectQuantity.ToString();
txtQCStatus.Value = model.QCStatus;
txtProduct.Value = model.ProductCode;
txtPackage.Value = model.PackageCode;
bc.BindDdl(ddlOrderReceiptStatus, typeof(EnumData.EnumReceiptOrderStatus), model.Status);
bc.BindDdl(ddlUnit, typeof(EnumData.EnumUnitLevel), model.Unit);
bc.BindDdl(ddlIsOk, typeof(EnumData.EnumIsOk), model.IsQCNeed ? "是":"否");
}
}
else
{
hProductId.Value = Guid.Empty.ToString();
hPackageId.Value = Guid.Empty.ToString();
bc.BindDdl(ddlOrderReceiptStatus, typeof(EnumData.EnumReceiptOrderStatus), EnumData.EnumReceiptOrderStatus.新建.ToString());
bc.BindDdl(ddlUnit, typeof(EnumData.EnumUnitLevel), "");
bc.BindDdl(ddlIsOk, typeof(EnumData.EnumIsOk), "");
}
}
private void BindData(CronExpressionEntity cronExp)
{
//绑定执行一次 小时下拉列表
BindControl.BindComboBox(cbxHour, Common.DigitalHours(), cronExp != null ? cronExp.Hour :"");
//绑定执行一次 分下拉列表
BindControl.BindComboBox(cbxMinute, Common.DigitalMinutes(), cronExp != null ? cronExp.Minute:"");
//绑定复选框组
BindControl.BindCheckedListBox(chklstMonths, Common.DigitalMonths(), cronExp != null ? cronExp.SelectedTimestamp:"");
if (cronExp != null && chklstMonths.CheckedItems.Count > 0)
{
BindMonthsToListBox();
}
}
private void BindCtr()
{
BindControl bc = new BindControl();
if (!string.IsNullOrWhiteSpace(Request.QueryString["isBack"]))
{
bc.BindDdl(ddlSIsBack, typeof(EnumData.EnumIsOk), Request.QueryString["isBack"] == "1" ? "是" : "否");
}
else
{
bc.BindDdl(ddlSIsBack, typeof(EnumData.EnumIsOk), "");
}
bc.BindDdl(ddlSWhetherFix, typeof(EnumData.EnumWhetherFix), Request.QueryString["whetherFix"]);
}
private void College_Logo(HttpContext context)
{
int OrgID = Convert.ToInt32(context.Request.QueryString["OrgID"]);
BindControl ObjBind = new BindControl();
DataSet ds = new DataSet();
string[] parmaList = new string[4];
parmaList[0] = "@Action";
parmaList[1] = "GetCollegeLogo";
parmaList[2] = "@OrgID";
parmaList[3] = Convert.ToString(OrgID);
ds = ObjBind.FillControl(parmaList, "SelectCollegeImage");
context.Response.BinaryWrite((Byte[])ds.Tables[0].Rows[0][0]);
context.Response.End();
}
private void BindlstReecntTimes()
{
BindControl.BindListBox(lstRecentTimes, new List <KVEntity>());
if (cbxHour.SelectedIndex == 0 || cbxMinute.SelectedIndex == 0 || chklstMonths.CheckedItems.Count == 0)
{
return;
}
string cronString = QuartzHelper.GenerateCronExpression(_cronExpressionEntity);
List <DateTime> list = QuartzHelper.GetNextFireTime(cronString, 8);
List <KVEntity> kvList = list.Select(item => new KVEntity {
K = item.ToString(), V = item.ToString()
}).ToList();
BindControl.BindListBox(lstRecentTimes, kvList);
}
private void PreviewPalnExcuteTimeFrm_Load(object sender, EventArgs e)
{
try
{
lblTaskName.Text = _TaskName;
List <DateTime> dateTimeList = QuartzHelper.GetNextFireTime(_CronString, 50);
List <KVEntity> list = dateTimeList.Select(item => new KVEntity {
K = item.ToString("yyyy-MM-dd HH:mm:ss")
}).ToList();
BindControl.BindListBox(lstList, list);
}
catch (Exception ex)
{
base.ShowErrorMessage($"Cron表达解析错误，错误信息：[{ex.Message}]");
}
}
private void Bind()
{
BindControl bc = new BindControl();
Guid Id = Guid.Empty;
if (!string.IsNullOrWhiteSpace(Request.QueryString["Id"]))
{
Guid.TryParse(Request.QueryString["Id"], out Id);
}
if (!Id.Equals(Guid.Empty))
{
var bll = new InfoneDeviceRepairRecord();
var model = bll.GetModel(Id);
if (model != null)
{
hId.Value = model.Id.ToString();
txtRecordDate.Value = model.RecordDate.ToString("yyyy-MM-dd").Replace("1754-01-01", "");
txtCustomer.Value = model.Customer;
txtSerialNumber.Value = model.SerialNumber;
txtDeviceModel.Value = model.DeviceModel;
txtFaultCause.Value = model.FaultCause;
txtSolveMethod.Value = model.SolveMethod;
txtCustomerProblem.Value = model.CustomerProblem;
txtDevicePart.Value = model.DevicePart;
txtTreatmentSituation.Value = model.TreatmentSituation;
txtHandoverPerson.Value = model.HandoverPerson;
txtBackDate.Value = model.BackDate.ToString("yyyy-MM-dd").Replace("1754-01-01", "");
txtRegisteredPerson.Value = model.RegisteredPerson;
txtRemark.Value = model.Remark;
bc.BindDdl(ddlIsBack, typeof(EnumData.EnumIsOk), model.IsBack ? "是" : "否", "");
bc.BindDdl(ddlWhetherFix, typeof(EnumData.EnumWhetherFix), model.WhetherFix, "");
}
}
else
{
bc.BindDdl(ddlIsBack, typeof(EnumData.EnumIsOk), "", "");
bc.BindDdl(ddlWhetherFix, typeof(EnumData.EnumWhetherFix), "", "");
}
}
public ActionResult ProductConsultEdit()
{
this.ViewData["texOtype"] = RequestBase.GetString("otype");
BindControl bc = new BindControl();
ViewData["IsHasFunRole"] = Rolemanager.IsHasFunRole(EmployeeBase.e_ID, "001001001");//是否拥有管理的权限
Model.vm_PCdetails model = new Model.vm_PCdetails();
string ids = RequestBase.GetString("dli_id");
ViewData["hfPId"] = ids;
int id = int.Parse(ids.Split('|')[0]);
model = vmbll.GetModel(id);
ViewData["consulttime"] = model.pc_CreatedOn;
ViewData["pc_id"] = model.pc_ID;
List<Model.ProductReplyBase> prmodel = new BLL.ProductReplyBase().GetModelList(" pc_id=" + model.pc_ID);
if (prmodel != null && prmodel.Count > 0)
{
ViewData["prContent"] = prmodel[0].pr_Content;
ViewData["pr_id"] = prmodel[0].pr_ID;
}
return View(model);
}
private void BindData()
{
//1绑定数据类型
BindControl.BindComboBox(cbxDataTypes, Common.DataTypeList(), _TaskEntity != null ? ((int)_TaskEntity.DataType).ToString() : "");
//2绑定数据库类型
BindControl.BindComboBox(cbxDataBaseType, Common.DbTypeList(), _TaskEntity != null ? _TaskEntity.DataHandler : "");
//3绑定执行计划
if (_TaskEntity == null)
{
//默认加载每天执行计划
rdoDay.Checked = true;
}
else
{
txtTaskName.Text = _TaskEntity.TaskName;
txtDbConn.Text = Common.DecryptData(_TaskEntity.DBConnectString_Hashed);
txtSql.Text = _TaskEntity.SQL;
if (_TaskEntity.CycleType == CycleTypes.D)
{
rdoDay.Checked = true;
}
else if (_TaskEntity.CycleType == CycleTypes.W)
{
rdoWeek.Checked = true;
}
else if (_TaskEntity.CycleType == CycleTypes.M)
{
rdoMonth.Checked = true;
}
else
{
rdoDay.Checked = true;
}
}
}
private void BindData(CronExpressionEntity cronExp)
{
//绑定执行一次 小时下拉列表
BindControl.BindComboBox(cbxOneTimesHour, Common.DigitalHours());
//绑定执行一次 分下拉列表
BindControl.BindComboBox(cbxOneTimesMinute, Common.DigitalMinutes());
//绑定执行多次 分下拉列表
BindControl.BindComboBox(cbxMultiTimesMinute, Common.DigitalMultiTimesMinutes());
if (cronExp != null)
{
if (cronExp.ExecutingOnce)
{
cbxOneTimesHour.SelectedValue = cronExp.Hour;
cbxOneTimesMinute.SelectedValue = cronExp.Minute;
rdoOneTimes.Checked = true;
}
else
{
if (cronExp.Minute != "0")
{
cbxMultiTimesMinute.SelectedValue = cronExp.Minute;
}
if (cronExp.Hour != "*" && cronExp.Hour != "0")
{
cbxMultiTimesMinute.SelectedValue = cronExp.Hour;
}
rdoMultiTimes.Checked = true;
}
}
else
{
rdoOneTimes.Checked = true;
}
}
public ActionResult ProductAttrEdit()
{
this.ViewData["texOtype"] = RequestBase.GetString("otype");
BindControl bc = new BindControl();
ViewData["IsHasFunRole"] = Rolemanager.IsHasFunRole(EmployeeBase.e_ID, "001001001");//是否拥有管理的权限
Model.ProductAttributeDetails model = new Model.ProductAttributeDetails();
Model.ProductAttributesBase pabmodel = new Model.ProductAttributesBase();
List<SelectListItem> selectattrType = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "0" }, new SelectListItem { Text = "属性", Value = "1" }, new SelectListItem { Text = "规格", Value = "2" }, new SelectListItem { Text = "颜色", Value = "3" } };
ViewData["selectattrType"] = new SelectList(selectattrType, "Value", "Text");
List<SelectListItem> attribute = new List<SelectListItem>();
attribute = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = null }, new SelectListItem { Text = "ww", Value = "40" } };
ViewData["attribute"] = new SelectList(attribute, "Value", "Text", "请选择");
List<SelectListItem> attrValue = new List<SelectListItem>();
attrValue = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = null } };
ViewData["attrValue"] = new SelectList(attrValue, "Value", "Text", "请选择");
if (RequestBase.GetString("otype") == "modify")
{
string ids = RequestBase.GetString("dli_id");
ViewData["hfPId"] = ids;
attrpaid = ids.Split('|')[0];//pa_id
int skuid = int.Parse(ids.Split('|')[1]);//sku_ID
int pid = int.Parse(ids.Split('|')[2]);//p_ID
pabmodel = patbll.GetModel(int.Parse(attrpaid));
paid = pabmodel.pa_Type.ToString();
parentpaid = pabmodel.pa_ParentId.ToString();
ViewData["paid"] = paid;
ViewData["parentpaid"] = parentpaid;
ViewData["attrpaid"] = attrpaid;
ViewData["selectattrType"] = new SelectList(selectattrType, "Value", "Text", paid);
List<Model.ProductAttributesBase> modelType = patbll.GetModelList(" pa_type = " + paid+" and pa_parentId=0");
for (int i = 0; i < modelType.Count; i++)
{
attribute.Add(new SelectListItem
{
Value = modelType[i].pa_ID.ToString(),
Text = modelType[i].pa_Name
});
}
ViewData["attribute"] = new SelectList(attribute, "Value", "Text", parentpaid);
List<Model.ProductAttributesBase> modelType2 = patbll.GetModelList(" pa_parentId = " + parentpaid);
for (int i = 0; i < modelType2.Count; i++)
{
attrValue.Add(new SelectListItem
{
Value = modelType2[i].pa_ID.ToString(),
Text = modelType2[i].pa_Name
});
}
ViewData["attrValue"] = new SelectList(attrValue, "Value", "Text", attrpaid);
return View();
}
else
{
string pids = RequestBase.GetString("dli_id");
ViewData["hfPId"] = pids;
return View();
}
}
// ADD_DATA TO Form For Update
#region ADD_DATA For Update
private void BindOrganizationData(int OrgID)
{
try
{
string[] prmList = null;
BindControl ObjHelper = new BindControl();
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "SelectData";
prmList[2] = "@OrgID";
prmList[3] = Convert.ToString(OrgID);
DataSet dsCode = ObjHelper.FillControl(prmList, "SP_CollegeRegistration");
if (dsCode.Tables[0].Rows.Count > 0)
{
TxtOrgID.Text = dsCode.Tables[0].Rows[0][0].ToString();
TxtOrgName.Text = dsCode.Tables[0].Rows[0][1].ToString();
TxtOrgCode.Text = dsCode.Tables[0].Rows[0][2].ToString();
rbl_OrganizationType.SelectedValue = dsCode.Tables[0].Rows[0][4].ToString();
TxtTrustName.Text = dsCode.Tables[0].Rows[0][5].ToString();
string University = dsCode.Tables[0].Rows[0][3].ToString();
if (University != null && University != "")
{
DDL_University.SelectedValue = University;
}
//int OrgType = Convert.ToInt16(dsCode.Tables[0].Rows[0][4]);
//rbl_OrganizationType.ClearSelection();
//if (OrgType == 0)
//{
// rbl_OrganizationType.Items.FindByText("College").Selected = true;
//}
//else
// rbl_OrganizationType.Items.FindByText("School").Selected = true;
TxtOrgLabel.Text = dsCode.Tables[0].Rows[0][5].ToString();
TxtTrustName.Text = dsCode.Tables[0].Rows[0][6].ToString();
TxtPhoneNo.Text = dsCode.Tables[0].Rows[0][7].ToString();
TxtFax.Text = dsCode.Tables[0].Rows[0][8].ToString();
Txtwebsite.Text = dsCode.Tables[0].Rows[0][10].ToString();
TxtEmail.Text = dsCode.Tables[0].Rows[0][11].ToString();
TxtAddress.Text = dsCode.Tables[0].Rows[0][12].ToString();
string country = db.getDbstatus_Value("select Country from tblOrganization where OrganizationId ='" + Convert.ToInt32(Session["OrgId"]) + "' ");
DDL_Country.SelectedItem.Text = country.ToString();
string State = db.getDbstatus_Value("select State from tblOrganization where OrganizationId ='" + Convert.ToInt32(Session["OrgId"]) + "' ");
DDL_State.SelectedItem.Text = State.ToString();
string city = db.getDbstatus_Value("select City from tblOrganization where OrganizationId ='" + Convert.ToInt32(Session["OrgId"]) + "' ");
DDL_City.SelectedItem.Text = city.ToString();
TxtPincode.Text = dsCode.Tables[0].Rows[0][16].ToString();
TxtUniversityCode.Text = dsCode.Tables[0].Rows[0][17].ToString();
TxtMSBTEcode.Text = dsCode.Tables[0].Rows[0][18].ToString();
TxtAICTECode.Text = dsCode.Tables[0].Rows[0][19].ToString();
TxtDTEcode.Text = dsCode.Tables[0].Rows[0][20].ToString();
string Logo = dsCode.Tables[0].Rows[0]["Logo"].ToString();
if (Logo != null && Logo != "")
{
Byte[] bytes = (Byte[])dsCode.Tables[0].Rows[0]["Logo"];
string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
ViewState["Logo"] = bytes;
}
string LetterHead = dsCode.Tables[0].Rows[0]["LetterHead"].ToString();
if (LetterHead != null && LetterHead != "")
{
Byte[] bytes = (Byte[])dsCode.Tables[0].Rows[0]["LetterHead"];
string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
ViewState["LetterHead"] = bytes;
}
}
}
catch (Exception exp)
{
//GeneralErr(exp.Message.ToString());
}
}
public ActionResult ProductsEdit()
{
this.ViewData["texOtype"] = RequestBase.GetString("otype");
BindControl bc = new BindControl();
ViewData["IsHasFunRole"] = Rolemanager.IsHasFunRole(EmployeeBase.e_ID, "001001001");//是否拥有管理的权限
Model.ProductBase model = new Model.ProductBase();
Model.RegionBase regmodel = new Model.RegionBase();
#region 运费模板下拉菜单
BLL.CarriageTempleteBase pctbll = new BLL.CarriageTempleteBase();
List<Model.CarriageTempleteBase> carmodel = pctbll.GetModelList(" ct_IsDel=0 and ct_StatusCode=0 ");
List<SelectListItem> carriageTemplete = new List<SelectListItem>();
carriageTemplete = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } };
for (int i = 0; i < carmodel.Count; i++)
{
carriageTemplete.Add(new SelectListItem
{
Value = carmodel[i].ct_ID.ToString(),
Text = carmodel[i].ct_Name
});
}
ViewData["carriageTemplete"] = new SelectList(carriageTemplete, "Value", "Text", "请选择");
#endregion
#region 商品分类 下拉菜单
BLL.ProductTypeBase ptbll = new BLL.ProductTypeBase();
List<Model.ProductTypeBase> modelType = ptbll.GetModelList(" pt_parentId = 0 and pt_IsDel=0 and pt_StatusCode=0");
List<SelectListItem> pType = new List<SelectListItem>();
pType = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } };
for (int i = 0; i < modelType.Count; i++)
{
pType.Add(new SelectListItem
{
Value = modelType[i].pt_ID.ToString(),
Text = modelType[i].pt_Name
});
}
ViewData["pType"] = new SelectList(pType, "Value", "Text", "请选择");
//中类
List<SelectListItem> zType = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } };
ViewData["zType"] = new SelectList(zType, "Value", "Text", "请选择");
#endregion
#region 地区信息下拉菜单
List<Model.RegionBase> Pregion = regbll.GetModelList(" reg_PId = 0");
List<SelectListItem> Province = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } };
for (int i = 0; i < Pregion.Count; i++)
{
Province.Add(new SelectListItem
{
Value = Pregion[i].reg_ID.ToString(),
Text = Pregion[i].reg_Name
});
}
ViewData["Province"] = new SelectList(Province, "Value", "Text", "请选择");
List<SelectListItem> City = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } };
ViewData["City"] = new SelectList(City, "Value", "Text", "请选择");
List<SelectListItem> Country = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } };
ViewData["Country"] = new SelectList(Country, "Value", "Text", "请选择");
List<SelectListItem> brandlist = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } };
ViewData["brands"] = new SelectList(brandlist, "Value", "Text", "请选择");
#endregion
if (RequestBase.GetString("otype") == "modify")
{
string ids = RequestBase.GetString("dli_id");
ViewData["hfPId"] = ids;
int id = int.Parse(ids.Split('|')[0]);
string typeid = ids.Split('|')[1];//类别ID
#region 修改时加载分类下拉列表
model = pbll.GetModel(id);
Model.ProductTypeBase modelm = ptbll.GetModel(int.Parse(typeid));//当前小类，它的父ID是大类ID,PID=208，大类ID是207
List<Model.ProductTypeBase> modelType2 = ptbll.GetModelList(" pt_parentId =0 " );//大类
List<Model.ProductTypeBase> modelType3 = ptbll.GetModelList(" pt_parentId = " + modelm.pt_ParentId);//小类
//加载大类的下拉菜单
for (int i = 0; i < modelType2.Count; i++)
{
pType.Add(new SelectListItem
{
Value = modelType2[i].pt_ID.ToString(),
Text = modelType2[i].pt_Name
});
}
ViewData["pType"] = new SelectList(pType, "Value", "Text", modelm.pt_ParentId);
//加载小类的下拉菜单
for (int i = 0; i < modelType3.Count; i++)
{
zType.Add(new SelectListItem
{
Value = modelType3[i].pt_ID.ToString(),
Text = modelType3[i].pt_Name
});
}
ViewData["zType"] = new SelectList(zType, "Value", "Text", modelm.pt_ID);
#endregion
#region 修改时加载地区下拉列表
regmodel = regbll.GetModel(model.p_Province);//43
Model.RegionBase citymodel = regbll.GetModel(model.p_City);//44
Model.RegionBase countrymodel = regbll.GetModel(model.p_County);//45
List<Model.RegionBase> model2 = regbll.GetModelList(" reg_PId = " + regmodel.reg_Code);//市
List<Model.RegionBase> model3 = regbll.GetModelList(" reg_PId = " + citymodel.reg_Code);//县
ViewData["Province"] = new SelectList(Province, "Value", "Text", regmodel.reg_ID);
//加载市的下拉菜单
for (int i = 0; i < model2.Count; i++)
{
City.Add(new SelectListItem
{
Value = model2[i].reg_ID.ToString(),
Text = model2[i].reg_Name
});
}
ViewData["City"] = new SelectList(City, "Value", "Text", citymodel.reg_ID);
//加载县的下拉菜单
for (int i = 0; i < model3.Count; i++)
{
Country.Add(new SelectListItem
{
Value = model3[i].reg_ID.ToString(),
Text = model3[i].reg_Name
});
}
ViewData["Country"] = new SelectList(Country, "Value", "Text", countrymodel.reg_ID);
#endregion
#region 修改时加载运费模板下拉列表
ViewData["carriageTemplete"] = new SelectList(carriageTemplete, "Value", "Text", model.ct_ID);
#endregion
#region 加载品牌下拉菜单
List<SelectListItem> selectbrand = new List<SelectListItem>();
List<Model.BrandBase> modelbrand = new BLL.BrandBase().GetModelList(" b_ID in (select b_ID from ProductTypeBrandBase where pt_ID=" + modelm.pt_ID + ")");
//加载品牌的下拉菜单
for (int i = 0; i < modelbrand.Count; i++)
{
selectbrand.Add(new SelectListItem
{
Value = modelbrand[i].b_ID.ToString(),
Text = modelbrand[i].b_Name
});
}
ViewData["brands"] = new SelectList(selectbrand, "Value", "Text",new BLL.ProductBase().GetModel(id).b_ID);
#endregion
return View(model);
}
else
{
string pids = RequestBase.GetString("dli_id");
ViewData["hfPId"] = pids;
return View();
}
}
//used for With binding
public BindControl Bind(System.Type type)
{
currentBindingChain = new BindControl(this, type);
return currentBindingChain;
}
private void Bind()
{
Guid Id = Guid.Empty;
if (!string.IsNullOrWhiteSpace(Request.QueryString["Id"]))
{
Guid.TryParse(Request.QueryString["Id"], out Id);
}
if (!Id.Equals(Guid.Empty))
{
Page.Title = "编辑库位";
var bll = new StockLocation();
var model = bll.GetModelByJoin(Id);
if (model != null)
{
hId.Value = model.Id.ToString();
hZoneId.Value = model.ZoneId.ToString();
txtCode.Value = model.Code;
txtName.Value = model.Named;
txtZone.Value = model.ZoneCode;
txtRow.Value = model.Row.ToString();
txtLayer.Value = model.Layer.ToString();
txtCol.Value = model.Col.ToString();
txtPassway.Value = model.Passway.ToString();
txtWidth.Value = model.Width.ToString();
txtWide.Value = model.Wide.ToString();
txtHigh.Value = model.High.ToString();
txtVolume.Value = model.Volume.ToString();
txtCubage.Value = model.Cubage.ToString();
txtStackLimit.Value = model.StackLimit.ToString();
txtCarryWeight.Value = model.CarryWeight.ToString();
txtX.Value = model.Xc.ToString();
txtY.Value = model.Yc.ToString();
txtZ.Value = model.Zc.ToString();
txtOrientation.Value = model.Orientation.ToString();
txtGroundTrayQty.Value = model.GroundTrayQty.ToString();
txtRouteSeq.Value = model.RouteSeq;
txtInsertTaskSeq.Value = model.InsertTaskSeq.ToString();
txtStatus.Value = model.Status;
txtWarehouse.Value = model.Warehouse;
txtLevelNum.Value = model.LevelNum.ToString();
txtPickArea.Value = model.PickArea;
txtInventoryGroupId.Value = model.InventoryGroupId.ToString();
txtPickMethod.Value = model.PickMethod;
BindControl bc = new BindControl();
bc.BindDdl(ddlIsMixPlace, typeof(EnumData.EnumIsOk), model.IsMixPlace.ToString());
bc.BindDdl(ddlIsBatchNum, typeof(EnumData.EnumIsOk), model.IsBatchNum.ToString());
bc.BindDdl(ddlIsLoseId, typeof(EnumData.EnumIsOk), model.IsLoseId.ToString());
bc.BindDdl(ddlStockLocationType, typeof(EnumData.EnumStockLocationType), model.StockLocationType);
bc.BindDdl(ddlCtrType, typeof(EnumData.EnumStockLocationCtrType), model.CtrType);
bc.BindDdl(ddlABC, typeof(EnumData.EnumAbc), model.ABC);
bc.BindDdl(ddlStockLocationDeal, typeof(EnumData.EnumStockLocationDeal), model.StockLocationDeal);
bc.BindDdl(ddlUseStatus, typeof(EnumData.EnumStockLocationUseStatus), model.UseStatus);
}
}
else
{
txtWidth.Value = "0.00000";
txtWide.Value = "0.00000";
txtHigh.Value = "0.00000";
txtVolume.Value = "0.00000";
txtCubage.Value = "0.00000";
txtRow.Value = "0.00000";
txtLayer.Value = "0.00000";
txtCol.Value = "0.00000";
txtPassway.Value = "0.00000";
txtX.Value = "0.00000";
txtY.Value = "0.00000";
txtZ.Value = "0.00000";
txtOrientation.Value = "0.00000";
txtStackLimit.Value = "0.00000";
txtGroundTrayQty.Value = "0.00000";
txtCarryWeight.Value = "0.00000";
txtLevelNum.Value = "0.00000";
txtInsertTaskSeq.Value = "0.00000";
txtInventoryGroupId.Value = "0.00000";
BindControl bc = new BindControl();
bc.BindDdl(ddlIsMixPlace, typeof(EnumData.EnumIsOk), "");
bc.BindDdl(ddlIsBatchNum, typeof(EnumData.EnumIsOk), "");
bc.BindDdl(ddlIsLoseId, typeof(EnumData.EnumIsOk), "");
bc.BindDdl(ddlStockLocationType, typeof(EnumData.EnumStockLocationType), "", "");
bc.BindDdl(ddlCtrType, typeof(EnumData.EnumStockLocationCtrType), "", EnumData.EnumStockLocationCtrType.常规存储.ToString());
bc.BindDdl(ddlABC, typeof(EnumData.EnumAbc), "", "");
bc.BindDdl(ddlStockLocationDeal, typeof(EnumData.EnumStockLocationDeal), "", "");
bc.BindDdl(ddlUseStatus, typeof(EnumData.EnumStockLocationUseStatus), "", "");
}
}
// Bind Country To DDL_Country
//#region LoadCountryDropDown
//private void LoadCountryDropDown()
//{
// try
// {
// DDL_Country.DataTextField = "name";
// DDL_Country.DataValueField = "id";
// DataSet ds = ViewState["DatasetAll"] as DataSet;
// DDL_Country.DataSource = ds.Tables["Country"];
// DDL_Country.DataBind();
// DDL_Country.Items.Insert(0, new ListItem(" Select ", "0"));
// }
// catch (Exception exp)
// {
// GeneralErr(exp.Message.ToString());
// }
//}
//#endregion
// ADD_DATA TO Form For Update
#region ADD_DATA For Update
protected void DDL_SelectCollege_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
string collegeName = DDL_SelectCollege.SelectedValue.ToString();
string[] prmList = null;
BindControl ObjHelper = new BindControl();
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "SelectData";
prmList[2] = "@OrgID";
prmList[3] = DDL_SelectCollege.SelectedValue.ToString();
DataSet dsCode = ObjHelper.FillControl(prmList, "SP_CollegeRegistration");
if (dsCode.Tables[0].Rows.Count > 0)
{
TxtOrgID.Text = dsCode.Tables[0].Rows[0][0].ToString();
TxtOrgName.Text = dsCode.Tables[0].Rows[0][1].ToString();
TxtOrgCode.Text = dsCode.Tables[0].Rows[0][2].ToString();
string University = dsCode.Tables[0].Rows[0][3].ToString();
if (University != "0")
{
if (University != null && University != "")
{
string univercityName = db.getDbstatus_Value("select UniversityName from tblUniversity where UniversityId='" + University.ToString() + "'");
DDL_University.SelectedValue = University;
}
}
int OrgType = Convert.ToInt16(dsCode.Tables[0].Rows[0][4]);
rbl_OrganizationType.ClearSelection();
if (OrgType == 0)
{
rbl_OrganizationType.Items.FindByText("College").Selected = true;
}
else
{
rbl_OrganizationType.Items.FindByText("School").Selected = true;
}
TxtOrgLabel.Text = dsCode.Tables[0].Rows[0][5].ToString();
TxtTrustName.Text = dsCode.Tables[0].Rows[0][6].ToString();
TxtPhoneNo.Text = dsCode.Tables[0].Rows[0][7].ToString();
TxtFax.Text = dsCode.Tables[0].Rows[0][8].ToString();
Txtwebsite.Text = dsCode.Tables[0].Rows[0][10].ToString();
TxtEmail.Text = dsCode.Tables[0].Rows[0][11].ToString();
TxtAddress.Text = dsCode.Tables[0].Rows[0][12].ToString();
string country = db.getDbstatus_Value("select Country from tblOrganization where OrganizationId='" + TxtOrgID.Text + "'");
ddlcountry.ClearSelection();
float abc = db.getDb_Value("select CountryId from Country where County='" + country.ToString() + "' ");
ddlcountry.SelectedValue = abc.ToString();
string sta = db.getDbstatus_Value("select State from tblOrganization where OrganizationId='" + TxtOrgID.Text + "'");
ddlstate.ClearSelection();
Bind_ddlState1();
float pqr = db.getDb_Value("select StateId from countryState where State='" + sta.ToString() + "'");
ddlstate.SelectedValue = pqr.ToString();
string ci = db.getDbstatus_Value("select City from tblOrganization where OrganizationId='" + TxtOrgID.Text + "'");
ddlcity.ClearSelection();
Bind_ddlCity1();
float xyz = db.getDb_Value("select DistrictId from tblDistrict where District='" + ci.ToString() + "'");
ddlcity.SelectedValue = xyz.ToString();
TxtPincode.Text = dsCode.Tables[0].Rows[0][16].ToString();
TxtUniversityCode.Text = dsCode.Tables[0].Rows[0][17].ToString();
TxtMSBTEcode.Text = dsCode.Tables[0].Rows[0][18].ToString();
TxtAICTECode.Text = dsCode.Tables[0].Rows[0][19].ToString();
TxtDTEcode.Text = dsCode.Tables[0].Rows[0][20].ToString();
string Photo = dsCode.Tables[0].Rows[0]["Logo"].ToString();
if (Photo != "0" && Photo != "")
{
Byte[] bytes = (Byte[])dsCode.Tables[0].Rows[0]["Logo"];
string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
ViewState["Logo"] = bytes;
}
Photo = dsCode.Tables[0].Rows[0]["LetterHead"].ToString();
if (Photo != "0" && Photo != "")
{
Byte[] bytes = (Byte[])dsCode.Tables[0].Rows[0]["LetterHead"];
string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
ViewState["LetterHead"] = bytes;
}
}
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
//used for With binding
public BindControl Bind(System.Type type)
{
currentBindingChain = new BindControl(this, type);
return(currentBindingChain);
}
public ActionResult ProductinfoEdit()
{
this.ViewData["texOtype"] = RequestBase.GetString("otype");
BindControl bc = new BindControl();
ViewData["IsHasFunRole"] = Rolemanager.IsHasFunRole(EmployeeBase.e_ID, "001001001");//是否拥有管理的权限
Model.ProductInfoBase model = new Model.ProductInfoBase();
List<SelectListItem> infoType = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" }, new SelectListItem { Text = "商品推荐", Value = "1" }, new SelectListItem { Text = "商品介绍", Value = "2" } };
ViewData["infoType"] = new SelectList(infoType, "Value", "Text");
if (RequestBase.GetString("otype") == "modify")
{
string ids = RequestBase.GetString("dli_id");
string id = ids.Split('|')[0];
int ptid = int.Parse(id);
model = pibll.GetModel(ptid);
if(model.pin_Type=="商品推荐")
{
ViewData["infoType"] = new SelectList(infoType, "Value", "Text",1);
}
else if(model.pin_Type=="商品介绍")
{
ViewData["infoType"] = new SelectList(infoType, "Value", "Text",2);
}
return View(model);
}
else
{
string pids = RequestBase.GetString("dli_id");
ViewData["hfPId"] = pids;
return View();
}
}
public ActionResult ProductImgEdit()
{
Model.ProductImgBase pimodel = new Model.ProductImgBase();
this.ViewData["texOtype"] = RequestBase.GetString("otype");
ViewData["hf_luj"] = ConfigurationManager.AppSettings["SaveImage"];//图片的存储路径
BindControl bc = new BindControl();
ViewData["IsHasFunRole"] = Rolemanager.IsHasFunRole(EmployeeBase.e_ID, "001001001");//是否拥有管理的权限
List<SelectListItem> ImgType = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" }, new SelectListItem { Text = "封面", Value = "1" }, new SelectListItem { Text = "非封面", Value = "0" } };
ViewData["ImgType"] = new SelectList(ImgType, "Value", "Text");
if (RequestBase.GetString("otype") == "modify")
{
string ids = RequestBase.GetString("dli_id");
ViewData["hfPId"] = ids;
int piid = int.Parse(ids.Split('|')[0]);//图片ID
int skuid = int.Parse(ids.Split('|')[1]);
bool typeid = bool.Parse(ids.Split('|')[2]);//图片类别
pimodel = pingbll.GetModel(piid);
ViewData["LogoUrl"] = pimodel.pi_Url;
if (bool.Parse(ids.Split('|')[2]))
{
ViewData["ImgType"] = new SelectList(ImgType, "Value", "Text",1);
}
else
{
ViewData["ImgType"] = new SelectList(ImgType, "Value", "Text", 0);
}
return View(pimodel);
}
else
{
string pids = RequestBase.GetString("dli_id");
ViewData["hfPId"] = pids;
return View();
}
}
public ActionResult ProductSEOEdit()
{
this.ViewData["texOtype"] = RequestBase.GetString("otype");
BindControl bc = new BindControl();
ViewData["IsHasFunRole"] = Rolemanager.IsHasFunRole(EmployeeBase.e_ID, "001001001");//是否拥有管理的权限
if (RequestBase.GetString("otype") == "modify")
{
Model.ProductSEOBase model = new Model.ProductSEOBase();
string ids = RequestBase.GetString("dli_id");
ViewData["hfPId"] = ids;
string id = ids.Split('|')[0];
int ptid = int.Parse(id);
var seo = new BLL.ProductSEOBase().GetModelList(" p_ID=" + ptid);
model = seo[0];
return View(model);
}
else
{
string pids = RequestBase.GetString("dli_id");//1|9|1
int ptid = int.Parse(pids.Split('|')[0]);//商品ID
BLL.ProductSEOBase seobll = new BLL.ProductSEOBase();
var seo = new BLL.ProductSEOBase().GetModelList(" p_ID=" + ptid);
if (seo.Count>0)
{
return Content(DWZUtil.GetResultJson("300", "该商品已存在SEO信息，请选择修改！！", "", "", ""));
}
else
{
ViewData["hfPId"] = pids;
return View();
}
}
}
public ActionResult ProductSKUEdit()
{
this.ViewData["texOtype"] = RequestBase.GetString("otype");
BindControl bc = new BindControl();
ViewData["IsHasFunRole"] = Rolemanager.IsHasFunRole(EmployeeBase.e_ID, "001001001");//是否拥有管理的权限
Model.SKUBase model = new Model.SKUBase();
if (RequestBase.GetString("otype") == "modify")
{
string ids = RequestBase.GetString("dli_id");
string id = ids.Split('|')[0];
int ptid = int.Parse(id);
model = psbll.GetModel(ptid);
return View(model);
}
else
{
string pids = RequestBase.GetString("dli_id");
ViewData["hfPId"] = pids;
return View();
}
}
