130 lines
5.4 KiB
C#
130 lines
5.4 KiB
C#
using System;
|
||
using System.Configuration;
|
||
using System.Data;
|
||
using System.Web.UI;
|
||
using SuperMap.RealEstate.CoreFrameWork;
|
||
using SuperMap.RealEstate.Web.UI;
|
||
using SuperMap.RealEstate.Web.UI.WebControls;
|
||
using Business = SuperMap.RealEstate.HighWay.Storage.Business;
|
||
using HZQR.Common;
|
||
|
||
namespace SuperMap.RealEstate.HighWay.CloudModule.CommoditySearch
|
||
{
|
||
/// <summary>
|
||
/// T_COMMODITY_商品管理 的WebUserControl
|
||
/// <summary>
|
||
public partial class COMMODITY : Storage.UI.UserControlsEx<Business.COMMODITY>
|
||
{
|
||
protected void Page_Load(object sender, EventArgs e)
|
||
{
|
||
if (IsPostBack) return;
|
||
|
||
//绑定自定义类
|
||
USERDEFINEDTYPE_ID.Clear();
|
||
new Storage.Business.USERDEFINEDTYPE(Transaction).BindingDropDownList(
|
||
USERDEFINEDTYPE_ID.Items, "", SERVERPART_ID.SelectedValue.TryParseToInt());
|
||
if (CurrObject.USERDEFINEDTYPE_ID != null)
|
||
{
|
||
USERDEFINEDTYPE_ID.SelectedValue = CurrObject.USERDEFINEDTYPE_ID.ToString();
|
||
}
|
||
}
|
||
|
||
//在此加入界面的数据初始化(Page_Load之前)，如DropDownList的数据源绑定等
|
||
public override void InitializeWebControl()
|
||
{
|
||
//绑定下拉框
|
||
COMMODITY_GRADE.Clear();
|
||
DictionaryHelper.BindingDropDownList("COMMODITYGRADE", COMMODITY_GRADE.Items, this.Transaction);
|
||
//是否有效
|
||
COMMODITY_STATE.Clear();
|
||
DictionaryHelper.BindingDropDownList("COMMODITYSTATE", COMMODITY_STATE.Items, this.Transaction);
|
||
//能否销售
|
||
CANSALE.Clear();
|
||
DictionaryHelper.BindingDropDownList("ISBULK", CANSALE.Items, this.Transaction);
|
||
//是否散称
|
||
ISBULK.Clear();
|
||
DictionaryHelper.BindingDropDownList("ISBULK", ISBULK.Items, this.Transaction);
|
||
//绑定称重方式
|
||
METERINGMETHOD.Clear();
|
||
DictionaryHelper.BindingDropDownList("METERINGMETHOD", METERINGMETHOD.Items, this.Transaction);
|
||
//业态
|
||
BUSINESSTYPE.Clear();
|
||
DictionaryHelper.BindingDropDownList("BUSINESSTYPE", BUSINESSTYPE.Items, this.Transaction);
|
||
}
|
||
|
||
|
||
//载入数据
|
||
public override bool LoadData()
|
||
{
|
||
//加载对应的信息
|
||
ADDTIME.Text = System.DateTime.Now.ToString();
|
||
BindDropDownList_SERVERPART();
|
||
LoadRTCommodityType(GoodsProvinceCode);
|
||
//如果是工作流组件请自行修改载入的逻辑，以下是功能模块的默认代码
|
||
if (!String.IsNullOrEmpty(Request["ID"]))
|
||
{
|
||
CurrObject.COMMODITY_ID_Encrypt = Request["ID"];
|
||
return this.Select(GoodsProvinceCode);
|
||
}
|
||
//默认返回值，工作流组件返回True,功能模块返回False。
|
||
return (WorkFlowPage != null);
|
||
}
|
||
|
||
#region 方法 -> 加载服务区下拉框【根据用户信息】
|
||
public void BindDropDownList_SERVERPART(int COMMODITY_ID = 0)
|
||
{
|
||
SERVERPART_ID.Items.Clear();
|
||
foreach (Business.SERVERPART _SERVERPART in new Business.SERVERPART(Transaction).GetPassportServerPart(Page.PassportInfo.CityAuthority))
|
||
{
|
||
ListItemEx _ListItemEx = new ListItemEx();
|
||
_ListItemEx.Value = _SERVERPART.SERVERPART_ID.ToString();
|
||
_ListItemEx.Text = _SERVERPART.SERVERPART_NAME;
|
||
SERVERPART_ID.Items.Add(_ListItemEx);
|
||
}
|
||
}
|
||
#endregion
|
||
|
||
#region 方法 -> 加载商品列表类型
|
||
public void LoadRTCommodityType(string ProvinceCode)
|
||
{
|
||
COMMODITY_TYPE.Items.Clear();
|
||
Storage.Business.COMMODITYTYPE _COMMODITYTYPE = new Storage.Business.COMMODITYTYPE(this.Transaction);
|
||
if (!string.IsNullOrWhiteSpace(ProvinceCode))
|
||
{
|
||
_COMMODITYTYPE.BindingDropDownList(COMMODITY_TYPE.Items, "", false,
|
||
false, false, true, false, int.Parse(ProvinceCode.Trim('_')));
|
||
}
|
||
else
|
||
{
|
||
_COMMODITYTYPE.BindingDropDownList(COMMODITY_TYPE.Items, "", false);
|
||
}
|
||
}
|
||
#endregion
|
||
|
||
#region 方法 -> 更新进销存业务数据
|
||
public bool UpdateInSalesDatas()
|
||
{
|
||
bool UpdateFlag = false;
|
||
|
||
if (!string.IsNullOrWhiteSpace(WholeServerpartID) && WholeServerpartID != "0")
|
||
{
|
||
DataTable dtCOMMODITY = new Business.COMMODITY(Transaction).ExecuteDataTable(string.Format(@"
|
||
SELECT WM_CONCAT(COMMODITY_ID)
|
||
FROM HIGHWAY_STORAGE.V_WHOLE_COMMODITY
|
||
WHERE COMMODITY_BARCODE = '{0}' AND SERVERPART_ID = {1} AND
|
||
PROVINCE_CODE = {2} AND BUSINESSTYPE = {3}",
|
||
COMMODITY_BARCODE.Text.Trim(), WholeServerpartID, PROVINCE_CODE.Text, BUSINESSTYPE.SelectedValue));
|
||
if (dtCOMMODITY.Rows.Count > 0 && dtCOMMODITY.Rows[0][0].ToString() != "")
|
||
{
|
||
new Business.COMMODITY(Transaction).UpdateInSalesData(Transaction, dtCOMMODITY.Rows[0][0].ToString(),
|
||
COMMODITY_ID.Text.TryParseToInt(), COMMODITY_CODE.Text, GoodsProvinceCode, SERVERPART_ID.SelectedValue);
|
||
UpdateFlag = true;
|
||
}
|
||
}
|
||
|
||
return UpdateFlag;
|
||
}
|
||
#endregion
|
||
}
|
||
}
|