/// <summary>
/// 签收
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSing_Click(object sender, EventArgs e)
{
Hi.Model.DIS_Order OrderModel = OrderBll.GetModel(KeyID);
if (OrderModel.OState == (int)Enums.OrderState.已发货 && OrderModel.ReturnState == (int)Enums.ReturnState.未退货)
{
Hi.Model.DIS_OrderOut OutModel = new Hi.BLL.DIS_OrderOut().GetOutModel(KeyID);
OutModel.SignDate = DateTime.Now;
OutModel.SignRemark = "";
OutModel.SignUser = Common.GetUserName(this.UserID);
OutModel.SignUserId = this.UserID;
OutModel.IsSign = 1;
OutModel.ts = DateTime.Now;
OutModel.modifyuser = this.UserID;
if (OrderInfoType.SignOrder(OutModel, OrderModel) > 0)
{
Utils.AddSysBusinessLog(this.CompID, "Order", KeyID.ToString(), "订单签收", "");
new Common().GetWxService("3", KeyID.ToString(), "1");
if (!string.IsNullOrEmpty(Request["type1"]) && Request["type1"].ToString() == "ReceivingList")
{
Response.Redirect("receivinglist.aspx");
}
Response.Redirect("neworder/orderdetail.aspx?KeyID=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey));
//Bind();
}
}
}
protected void btn_Use(object sender, EventArgs e)
{
Hi.Model.BD_Distributor Dis = new Hi.BLL.BD_Distributor().GetModel(KeyID);
if (Dis != null)
{
List <Hi.Model.SYS_CompUser> luser = new Hi.BLL.SYS_CompUser().GetList("", " dr=0 and DisID=" + KeyID + " and Utype in (1,5) and Ctype=2 and CompID=" + this.CompID, "");
foreach (Hi.Model.SYS_CompUser model in luser)
{
model.IsEnabled = 1;
model.ts = DateTime.Now;
model.modifyuser = Common.UserID();
new Hi.BLL.SYS_CompUser().Update(model);
}
if (Request["nextstep"] + "" == "1")
{
Response.Redirect("DisList.aspx?nextstep=1");
}
else
{
Response.Redirect("DisInfo.aspx?KeyID=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey) + "&type=2");
}
}
}
/// <summary>
/// 审核
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAudit_Click(object sender, EventArgs e)
{
Hi.Model.DIS_Order OrderInfoModel = OrderInfoBll.GetModel(KeyID);
if (OrderInfoModel != null)
{
if (OrderInfoModel.OState == (int)Enums.OrderState.待审核)
{
string sql = " update [DIS_Order] set [OState]=" + (int)Enums.OrderState.已审 + " where ID=" + KeyID;
if (OrderInfoBll.UpdateOrderState(sql))
{
Utils.AddSysBusinessLog(this.CompID, "Order", KeyID.ToString(), "审核通过", "");
Bind();
}
}
else
{
JScript.AlertMsgOne(this, "数据状态不正确,不能进行审核!", JScript.IconOption.错误, 2500);
}
}
else
{
JScript.AlertMsgOne(this, "数据不存在", JScript.IconOption.错误, 2500);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (KeyID != 0)
{
try
{
Hi.Model.BD_DisPrice model = new Hi.BLL.BD_DisPrice().GetModel(KeyID);
if (model != null)
{
//this.lblDisTitle.InnerText = model.Title.ToString();
//this.lblDisID.InnerText = model.DisNames.ToString();
//this.txtRemark.Value = model.Remark;
}
Bind(KeyID.ToString());
}
catch (Exception ex)
{
JScript.AlertMethod(this.Page, "数据有误", JScript.IconOption.错误, "function(){location.href='GoodsPriceList.aspx';}");
return;
}
}
}
}
protected void A_EditIcon(object sender, EventArgs e)
{
Hi.Model.SYS_Users User = new Hi.BLL.SYS_Users().GetModel(this.UserName);
orderreturn.ReturnState = (int)Enums.AuditState.提交;
orderreturn.ReturnDate = DateTime.Now;
orderreturn.ReturnUserID = User.ID;
orderreturn.ts = DateTime.Now;
orderreturn.modifyuser = User.ID;
if (new Hi.BLL.DIS_OrderReturn().Update(orderreturn))
{
order.ReturnState = (int)Enums.ReturnState.申请退货;
order.ReturnMoneyUser = User.TrueName;
order.ReturnMoneyUserId = User.ID;
order.ReturnMoneyDate = DateTime.Now;
order.ts = DateTime.Now;
order.modifyuser = User.ID;
if (new Hi.BLL.DIS_Order().Update(order))
{
Utils.AddSysBusinessLog(this.CompID, "Order", KeyID.ToString(), "申请退货", orderreturn.ReturnContent);
new Common().GetWxService("4", KeyID.ToString(), "1");
string str = "\"str\":true";
str = "{" + str + "}";
Response.Write(str);
Response.End();
}
}
}
private void SaveToDBase()
{
string CreateDateStr;
int KeyID;
int Year;
int Month;
int Date;
int Hour;
int Miminute;
int Second;
List <OpenDoor> MyAllOpenDoor = new List <OpenDoor>();
OpenDoorListStr = "[" + OpenDoorCount.ToString() + ":";
for (int i = 0; i < OpenDoorCount; i++)
{
int Index = 24 + 17 * i;
KeyID = this.MyReadBuffers[Index];
CreateDateStr = null;
CreateDateStr = Encoding.ASCII.GetString(this.MyReadBuffers, Index + 2, 14);
Year = int.Parse(CreateDateStr.Substring(0, 4));
Month = int.Parse(CreateDateStr.Substring(4, 2));
Date = int.Parse(CreateDateStr.Substring(6, 2));
Hour = int.Parse(CreateDateStr.Substring(8, 2));
Miminute = int.Parse(CreateDateStr.Substring(10, 2));
Second = int.Parse(CreateDateStr.Substring(12, 2));
CreateDateStr = CreateDateStr.Insert(4, "-");
CreateDateStr = CreateDateStr.Insert(7, "-");
CreateDateStr = CreateDateStr.Insert(10, " ");
CreateDateStr = CreateDateStr.Insert(13, ":");
CreateDateStr = CreateDateStr.Insert(16, ":");
OpenDoor MyOpenDoor = new OpenDoor();
MyOpenDoor.LockID = MyLockIDStr;
MyOpenDoor.KeyID = KeyID;
MyOpenDoor.OpenDate = new DateTime(Year, Month, Date, Hour, Miminute, Second);
MyOpenDoor.OpenDateStr = CreateDateStr;
MyAllOpenDoor.Add(MyOpenDoor);
OpenDoorListStr = OpenDoorListStr + KeyID.ToString() + "," + CreateDateStr + ";";
}
int LastIndex = OpenDoorListStr.LastIndexOf(";");
OpenDoorListStr = OpenDoorListStr.Remove(LastIndex, 1);
OpenDoorListStr = OpenDoorListStr + "]";
//OpenDoorManager MyOpenDoorManager = new OpenDoorManager();
//MyOpenDoorManager.InsertOpenDoorEx(MyAllOpenDoor);
OpenDoorManager MyOpenDoorManager = new OpenDoorManager();
MyOpenDoorManager.InsertOpenDoorEx(MyAllOpenDoor);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.txt_keyid.Value = Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey);
DataBinds();
//绑定权限 RepeaterRoles
List <Hi.Model.SYS_Role> LDis = new Hi.BLL.SYS_Role().GetList("", " CompID=" + CompID + " AND DisID=0 AND dr=0 AND IsEnabled=1 ", "Createdate", null);
this.RepeaterRoles.DataSource = LDis;
this.RepeaterRoles.DataBind();
}
}
protected void btn_NUse(object sender, EventArgs e)
{
Hi.Model.BD_Distributor Dis = new Hi.BLL.BD_Distributor().GetModel(KeyID);
string sql = "select * from SYS_CompUser where ISNULL(dr,0)=0 and DisID=" + KeyID;
DataTable userDT = SqlHelper.Query(SqlHelper.LocalSqlServer, sql).Tables[0];
if (userDT.Rows.Count > 0)
{
SqlTransaction Tran = null;
try
{
Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
for (int i = 0; i < userDT.Rows.Count; i++)
{
Hi.Model.SYS_CompUser user = new Hi.BLL.SYS_CompUser().GetModel(Convert.ToInt32(userDT.Rows[i]["ID"].ToString()));
user.IsEnabled = 0;
user.ts = DateTime.Now;
user.modifyuser = UserID;
new Hi.BLL.SYS_CompUser().Update(user, Tran);
}
Tran.Commit();
}
catch
{
if (Tran != null)
{
if (Tran.Connection != null)
{
Tran.Rollback();
}
JScript.AlertMethod(this, "操作失败！", JScript.IconOption.错误, "function(){ window.location.href=window.location.href; }");
}
}
}
if (Dis != null)
{
Dis.IsEnabled = 0;
Dis.ts = DateTime.Now;
Dis.modifyuser = UserID;
if (new Hi.BLL.BD_Distributor().Update(Dis))
{
if (Request["nextstep"] + "" == "1")
{
Response.Redirect("DisList.aspx?nextstep=1");
}
else
{
Response.Redirect("DisInfo.aspx?KeyID=" + KeyID.ToString() + "&type=2");
}
}
}
}
/// <summary>
/// 微信支付
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnWxPay_Click(object sender, EventArgs e)
{
StringBuilder sbHtml = new StringBuilder();
sbHtml.Append("<form id='wxfrom' name='wxsubmit' action='WeChatPay.aspx' method='post'>");
sbHtml.Append("<input type='hidden' name='hidPayprice' value='" + txtPayOrder.Value.Trim() + "'/>");
sbHtml.Append("<input type='hidden' name='hidOid' value='" + KeyID.ToString() + "'/>");
//submit按钮控件请不要含有name属性
sbHtml.Append("<input type='submit' value='确认' style='display:none;'></form>");
sbHtml.Append("<script>document.forms['wxfrom'].submit();</script>");
Response.Write(sbHtml.ToString());
Response.End();
}
public int Fanli = 0; //是否启用返利
protected void Page_Load(object sender, EventArgs e)
{
object obj = Request["action"];
if (obj != null)
{
if (obj.ToString() == "dislist")
{
string compid = Request["compId"] + "";
string disid = Request["disId"] + "";
Response.Write(disBing(compid, disid));
Response.End();
}
}
if (!IsPostBack)
{
DataTable dt = Common.BindDisList(this.CompID.ToString());//代理商绑定
if (dt != null)
{
this.rptDisList.DataSource = dt;
this.rptDisList.DataBind();
}
this.hidType2.Value = Request.QueryString["type"] + "";//2 再次购买
this.hidKeyId.Value = KeyID.ToString();
this.hidCompId.Value = this.CompID.ToString();
Fanli = OrderInfoType.rdoOrderAudit("订单支付返利是否启用", CompID).ToInt(0);
this.hidFanl.Value = Fanli.ToString(); //是否启用返利
IsInve = OrderInfoType.rdoOrderAudit("商品是否启用库存", CompID).ToInt(0); //是否启用库存
//代理商列表
List <Hi.Model.BD_Distributor> list = new Hi.BLL.BD_Distributor().GetList("ID,DisName", "isnull(dr,0)=0 and compid=" + this.CompID, "");
this.divDisList.InnerText = ConvertJson.ToJson(Common.FillDataTable(list));
if (KeyID != 0)
{
if (Request.QueryString["type"] + "" != "2")
{
Hi.Model.DIS_Order model = new Hi.BLL.DIS_Order().GetModel(KeyID);
//判断订单是否可以修改 企业下单订单已审未支付，代理商下单企业不能修改
if (model.OState > (int)Enums.OrderState.待审核)
{
JScript.AlertAndRedirect("订单已被其他人修改，请刷新后再重新操作！", "orderdetail.aspx?top=1&KeyID=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey));
return;
}
}
else
{
this.hidType.Value = Request.QueryString["type"] + "";
}
Bind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//绑定推荐商品
BindTopGoods();
//绑定联系人
PrincipalBind();
//绑定新闻
NewsBind();
Hid_UserCompKey.Value = Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey);
}
BindShowJson = "var Showoption = { \"btnBanner\": \".banner-edit\",\"btnRecommend\": \".adMenu-edit\",\"btnFiveImg\": \".adImg-edit\",\"btnContact\": \".contact-edit\" }; \n var RequesType = { Query:0,Submit:1,Action:2 };";
}
/// <summary>
/// 审核
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAudit_Click(object sender, EventArgs e)
{
Hi.Model.PAY_PrePayment PAmodel = this.PAbll.GetModel(KeyID);
if (PAmodel != null)
{
if (PAmodel.AuditState != Convert.ToInt32(Enums.PrePayState.已审))
{
PAmodel.AuditState = 2;
PAmodel.IsEnabled = 1;
PAmodel.ID = KeyID;
if (PAbll.Update(PAmodel))
{
////sum代理商全部补录，冲正金额
//decimal sums = new Hi.BLL.PAY_PrePayment().sums(PAmodel.DisID,PAmodel.CompID);
////修改代理商的企业钱包金额
////调用model,对属性进行赋值
//Hi.Model.BD_Distributor dismodel = new Hi.BLL.BD_Distributor().GetModel(PAmodel.DisID);
//dismodel.DisAccount = sums;
//dismodel.ID = PAmodel.DisID;
////调用修改方法
//Hi.BLL.BD_Distributor disupdate = new Hi.BLL.BD_Distributor();
//bool disup = disupdate.Update(dismodel);
//if (disup)
//{
Utils.AddSysBusinessLog(this.CompID, "PrePayment", KeyID.ToString(), "预收款补录审核", "");
JScript.AlertMsgOne(this, "操作成功！", JScript.IconOption.笑脸);
Bind();
// }
}
}
else
{
JScript.AlertMsgOne(this, "数据状态不正确,不能进行审核！", JScript.IconOption.错误);
}
}
else
{
JScript.AlertMsgOne(this, "数据不存在！", JScript.IconOption.错误);
}
}
/// <summary>
/// Returns a string representation of the packet. This is
/// a human readable formated representation that has nothing
/// to do with OpenPGP or RFC2440
/// </summary>
/// <returns>String representation of the packet.</returns>
/// <remarks>No remarks</remarks>
public override string ToString()
{
string strReturn = "";
strReturn += "PublicKeyPacket:\r\n";
strReturn += "Version: " + Version.ToString() + "\r\n";
strReturn += "Algorithm: " + Algorithm.ToString() + "\r\n";
strReturn += "Time Created: " + TimeCreated.ToLocalTime() + "\r\n";
strReturn += "Fingerprint: 0x" + Fingerprint.ToString(16) + "\r\n";
strReturn += "KeyID: " + KeyID.ToString() + "\r\n";
strReturn += "Key Material:\r\n";
for (int i = 0; i < KeyMaterial.Length; i++)
{
strReturn += KeyMaterial[i].ToString(16) + "\r\n\r\n";
}
return(strReturn + "----\r\n\r\n");
}
private void cmdUpdate_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
var cdc = new ContentDejourController();
try
{
LoadData(); // load form fields into CurrentItem
// save the content
if (Mode == "Add")
{
KeyID = cdc.AddContent(CurrentItem, UserId);
SaveContentItem(CurrentItem, false);
}
else if (Mode == "Edit")
{
cdc.UpdateContent(CurrentItem, UserId);
SaveContentItem(CurrentItem, true);
}
// refresh cache
ModuleController.SynchronizeModule(ModuleId);
if (!divSelect.Visible && KeyID > 0)
{
Response.Redirect(Globals.NavigateURL("", "keyid=" + KeyID.ToString()), true);
}
else
{
KeyID = 0;
Mode = "Select";
BindGrid(SortColumns.Count > 0);
}
}
catch (Exception exc)
{
Exceptions.ProcessModuleLoadException(this, exc);
}
}
}
/// <summary>
/// 取消订单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnOff_Click(object sender, EventArgs e)
{
Hi.Model.DIS_Order OrderModel = OrderBll.GetModel(KeyID);
if (OrderModel != null)
{
if ((OrderModel.OState == (int)Enums.OrderState.已审 || OrderModel.OState == (int)Enums.OrderState.待审核) && OrderModel.PayState == (int)Enums.PayState.未支付)
{
string sql = " update [DIS_Order] set [OState]=" + (int)Enums.OrderState.已作废 + " where ID=" + KeyID;
if (OrderBll.UpdateOrderState(sql))
{
Utils.AddSysBusinessLog(this.CompID, "Order", KeyID.ToString(), "订单作废", "");
//Bind();
Response.Redirect("neworder/orderdetail.aspx?KeyID=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey));
}
}
else
{
JScript.AlertMsgOne(this, "数据状态不正确,无法取消！", JScript.IconOption.错误);
}
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDel_Click(object sender, EventArgs e)
{
Hi.Model.DIS_Order OrderInfoModel = OrderBll.GetModel(KeyID);
if (OrderInfoModel != null)
{
bool del = false;
//if (OrderInfoModel.AddType == (int)Enums.AddType.企业补单)
//{
// if (OrderInfoModel.OState == (int)Enums.OrderState.已提交)
// del = true;
//}
//else
//{
//}
//判断订单状态是否能删除
if (OrderInfoModel.OState == (int)Enums.OrderState.退回 || OrderInfoModel.OState == (int)Enums.OrderState.已作废 || OrderInfoModel.OState == (int)Enums.OrderState.未提交)
{
del = true;
}
if (del)
{
OrderInfoModel.dr = 1;
bool falg = OrderBll.OrderDel(OrderInfoModel);
if (falg)
{
Utils.AddSysBusinessLog(this.CompID, "Order", KeyID.ToString(), "订单删除", "");
//JScript.AlertMsg(this, "订单删除成功！", "OrderList.aspx");
ClientScript.RegisterStartupScript(this.GetType(), "del", "<script>window.location.href = 'OrderList.aspx'</script>");
}
}
else
{
JScript.AlertMsgOne(this, "订单处理中，不能删除！", JScript.IconOption.错误);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetName = "RentalItem";
URLPopUpControlLink.URLToPopup = "WebFormPopup.aspx?UC=ShowLinks&UCE=RentLedgerBase&BO=RentalItemActivitySet as it inner join RentalItemSet as ra on it.RentalItem.Id = ra.Id&SF=it.Id,it.Description,it.RentStartDateTime,it.RentEndStartDateTime,it.TotalRentPrice&DF=x,Omschrijving,Verhuurdatum en -tijd start,Eind,Verhuurprijs&SEL=ra.Id&ORD=it.RentStartDateTime desc&LNK=Id&ID=" + KeyID.ToString();
if (!IsPostBack)
{
Common.AddRentalItemStateList(ComboBox_ItemState_SelectedValue.Items, true);
}
}
void Page_PreRender(object sender, EventArgs e)
{
DropDownListMaterialStockPosition.DataBind();
DropDownListMaterialStockPosition.SelectedValue = (DataItem as Material).MaterialId.ToString();
URLPopUpControlCorrectStockLevel.URLToPopup = "WebFormPopUp.aspx?uc=StockCorrectLevel&Id=" + KeyID.ToString();
}
/// <summary>
/// 订单信息
/// </summary>
public void databind()
{
if (KeyID != 0)
{
hidOrderID.Value = Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey);
string where = "and isnull(o.dr,0)=0 and o.otype<>9 and o.ID= " + KeyID;
DataTable dt = new Hi.BLL.DIS_Order().GetList("", where);
if (dt != null && dt.Rows.Count > 0)
{
CompID = dt.Rows[0]["CompID"].ToString().ToInt(0);
DisID = dt.Rows[0]["DisID"].ToString().ToInt(0);
hidDisID.Value = DisID.ToString();
//判断改该条数据代理商是否有操作权限
if (!Common.PageDisOperable("Order", KeyID, DisID))
{
Response.Redirect("../NoOperable.aspx");
return;
}
//////再次购买
////buyagain.Visible = false;
//////订单修改
////modifyorder.Visible = false;
//订单作废
//ordervoid.Visible = false;
//////订单审核
////orderaudit.Visible = false;
Digits = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", dt.Rows[0]["CompID"].ToString().ToInt(0));
hidDigits.Value = Digits;
isbate = OrderInfoType.rdoOrderAudit("订单支付返利是否启用", CompID).ToInt(0);
if (isbate == 0)
{
trbate.Visible = false;
rebate.Visible = false;
}
OState = dt.Rows[0]["OState"].ToString().ToInt(0);
if (OState == (int)Enums.OrderState.已作废)
{
orderDelete.Visible = true;
}
else
{
orderDelete.Visible = false;
}
IsOutState = dt.Rows[0]["IsOutState"].ToString().ToInt(0);
payState = dt.Rows[0]["PayState"].ToString().ToInt(0);
hidIsOutstate.Value = dt.Rows[0]["IsOutState"].ToString();
hidOstate.Value = OState.ToString();
hidpaystate.Value = payState.ToString();
#region 订单操作按钮
//switch (OState)
//{
// case (int)Enums.OrderState.未提交:
// //modifyorder.Visible = true;
// //buyagain.Visible = true;
// //orderaudit.Visible = true;
// //ordervoid.Visible = true;
// deliver.Attributes.Add("style", "display: none;");
// break;
// case (int)Enums.OrderState.待审核:
// //modifyorder.Visible = true;
// //buyagain.Visible = true;
// //orderaudit.Visible = true;
// //ordervoid.Visible = true;
// deliver.Attributes.Add("style", "display: none;");
// break;
// case (int)Enums.OrderState.已审:
// //订单审核前，可以修改订单。
// buyagain.Visible = true;
// if (payState == 0)
// {
// //订单支付前订单可以作废，支付后不能作废订单
// ordervoid.Visible = true;
// }
// break;
// case (int)Enums.OrderState.退货处理:
// buyagain.Visible = true;
// fulfil = signde;
// break;
// case (int)Enums.OrderState.已发货:
// modifyorder.Visible = false;
// buyagain.Visible = true;
// break;
// case (int)Enums.OrderState.已到货:
// modifyorder.Visible = false;
// buyagain.Visible = true;
// fulfil = signde;
// break;
// case (int)Enums.OrderState.已作废:
// modifyorder.Visible = false;
// buyagain.Visible = true;
// break;
// case (int)Enums.OrderState.已退货:
// buyagain.Visible = true;
// fulfil = signde;
// break;
// default:
// break;
//}
#endregion
// 订单编号
lblReceiptNo.InnerText = dt.Rows[0]["ReceiptNo"].ToString();
lblDisName.InnerText = Common.GetDisValue(dt.Rows[0]["DisID"].ToString().ToInt(0), "DisName").ToString();
lblCreateDate.InnerText = dt.Rows[0]["CreateDate"].ToString().ToDateTime().ToString("yyyy-MM-dd");
lblOstate.InnerText = OrderType.GetOState(dt.Rows[0]["OState"].ToString(), dt.Rows[0]["IsOutState"].ToString());
//订单流程
lblTotalAmount.InnerText = dt.Rows[0]["TotalAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["TotalAmount"].ToString().ToDecimal().ToString("N");
lblProAmount.InnerText = dt.Rows[0]["ProAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["ProAmount"].ToString().ToDecimal().ToString("N");
lblbateAmount.InnerText = dt.Rows[0]["bateAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["bateAmount"].ToString().ToDecimal().ToString("N");
lblbate.InnerText = dt.Rows[0]["bateAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["bateAmount"].ToString().ToDecimal().ToString("0.00");
lblPostFee.InnerText = dt.Rows[0]["PostFee"].ToString() == "" ? "0.00" : dt.Rows[0]["PostFee"].ToString().ToDecimal().ToString("0.00");
lblAuditAmount.InnerText = dt.Rows[0]["AuditAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["AuditAmount"].ToString().ToDecimal().ToString("N");
//下单信息
lblArriveDate.InnerText = dt.Rows[0]["ArriveDate"].ToString() == "" ? "" : dt.Rows[0]["ArriveDate"].ToString().ToDateTime().ToString("yyyy-MM-dd");
lblGiveMode.InnerText = dt.Rows[0]["GiveMode"].ToString();
iRemark.InnerText = dt.Rows[0]["Remark"].ToString();
//收货地址
lblPrincipal.InnerText = dt.Rows[0]["Principal"].ToString();
lblPhone.InnerText = dt.Rows[0]["Phone"].ToString();
lblAddress.InnerText = dt.Rows[0]["Address"].ToString();
hidAddrID.Value = dt.Rows[0]["AddrID"].ToString();
//开票信息
if (dt.Rows[0]["IsOBill"].ToString() == "1")
{
hidDisAccID.Value = dt.Rows[0]["DisAccID"].ToString();
hidval.Value = dt.Rows[0]["IsOBill"].ToString();
string Billing = string.Empty;
Billing += "发票抬头：<label id=\"lblRise\" runat=\"server\">" + dt.Rows[0]["Rise"].ToString() + "</label>";
Billing += "，发票内容：<label id=\"lblContent\" runat=\"server\">" + dt.Rows[0]["Content"].ToString() + "</label>";
if (!string.IsNullOrEmpty(dt.Rows[0]["OBank"].ToString()))
{
Billing += "，开户银行：<label id=\"lblOBank\" runat=\"server\">" + dt.Rows[0]["OBank"].ToString() + "</label>";
Billing += "，开户账户：<label id=\"lblOAccount\" runat=\"server\">" + dt.Rows[0]["OAccount"].ToString() + "</label>";
Billing += "，纳税人登记号：<label id=\"lblTRNumber\" runat=\"server\">" + dt.Rows[0]["TRNumber"].ToString() + "</label>";
}
iInvoice.InnerHtml = Billing;
//lblRise.InnerText = dt.Rows[0]["Rise"].ToString();
//lblContent.InnerText = dt.Rows[0]["Content"].ToString();
//lblOBank.InnerText = dt.Rows[0]["OBank"].ToString();
//lblOAccount.InnerText = dt.Rows[0]["OAccount"].ToString();
//lblTRNumber.InnerText = dt.Rows[0]["TRNumber"].ToString();
}
else
{
this.iInvoice.InnerHtml = "不开发票";
}
//发票信息
lblBillNo.InnerText = dt.Rows[0]["BillNo"].ToString();
lblIsBill.InnerText = dt.Rows[0]["IsBill"].ToString() == "1" ? "是" : "否";
lblIsBill.Attributes.Add("tip", dt.Rows[0]["IsBill"].ToString());
this.hidisBill.Value = dt.Rows[0]["IsBill"].ToString();
#region 订单支付信息
TotalAmount = Convert.ToDecimal(dt.Rows[0]["AuditAmount"]).ToString("0.00");
PayedAmount = Convert.ToDecimal(dt.Rows[0]["PayedAmount"]).ToString("0.00");
//订单已支付不显示支付按钮(未审核、未支付完成)
if (Convert.ToInt32(dt.Rows[0]["OState"]) == 1 || (Convert.ToDecimal(dt.Rows[0]["AuditAmount"]) - Convert.ToDecimal(dt.Rows[0]["PayedAmount"]) == 0))
{
btn_pay.Visible = false;
}
paymoney = (Convert.ToDecimal(dt.Rows[0]["AuditAmount"]) - Convert.ToDecimal(dt.Rows[0]["PayedAmount"])).ToString("0.00");
//加密keyId
desKeyID.Value = Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey);
//绑定支付流水信息
DataTable paytable = new Hi.BLL.PAY_PrePayment().GetPayedItem(KeyID);
rptmessage.DataSource = paytable;
rptmessage.DataBind();
//初始值加载
txtArriveDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
DataTable dtpayment = new Hi.BLL.PAY_PrePayment().GetDate(" top 1 CreateDate, payName ,paycode ,paybank", "pay_payment", " DisID=" + DisID + " and vdef3=5 order by CreateDate desc");
foreach (DataRow dr in dtpayment.Rows)
{
bankname.Value = Convert.ToString(dr["payName"]);
bankcode.Value = Convert.ToString(dr["paycode"]);
bank.Value = Convert.ToString(dr["paybank"]);
}
#endregion
//附件
if (dt.Rows[0]["Atta"].ToString() != "")
{
StringBuilder li = new StringBuilder();
string[] atta = dt.Rows[0]["Atta"].ToString().Split(new string[] { "@@" }, StringSplitOptions.RemoveEmptyEntries);
if (atta.Length > 0)
{
foreach (var item in atta)
{
string[] att = item.Split(new string[] { "^^" }, StringSplitOptions.RemoveEmptyEntries);
if (att.Length > 1)
{
li.AppendFormat("<li> <a href=\"{2}\" target=\"_blank\" class=\"name\">{0}（大小：{4}KB）</a><a href=\"javascript:;\" class=\"bule del\" tip=\"{3}\" orderid=\"{1}\">删除</a><a href=\"{2}\" target=\"_blank\" class=\"bule\">下载</a></li>", att[0] + att[1].Substring(att[1].LastIndexOf(".")), KeyID, Common.GetWebConfigKey("ImgViewPath") + "OrderFJ/" + item, item, OrderType.GetSize(item));
}
}
}
ulAtta.InnerHtml = li.ToString();
this.hrOrderFj.Value = dt.Rows[0]["Atta"].ToString();
}
#region 订单明细
//订单所有商品明细
DataTable l = new Hi.BLL.DIS_OrderDetail().GetOrderDe("", " IsNUll(o.dr,0)=0 and o.OrderId=" + KeyID);
if (l != null && l.Rows.Count > 0)
{
rptOrderD.DataSource = l;
rptOrderD.DataBind();
//待发货商品
DataTable lno = SelectGoodsInfo.SreeenDataTable(l, "isnull(IsOut,0)=0"); //l.Select(string.Format("IsOut={0}", 0));
if (lno != null && lno.Rows.Count > 0)
{
txtDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
rptIsout.DataSource = lno;
rptIsout.DataBind();
}
else
{
deliver.Attributes.Add("style", "display: none;");
}
//已发货商品
List <Hi.Model.DIS_OrderOutDetail> loud = new Hi.BLL.DIS_OrderOutDetail().GetList("", " isnull(dr,0)=0 and OrderID=" + KeyID, "");
//发货单 作废-- and o.IsAudit<>3
DataTable lo = new Hi.BLL.DIS_OrderOut().GetList("", " isnull(o.dr,0)=0 and o.OrderID=" + KeyID + " Order by o.IsAudit");
if (loud != null && loud.Count > 0)
{
//outbind(lo, l, loud);
outGoods.InnerHtml = SelectGoodsInfo.outbind(lo, l, loud, Digits, 1);
}
#region 流程时间控件
//订单流程时间显示
//订单提交时间
CreateDate = dt.Rows[0]["CreateDate"].ToString() != "" ? dt.Rows[0]["CreateDate"].ToString().ToDateTime().ToString("yyyy-MM-dd HH:mm") : "";
//订单审核时间
AuditDate = dt.Rows[0]["AuditDate"].ToString() != "" ? dt.Rows[0]["AuditDate"].ToString().ToDateTime().ToString("yyyy-MM-dd HH:mm") : "";
if (lo != null && lo.Rows.Count > 0)
{
if (((int)Enums.OrderState.已发货 <= OState || OState == (int)Enums.OrderState.退货处理) && (IsOutState == 3 || IsOutState == 4))
{
//订单发货时间
DataRow[] sendlo = lo.Select("IsAudit<>3");
DataRow[] dv = sendlo.OrderByDescending(x => x["id"]).ToArray();
if (dv.Length > 0)
{
sendde = dv[0]["SendDate"].ToString() != "" ? dv[0]["SendDate"].ToString().ToDateTime().ToString("yyyy-MM-dd HH:mm") : "";
}
}
if ((int)Enums.OrderState.已到货 <= OState || OState == (int)Enums.OrderState.退货处理)
{
//订单签收时间
DataRow[] signlo = lo.Select("IsAudit<>3 and IsSign=1");
DataRow[] dr = signlo.OrderByDescending(x => x["id"]).ToArray();
if (dr.Length > 0)
{
signde = dr[0]["SignDate"].ToString() != "" ? dr[0]["SignDate"].ToString().ToDateTime().ToString("yyyy-MM-dd HH:mm") : "";
}
}
}
#endregion
}
#endregion
}
else
{
Response.Redirect("../NoOperable.aspx");
return;
}
}
}
/// <summary>
/// 首营信息提交
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_Edit(object sender, EventArgs e)
{
if (this.KeyID > 0)
{
Hi.Model.YZT_FirstCamp fcmodel = new Hi.BLL.YZT_FirstCamp().GetModel(KeyID);
if (fcmodel != null)
{
fcmodel.State = 0;
fcmodel.ts = DateTime.Now;
fcmodel.modifyuser = this.UserID;
if (new Hi.BLL.YZT_FirstCamp().Update(fcmodel))
{
Response.Redirect("FirstCampInfo.aspx?KeyID=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey));
}
}
}
}
/// <summary>
/// 启用
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnOk_Click(object sender, EventArgs e)
{
if (KeyID != 0)
{
Hi.Model.BD_Promotion proModel = ProBll.GetModel(KeyID);
//促销公告
List <Hi.Model.BD_CompNews> newsl = new Hi.BLL.BD_CompNews().GetList("", " PMID=" + KeyID, "");
if (proModel != null)
{
proModel.IsEnabled = 1;
if (ProBll.Update(proModel))
{
if (newsl != null && newsl.Count > 0)
{
Hi.Model.BD_CompNews newsModel = new Hi.Model.BD_CompNews();
foreach (Hi.Model.BD_CompNews item in newsl)
{
item.IsEnabled = 0;
newsModel = item;
}
new Hi.BLL.BD_CompNews().Update(newsModel);
}
Response.Write("<script>window.location.href='../PmtManager/PromotionInfo.aspx?KeyId=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey) + "&type=" + Request["type"] + "';</script>");
}
}
}
}
/// <summary>
/// 新增招商信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAdd_Click(object sender, EventArgs e)
{
Hi.Model.YZT_CMerchants cmModel = null;
string [] ProvideData = new string[4];
if (this.chk1.Checked)
{
ProvideData[0] = "1";
}
if (this.chk2.Checked)
{
ProvideData[1] = "2";
}
if (this.chk3.Checked)
{
ProvideData[2] = "3";
}
if (this.chk4.Checked)
{
ProvideData[3] = "4";
}
if (KeyID != 0)
{
cmModel = new Hi.BLL.YZT_CMerchants().GetModel(this.KeyID);
SqlTransaction Tran = null;
try
{
Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
if ("2".Equals(cmModel.Type.ToString()))
{
if (!new Hi.BLL.YZT_FCArea().CMDelete(this.KeyID, Tran))
{
//Tran.Rollback();
//return;
}
}
else if ("3".Equals(cmModel.Type.ToString()))
{
if (!new Hi.BLL.YZT_FCDis().CMDelete(this.KeyID, Tran))
{
//Tran.Rollback();
//return;
}
}
//cmModel.CMCode = this.txtCMCode.Value.Trim();
cmModel.CMName = this.txtCMName.Value.Trim();
cmModel.GoodsID = this.hidGoodsID.Value.ToInt(0);
cmModel.GoodsCode = this.txtGoodsCode.Value.Trim();
cmModel.GoodsName = this.txtGoodsName.Value.Trim();
cmModel.Remark = this.OrderNote.Value.Trim();
cmModel.ValueInfo = this.txtValueInfo.Value.Trim();
cmModel.InvalidDate = this.txtInvalidDate.Value != "" ? Convert.ToDateTime(this.txtInvalidDate.Value.Trim()) : DateTime.MinValue;
cmModel.ForceDate = this.txtForceDate.Value != "" ? Convert.ToDateTime(this.txtForceDate.Value.Trim()) : DateTime.MinValue;
cmModel.ProvideData = string.Join(",", ProvideData);
cmModel.CategoryID = this.hidCategoryID.Value.Trim().ToInt(0);
cmModel.Type = ddrtype.Value.ToString().ToInt(0);
cmModel.IsEnabled = 0;
cmModel.ts = DateTime.Now;
cmModel.modifyuser = this.UserID;
string fc = this.hidfc.Value;
if (new Hi.BLL.YZT_CMerchants().Update(cmModel, Tran))
{
if (!"".Equals(fc))
{
string[] fcval = fc.Split(new char[] { ',' });
if (ddrtype.Value.ToString() == "2")
{
//指定区域
Hi.Model.YZT_FCArea areaModel = null;
foreach (var item in fcval)
{
string[] fcvals = item.ToString().Split(new char[] { '|' });
areaModel = new Hi.Model.YZT_FCArea();
//areaModel.AreaID = item.ToInt(0);
areaModel.Province = fcvals[0] + "";
areaModel.City = fcvals[1] + "";
areaModel.Area = fcvals[2] + "";
areaModel.CMID = this.KeyID;
areaModel.CompID = this.CompID;
areaModel.ts = DateTime.Now;
areaModel.CreateDate = DateTime.Now;
areaModel.CreateUserID = this.UserID;
areaModel.modifyuser = this.UserID;
new Hi.BLL.YZT_FCArea().Add(areaModel, Tran);
}
}
else if (ddrtype.Value.ToString() == "3")
{
//指定代理商
Hi.Model.YZT_FCDis fcdisModel = null;
foreach (var item in fcval)
{
fcdisModel = new Hi.Model.YZT_FCDis();
fcdisModel.DisID = item.ToInt(0);
fcdisModel.CMID = this.KeyID;
fcdisModel.CompID = this.CompID;
fcdisModel.ts = DateTime.Now;
fcdisModel.CreateDate = DateTime.Now;
fcdisModel.CreateUserID = this.UserID;
fcdisModel.modifyuser = this.UserID;
new Hi.BLL.YZT_FCDis().Add(fcdisModel, Tran);
}
}
}
Tran.Commit();
Response.Redirect("CMerchantsInfo.aspx?KeyID=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey));
}
else
{
Tran.Rollback();
}
}
catch (Exception)
{
//Tran.Rollback();
throw;
}
}
else
{
cmModel = new Hi.Model.YZT_CMerchants();
cmModel.CompID = this.CompID;
cmModel.CMCode = GetNo(); //this.txtCMCode.Value.Trim();
cmModel.CMName = this.txtCMName.Value.Trim();
cmModel.GoodsCode = this.txtGoodsCode.Value.Trim();
cmModel.GoodsName = this.txtGoodsName.Value.Trim();
cmModel.Remark = this.OrderNote.Value.Trim();
cmModel.ValueInfo = this.txtValueInfo.Value.Trim();
cmModel.InvalidDate = this.txtInvalidDate.Value != "" ? Convert.ToDateTime(this.txtInvalidDate.Value.Trim()) : DateTime.MinValue;
cmModel.ForceDate = this.txtForceDate.Value != "" ? Convert.ToDateTime(this.txtForceDate.Value.Trim()) : DateTime.MinValue;
cmModel.ProvideData = string.Join(",", ProvideData);
cmModel.CategoryID = this.txtCategoryID.Value.Trim().ToInt(0);
cmModel.Type = ddrtype.Value.ToString().ToInt(0);
cmModel.IsEnabled = 0;
cmModel.GoodsID = this.hidGoodsID.Value.ToInt(0);
cmModel.ts = DateTime.Now;
cmModel.CreateDate = DateTime.Now;
cmModel.CreateUserID = this.UserID;
cmModel.modifyuser = this.UserID;
string fc = this.hidfc.Value;
SqlTransaction Tran = null;
try
{
Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
int id = new Hi.BLL.YZT_CMerchants().Add(cmModel, Tran);
if (id > 0)
{
if (!"".Equals(fc))
{
string[] fcval = fc.Split(new char[] { ',' });
if (ddrtype.Value.ToString() == "2")
{
//指定区域
Hi.Model.YZT_FCArea areaModel = null;
foreach (var item in fcval)
{
string[] fcvals = item.ToString().Split(new char[] { '|' });
areaModel = new Hi.Model.YZT_FCArea();
//areaModel.AreaID = item.ToInt(0);
areaModel.Province = fcvals[0] + "";
areaModel.City = fcvals[1] + "";
areaModel.Area = fcvals[2] + "";
areaModel.CMID = id;
areaModel.CompID = this.CompID;
areaModel.ts = DateTime.Now;
areaModel.CreateDate = DateTime.Now;
areaModel.CreateUserID = this.UserID;
areaModel.modifyuser = this.UserID;
new Hi.BLL.YZT_FCArea().Add(areaModel, Tran);
}
}
else if (ddrtype.Value.ToString() == "3")
{
//指定代理商
Hi.Model.YZT_FCDis fcdisModel = null;
foreach (var item in fcval)
{
fcdisModel = new Hi.Model.YZT_FCDis();
fcdisModel.DisID = item.ToInt(0);
fcdisModel.CMID = id;
fcdisModel.CompID = this.CompID;
fcdisModel.ts = DateTime.Now;
fcdisModel.CreateDate = DateTime.Now;
fcdisModel.CreateUserID = this.UserID;
fcdisModel.modifyuser = this.UserID;
new Hi.BLL.YZT_FCDis().Add(fcdisModel, Tran);
}
}
}
Tran.Commit();
Response.Redirect("CMerchantsInfo.aspx?KeyID=" + Common.DesEncrypt(id.ToString(), Common.EncryptKey));
}
else
{
Tran.Rollback();
}
}
catch (Exception)
{
//Tran.Rollback();
throw;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetName = "RelationProject";
URLPopUpControlLink.URLToPopup = "WebFormPopup.aspx?UC=ShowLinks&UCE=OrderBase&BO=OrderSet as it inner join RelationProjectSet as ra on it.RelationProject.Id = ra.Id&SF=it.Id,it.Description,it.OrderNumber,it.BookingDateTime&DF=x,Omschrijving,Ordernummer,Boekdatum en -tijd&SEL=ra.Id&ORD=it.BookingDateTime desc&LNK=Id&ID=" + KeyID.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.hidType2.Value = Request.QueryString["type"] + "";
this.hidDisID.Value = this.DisID.ToString();
this.hidKeyId.Value = KeyID.ToString();
StringBuilder strwhere = new StringBuilder();
Fanli = OrderInfoType.rdoOrderAudit("订单支付返利是否启用", CompID).ToInt(0);
this.hidFanl.Value = Fanli.ToString();
LoginModel logUser = Session["UserModel"] as LoginModel;
Common.ListComps(this.ddrComp, this.UserID.ToString(), this.CompID.ToString());
this.hidCompId.Value = this.ddrComp.Value.ToString();
decimal CreditAmount = 0;
if (BLL.Common.GetCredit(this.hidCompId.Value.ToString().ToInt(0), logUser.DisID, out CreditAmount))
{
decimal GetSumAmount = OrderInfoType.GetSumAmount(logUser.DisID.ToString(), this.hidCompId.Value.ToString(), KeyID);
if (GetSumAmount >= CreditAmount)
{
this.Msg.InnerHtml = "您的授信额度(" + CreditAmount + ")已用完或超出！无法下单";
this.Btn.InnerHtml = "<a href=\"javascript:; \" class=\"gray-btn2\">取消</a>";
}
else
{
this.Msg.InnerHtml = "";
}
}
else
{
this.Msg.InnerHtml = "";
}
// isbate = OrderInfoType.rdoOrderAudit("订单支付返利是否启用", CompID).ToInt(0);
//if (Fanli == 0)
//{
// this.trbate.Visible = false;
// this.rebate.Visible = false;
//}
//商品是否启用库存
IsInve = OrderInfoType.rdoOrderAudit("商品是否启用库存", this.CompID).ToInt(0);
if (IsInve == 0)
{
strwhere.AppendFormat("and info.Inventory>0");
}
DataTable dt = SqlHelper.Query(SqlHelper.LocalSqlServer, SelectGoodsInfo.Returnsql(CompID.ToString(), DisID.ToString(), strwhere.ToString(), "1")).Tables[0];
List <int> infoidl = new List <int>();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
int id = item["ID"].ToString().ToInt(0);//BD_goodsInfo表的ID
infoidl.Add(id);
}
}
//获取商品价格
List <BLL.gDprice> l = BLL.Common.GetPrice(CompID, DisID, infoidl);
if (l != null && l.Count > 0)
{
foreach (var item in l)
{
DataRow[] dr = dt.Select(" ID=" + item.goodsInfoId);
if (dr.Length > 0)
{
//获取的价格大于促销价时、取促销价
dr[0]["pr"] = item.FinalPrice;
dr[0]["typeTinkerPrice"] = item.typePrice;
dr[0]["disTinkerPrice"] = item.disPrice;
dr[0]["disProPr"] = item.bpPrice;
}
}
}
this.divGoodsName.InnerText = ConvertJson.ToJson2(dt);
//代理商列表
List <Hi.Model.BD_Distributor> list = new Hi.BLL.BD_Distributor().GetList("ID,DisName", "isnull(dr,0)=0 and compid=" + this.CompID, "");
this.divDisList.InnerText = ConvertJson.ToJson(Common.FillDataTable(list));
if (KeyID != 0)
{
if (Request.QueryString["type"] + "" != "2")
{
Hi.Model.DIS_Order model = new Hi.BLL.DIS_Order().GetModel(KeyID);
//判断订单是否可以修改 企业下单订单已审未支付，代理商下单企业不能修改
if (model.OState > (int)Enums.OrderState.待审核)
{
JScript.AlertAndRedirect("订单已被其他人修改，请刷新后再重新操作！", "orderdetail.aspx?top=1&KeyID=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey));
return;
}
}
else
{
this.hidType.Value = Request.QueryString["type"] + "";
}
Bind();
}
else
{
if ((Request.QueryString["type"] + "") == "1")
{
this.hidType.Value = Request.QueryString["type"] + "";
ShopCart();
}
}
}
}
/// <summary>
/// 订单信息
/// </summary>
public void databind()
{
if (KeyID != 0)
{
//判断改该条数据代理商是否有操作权限
if (!Common.PageDisOperable("Order", KeyID, DisID))
{
Response.Redirect("../NoOperable.aspx");
return;
}
hidOrderID.Value = Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey);
string where = "and isnull(o.dr,0)=0 and o.otype<>9 and o.DisID=" + DisID + " and o.ID= " + KeyID;
DataTable dt = new Hi.BLL.DIS_Order().GetList("", where);
if (dt != null && dt.Rows.Count > 0)
{
//再次购买
buyagain.Visible = false;
//订单修改
modifyorder.Visible = false;
//订单作废
ordervoid.Visible = false;
//申请退货
//orderReturn.Visible = false;
Digits = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", dt.Rows[0]["CompID"].ToString().ToInt(0));
IsShow = OrderInfoType.rdoOrderAudit("订单明细是否显示店铺商品", 0).ToInt(0);
IsInve = OrderInfoType.rdoOrderAudit("商品是否启用库存", dt.Rows[0]["CompID"].ToString().ToInt(0)).ToInt(0);
hidDigits.Value = Digits;
isbate = OrderInfoType.rdoOrderAudit("订单支付返利是否启用", dt.Rows[0]["CompID"].ToString().ToInt(0)).ToInt(0);
if (isbate == 0)
{
if (dt.Rows[0]["bateAmount"].ToString() == "" || dt.Rows[0]["bateAmount"].ToString() == "0.00")
{
this.trbate.Visible = false;
this.rebate.Visible = false;
}
}
// 订单编号
lblReceiptNo.InnerText = dt.Rows[0]["ReceiptNo"].ToString();
lblCreateDate.InnerText = dt.Rows[0]["CreateDate"].ToString().ToDateTime().ToString("yyyy-MM-dd");
lblOstate.InnerText = OrderType.GetOState(dt.Rows[0]["OState"].ToString(), dt.Rows[0]["IsOutState"].ToString());
hidOstate.Value = dt.Rows[0]["OState"].ToString();
lblCompID.InnerText = Common.Getcom(dt.Rows[0]["CompID"].ToString().ToInt(0), "CompName");
orderCompId = Convert.ToString(dt.Rows[0]["CompID"]);
hidIsOutstate.Value = dt.Rows[0]["IsOutState"].ToString();
OState = dt.Rows[0]["OState"].ToString().ToInt(0);
IsOutState = dt.Rows[0]["IsOutState"].ToString().ToInt(0);
payState = dt.Rows[0]["PayState"].ToString().ToInt(0);
ReturnState = dt.Rows[0]["ReturnState"].ToString().ToInt(0);
hidDts.Value = dt.Rows[0]["ts"].ToString();
//订单流程
lblTotalAmount.InnerText = dt.Rows[0]["TotalAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["TotalAmount"].ToString().ToDecimal().ToString("N");
lblProAmount.InnerText = dt.Rows[0]["ProAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["ProAmount"].ToString().ToDecimal().ToString("N");
lblbateAmount.InnerText = dt.Rows[0]["bateAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["bateAmount"].ToString().ToDecimal().ToString("N");
lblbate.InnerText = dt.Rows[0]["bateAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["bateAmount"].ToString().ToDecimal().ToString("N");
lblPostFee.InnerText = dt.Rows[0]["PostFee"].ToString() == "" ? "0.00" : dt.Rows[0]["PostFee"].ToString().ToDecimal().ToString("0.00");
lblAuditAmount.InnerText = dt.Rows[0]["AuditAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["AuditAmount"].ToString().ToDecimal().ToString("N");
//下单信息
lblArriveDate.InnerText = dt.Rows[0]["ArriveDate"].ToString() == "" ? "" : dt.Rows[0]["ArriveDate"].ToString().ToDateTime().ToString("yyyy-MM-dd");
lblGiveMode.InnerText = dt.Rows[0]["GiveMode"].ToString();
iRemark.InnerText = dt.Rows[0]["Remark"].ToString();
//收货地址
lblPrincipal.InnerText = dt.Rows[0]["Principal"].ToString();
lblPhone.InnerText = dt.Rows[0]["Phone"].ToString();
lblAddress.InnerText = dt.Rows[0]["Address"].ToString();
hidAddrID.Value = dt.Rows[0]["AddrID"].ToString();
//开票信息
if (dt.Rows[0]["IsOBill"].ToString().ToInt(0) > 0)
{
hidDisAccID.Value = dt.Rows[0]["DisAccID"].ToString();
hidval.Value = dt.Rows[0]["IsOBill"].ToString();
string Billing = string.Empty;
Billing += "发票抬头：<label id=\"lblRise\" runat=\"server\">" + dt.Rows[0]["Rise"].ToString() + "</label>";
Billing += "，发票内容：<label id=\"lblContent\" runat=\"server\">" + dt.Rows[0]["Content"].ToString() + "</label>";
if (dt.Rows[0]["IsOBill"].ToString().ToInt(0) == 2)
{
Billing += "，开户银行：<label id=\"lblOBank\" runat=\"server\">" + dt.Rows[0]["OBank"].ToString() + "</label>";
Billing += "，开户账户：<label id=\"lblOAccount\" runat=\"server\">" + dt.Rows[0]["OAccount"].ToString() + "</label>";
Billing += "，纳税人登记号：<label id=\"lblTRNumber\" runat=\"server\">" + dt.Rows[0]["TRNumber"].ToString() + "</label>";
}
else
{
Billing += "，纳税人登记号：<label id=\"lblTRNumber\" runat=\"server\">" + dt.Rows[0]["TRNumber"].ToString() + "</label>";
}
iInvoice.InnerHtml = Billing;
//lblRise.InnerText = dt.Rows[0]["Rise"].ToString();
//lblContent.InnerText = dt.Rows[0]["Content"].ToString();
//lblOBank.InnerText = dt.Rows[0]["OBank"].ToString();
//lblOAccount.InnerText = dt.Rows[0]["OAccount"].ToString();
//lblTRNumber.InnerText = dt.Rows[0]["TRNumber"].ToString();
}
else
{
this.iInvoice.InnerHtml = "不开发票";
}
//发票信息
lblBillNo.InnerText = dt.Rows[0]["BillNo"].ToString();
lblIsBill.InnerText = dt.Rows[0]["IsBill"].ToString() == "1" ? "是" : "否";
this.hidisBill.Value = dt.Rows[0]["IsBill"].ToString();
string msg = string.Empty;
bool flag = Common.FCan(dt.Rows[0]["DisID"].ToString(), "1", out msg);
if (flag)
{
this.lblmsg.InnerText = msg;
}
decimal nopayAmount = OrderInfoType.GetSumAmount(dt.Rows[0]["DisID"].ToString(), dt.Rows[0]["CompID"].ToString(), KeyID);
if (nopayAmount > 0)
{
string promptmsg = "订单待支付金额为￥" + nopayAmount.ToString("0.00") + "，请尽快支付";
this.lblPrompt.InnerText = promptmsg;
}
else
{
this.lblPrompt.Visible = false;
}
#region 订单支付信息
TotalAmount = Convert.ToDecimal(dt.Rows[0]["AuditAmount"]).ToString("0.00");
PayedAmount = Convert.ToDecimal(dt.Rows[0]["PayedAmount"]).ToString("0.00");
//订单已支付不显示支付按钮(未审核、未支付完成)
if (Convert.ToInt32(dt.Rows[0]["OState"]) == (int)Enums.OrderState.未提交 || Convert.ToInt32(dt.Rows[0]["OState"]) == (int)Enums.OrderState.待审核 || Convert.ToInt32(dt.Rows[0]["OState"]) == (int)Enums.OrderState.待审核 || Convert.ToInt32(dt.Rows[0]["OState"]) == (int)Enums.OrderState.已退货 || Convert.ToInt32(dt.Rows[0]["OState"]) == (int)Enums.OrderState.已作废 || (Convert.ToDecimal(dt.Rows[0]["AuditAmount"]) - Convert.ToDecimal(dt.Rows[0]["PayedAmount"]) == 0))
{
btn_pay.Visible = false;
}
paymoney = (Convert.ToDecimal(dt.Rows[0]["AuditAmount"]) - Convert.ToDecimal(dt.Rows[0]["PayedAmount"])).ToString("0.00");
//加密keyId
desKeyID.Value = Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey);
//绑定支付流水信息
DataTable paytable = new Hi.BLL.PAY_PrePayment().GetPayedItem(KeyID);
rptmessage.DataSource = paytable;
rptmessage.DataBind();
//初始值加载
txtArriveDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
DataTable dtpayment = new Hi.BLL.PAY_PrePayment().GetDate(" top 1 CreateDate, payName ,paycode ,paybank", "pay_payment", " DisID=" + DisID + " and vdef3=5 order by CreateDate desc");
foreach (DataRow dr in dtpayment.Rows)
{
bankname.Value = Convert.ToString(dr["payName"]);
bankcode.Value = Convert.ToString(dr["paycode"]);
bank.Value = Convert.ToString(dr["paybank"]);
}
//附件
//if (dt.Rows[0]["Atta"].ToString() != "")
//{
// StringBuilder li = new StringBuilder();
// string[] atta = dt.Rows[0]["Atta"].ToString().Split(new string[] { "$$&&" }, StringSplitOptions.RemoveEmptyEntries);
// if (atta.Length > 0)
// {
// foreach (var item in atta)
// {
// li.AppendFormat("<li> <a href=\"javascript:;\" class=\"name\">{0}</a><a href=\"javascript:;\" class=\"bule del\" orderid=\"{1}\">删除</a><a href=\"javascript:;\" class=\"bule\">下载</a></li>", item, KeyID);
// }
// }
// this.payulfile.InnerHtml = li.ToString();
//}
#endregion
//附件
if (dt.Rows[0]["Atta"].ToString() != "")
{
StringBuilder li = new StringBuilder();
string[] atta = dt.Rows[0]["Atta"].ToString().Split(new string[] { "@@" }, StringSplitOptions.RemoveEmptyEntries);
if (atta.Length > 0)
{
foreach (var item in atta)
{
string[] att = item.Split(new string[] { "^^" }, StringSplitOptions.RemoveEmptyEntries);
if (att.Length > 1)
{
li.AppendFormat("<li> <a href=\"{2}\" target=\"_blank\" class=\"name\">{0}（大小：{4}KB）</a><a href=\"javascript:;\" class=\"bule del\" tip=\"{3}\" orderid=\"{1}\">删除</a><a href=\"{2}\" target=\"_blank\" class=\"bule\">下载</a></li>", att[0] + att[1].Substring(att[1].LastIndexOf(".")), KeyID, Common.GetWebConfigKey("ImgViewPath") + "OrderFJ/" + item, item, OrderType.GetSize(item));
}
}
}
ulAtta.InnerHtml = li.ToString();
this.hrOrderFj.Value = dt.Rows[0]["Atta"].ToString();
}
#region 订单明细
//订单所有商品明细
DataTable l = new Hi.BLL.DIS_OrderDetail().GetOrderDe("", " IsNUll(o.dr,0)=0 and o.OrderId=" + KeyID);
if (l != null && l.Rows.Count > 0)
{
rptOrderD.DataSource = l;
rptOrderD.DataBind();
//待发货商品
DataTable lno = SelectGoodsInfo.SreeenDataTable(l, "isnull(IsOut,0)=0"); //l.Select(string.Format("IsOut={0}", 0));
if (lno != null && lno.Rows.Count > 0)
{
rptIsout.DataSource = lno;
rptIsout.DataBind();
}
//已发货商品
List <Hi.Model.DIS_OrderOutDetail> loud = new Hi.BLL.DIS_OrderOutDetail().GetList("", " isnull(dr,0)=0 and OrderID=" + KeyID, "");
//发货单 and o.IsAudit<>3
DataTable lo = new Hi.BLL.DIS_OrderOut().GetList("", " isnull(o.dr,0)=0 and o.OrderID=" + KeyID + " Order by o.IsAudit");
if (loud != null && loud.Count > 0)
{
//outbind(lo, l, loud);
outGoods.InnerHtml = SelectGoodsInfo.outbind(lo, l, loud, Digits, 0);
}
#region 流程时间控件
if (lo != null && lo.Rows.Count > 0)
{
if (((int)Enums.OrderState.已发货 <= OState || OState == (int)Enums.OrderState.退货处理) && (IsOutState == 3 || IsOutState == 4))
{
//订单发货时间
DataRow[] sendlo = lo.Select("IsAudit<>3");
DataRow[] dv = sendlo.OrderByDescending(x => x["id"]).ToArray();
if (dv.Length > 0)
{
sendde = dv[0]["SendDate"].ToString() != "" ? dv[0]["SendDate"].ToString().ToDateTime().ToString("yyyy-MM-dd HH:mm") : "";
}
}
if ((int)Enums.OrderState.已到货 <= OState || OState == (int)Enums.OrderState.退货处理)
{
//订单签收时间
DataRow[] signlo = lo.Select("IsAudit<>3 and IsSign=1");
DataRow[] dr = signlo.OrderByDescending(x => x["id"]).ToArray();
if (dr.Length > 0)
{
signde = dr[0]["SignDate"].ToString() != "" ? dr[0]["SignDate"].ToString().ToDateTime().ToString("yyyy-MM-dd HH:mm") : "";
}
}
}
#endregion
}
#endregion
#region 流程时间控件
//订单流程时间显示
//订单提交时间
CreateDate = dt.Rows[0]["CreateDate"].ToString() != "" ? dt.Rows[0]["CreateDate"].ToString().ToDateTime().ToString("yyyy-MM-dd HH:mm") : "";
//订单审核时间
AuditDate = dt.Rows[0]["AuditDate"].ToString() != "" ? dt.Rows[0]["AuditDate"].ToString().ToDateTime().ToString("yyyy-MM-dd HH:mm") : "";
#endregion 流程时间控件
#region 订单操作按钮
switch (OState)
{
case (int)Enums.OrderState.待审核:
modifyorder.Visible = true;
buyagain.Visible = true;
ordervoid.Visible = true;
break;
case (int)Enums.OrderState.已审:
//订单审核前，可以修改订单。
buyagain.Visible = true;
break;
case (int)Enums.OrderState.退货处理:
//orderReturn.Visible = false;
buyagain.Visible = true;
btn_pay.Visible = false;
fulfil = signde;
break;
case (int)Enums.OrderState.已发货:
modifyorder.Visible = false;
buyagain.Visible = true;
break;
case (int)Enums.OrderState.已到货:
modifyorder.Visible = false;
buyagain.Visible = true;
if (dt.Rows[0]["CreateDate"].ToString().ToDateTime() > DateTime.Now.AddMonths(-3))
{
//三个月以内的订单可退货
//if (ReturnState < (int)Enums.ReturnState.申请退货)
//orderReturn.Visible = true;
}
if (ReturnState >= (int)Enums.ReturnState.申请退货)
{
btn_pay.Visible = false;
}
if (sendde == "" && signde == "" && AuditDate != "")
{
fulfil = AuditDate;
}
else if (AuditDate.ToString() == "")
{
fulfil = CreateDate;
}
else
{
fulfil = signde == "" ? sendde : signde;
}
break;
case (int)Enums.OrderState.已作废:
modifyorder.Visible = false;
buyagain.Visible = true;
fulfil = Convert.ToDateTime(dt.Rows[0]["ts"]).ToString("yyyy-MM-dd HH:mm");
break;
case (int)Enums.OrderState.已退货:
buyagain.Visible = true;
btn_pay.Visible = false;
fulfil = signde;
break;
default:
break;
}
#endregion
//订单修改，再次购买
if (!Common.HasRight(this.CompID, this.UserID, "1010", this.DisID))
{
this.buyagain.Visible = false;
this.modifyorder.Visible = false;
}
//订单作废
if (!Common.HasRight(this.CompID, this.UserID, "2012", this.DisID))
{
this.ordervoid.Visible = false;
}
//在线支付
if (!Common.HasRight(this.CompID, this.UserID, "2014", this.DisID))
{
ClientScript.RegisterStartupScript(this.GetType(), "btn_pay_xs", "<script> $('#btn_pay_xs').hide();</script>");
}
//线下支付
if (!Common.HasRight(this.CompID, this.UserID, "2015", this.DisID))
{
this.btn_pay_xx.Visible = false;
}
//申请退货
//if (!Common.HasRight(this.CompID, this.UserID, "2311", this.DisID))
//this.orderReturn.Visible = false;
//确认收货
if (!Common.HasRight(this.CompID, this.UserID, "2013", this.DisID))
{
ClientScript.RegisterStartupScript(this.GetType(), "btnsign", "<script> $('.btnsign,.btnsigni').hide();</script>");
}
}
}
else
{
Response.Redirect("../NoOperable.aspx");
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetName = "RelationContract";
if (!IsPostBack)
{
Common.AddRelationContractStatusList(DropDownList_ContractStatus_SelectedValue.Items, true);
Common.AddContractTypeList(DropDownList_ContractType_SelectedValue.Items, true);
}
URLPopUpControlLink.URLToPopup = "WebFormPopup.aspx?UC=ShowLinks&UCE=OrderBase&BO=OrderSet as it inner join OrderLineSet as ol on it.id=ol.Order.Id inner join RelationContractMaterialSet as ra on ol.RelationContractMaterial.Id = ra.Id inner join RelationContractSet as rcs on ra.RelationContract.Id = rcs.Id&SF=it.Id,it.Description,it.OrderNumber,it.BookingDateTime&DF=x,Omschrijving,Ordernummer,Boekdatum en -tijd&SEL=rcs.Id&ORD=it.BookingDateTime desc&LNK=Id&ID=" + KeyID.ToString();
URLPopUpControlShowContract.URLToPopup = "WebFormPopup.aspx?UC=ShowReport&d=DataSetRelationContract&r=ReportRelationContract&Id=" + KeyID.ToString();
URLPopUpControlContractGuidance.URLToPopup = "WebFormPopup.aspx?UC=ShowLinks&UCE=OrderBase&BO=OrderSet as it inner join MaterialMutationSet as mms on it.id=mms.Order.Id inner join ContractGuidanceMaterialMutationSet as cmms on cmms.Id=mms.ContractGuidanceMaterialMutation.Id inner join RelationContractMaterialSet as rcms on rcms.Id=cmms.RelationContractMaterial.Id inner join RelationContractSet as rcs on rcs.Id=rcms.RelationContract.Id&SF=it.Id,it.Description,it.OrderNumber,it.BookingDateTime&DF=x,Omschrijving,Ordernummer,Boekdatum en -tijd&SEL=rcs.Id&ORD=it.BookingDateTime desc&LNK=Id&ID=" + KeyID.ToString();
}
//public void BindGoods()
//{
// SelectGoods.Clear(this.CompID);
// SelectGoods.OrderDetail(KeyID, DisID, this.CompID);
// DataTable dt = Session["GoodsInfo"] as DataTable;
// if (dt != null)
// {
// this.rpDtl.DataSource = dt;
// this.rpDtl.DataBind();
// }
// else
// {
// this.rpDtl.DataSource = "";
// this.rpDtl.DataBind();
// }
// SelectGoods.Clear(DisID, this.CompID);
//}
//protected void A_AddOrderReturn(object sender, EventArgs e)
//{
// if (order != null)
// {
// if (!string.IsNullOrEmpty(txtremark.Value.Trim()))
// {
// if (string.IsNullOrEmpty(Request.QueryString["type"]))
// {
// Hi.Model.DIS_OrderReturn orderreturn = new Hi.Model.DIS_OrderReturn();
// Hi.Model.BD_Distributor dis = new Hi.BLL.BD_Distributor().GetDisID(user.UserName);
// orderreturn.CompID = dis.CompID;
// orderreturn.DisID = dis.ID;
// orderreturn.OrderID = order.ID;
// orderreturn.CreateDate = DateTime.Now;
// orderreturn.CreateUserID = user.ID;
// orderreturn.ReturnContent = txtremark.Value;
// orderreturn.ReturnState = (int)Enums.AuditState.未提交;
// orderreturn.ts = DateTime.Now;
// orderreturn.modifyuser = user.ID;
// int orderreturnid = OrderInfoType.ReturnOrderAdd(orderreturn, order.ID);
// if (orderreturnid > 0)
// {
// Utils.AddSysBusinessLog(this.CompID, "Order", order.ID.ToString(), "申请退货", "");
// Response.Redirect("returnorderinfo.aspx?KeyID=" + order.ID);
// }
// else
// {
// JScript.AlertMsg(this, "退货失败,请稍候再试");
// }
// }
// else if (Request.QueryString["type"].ToString() == "update")
// {
// Hi.Model.DIS_OrderReturn orderreturn = new Hi.BLL.DIS_OrderReturn().GetModel(KeyID.ToString());
// Hi.Model.BD_Distributor dis = new Hi.BLL.BD_Distributor().GetDisID(user.UserName);
// orderreturn.CompID = dis.CompID;
// orderreturn.DisID = dis.ID;
// orderreturn.OrderID = order.ID;
// orderreturn.CreateDate = DateTime.Now;
// orderreturn.CreateUserID = user.ID;
// orderreturn.ReturnContent = txtremark.Value;
// orderreturn.ReturnState = (int)Enums.AuditState.未提交;
// orderreturn.ts = DateTime.Now;
// orderreturn.modifyuser = user.ID;
// if (new Hi.BLL.DIS_OrderReturn().Update(orderreturn))
// {
// Response.Redirect("returnorderinfo.aspx?KeyID=" + order.ID);
// }
// }
// }
// else
// {
// JScript.AlertMsg(this, "请注明退货原因");
// }
// }
//}
//public int GetGoodsID(string goodsinfoid)
//{
// Hi.Model.BD_GoodsInfo goodsinfo = new Hi.BLL.BD_GoodsInfo().GetModel(int.Parse(goodsinfoid));
// return goodsinfo.GoodsID;
//}
protected void A_AddOrderReturn(object sender, EventArgs e)
{
Hi.Model.DIS_Order order = OrderBll.GetModel(KeyID);
if (order != null)
{
if (order.OState == (int)Enums.OrderState.已到货 && (order.ReturnState == (int)Enums.ReturnState.未退货 || order.ReturnState == (int)Enums.ReturnState.拒绝退货))
{
if (string.IsNullOrEmpty(Request.QueryString["type"]))
{
Hi.Model.DIS_OrderReturn orderreturn = new Hi.Model.DIS_OrderReturn();
//Hi.Model.BD_Distributor dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID);
orderreturn.ReceiptNo = order.ReceiptNo + SysCode.GetCode("退单", order.ID.ToString());
orderreturn.CompID = this.CompID;
orderreturn.DisID = this.DisID;
orderreturn.OrderID = order.ID;
orderreturn.ReturnDate = DateTime.Now;
orderreturn.CreateDate = DateTime.Now;
orderreturn.CreateUserID = this.UserID;
orderreturn.ReturnContent = Common.NoHTML(txtremark.Value);
orderreturn.ReturnState = (int)Enums.AuditState.提交;
orderreturn.ts = DateTime.Now;
orderreturn.modifyuser = this.UserID;
int orderreturnid = OrderInfoType.ReturnOrderAdd(orderreturn, order.ID);
if (orderreturnid > 0)
{
order.ts = DateTime.Now;
order.ReturnState = (int)Enums.ReturnState.申请退货;
order.ReturnMoneyDate = DateTime.Now;
order.ReturnMoneyUser = this.UserName;
order.ReturnMoneyUserId = this.UserID;
if (new Hi.BLL.DIS_Order().Update(order))
{
//Utils.AddSysBusinessLog(this.CompID, "Order", KeyID.ToString(), "订单修改", orderreturn.ReturnContent);
ClientScript.RegisterStartupScript(GetType(), "msg", "<script>window.parent.ResurnOrder();</script>");
}
}
else
{
JScript.AlertMsgOne(this, "退货失败,请稍候再试！", JScript.IconOption.哭脸);
}
}
else if (Request.QueryString["type"].ToString() == "update")
{
Hi.Model.DIS_OrderReturn orderreturn = new Hi.BLL.DIS_OrderReturn().GetModel(KeyID.ToString());
Hi.Model.BD_Distributor dis = new Hi.BLL.BD_Distributor().GetModel(DisID);
orderreturn.CompID = dis.CompID;
orderreturn.DisID = dis.ID;
orderreturn.OrderID = order.ID;
orderreturn.CreateDate = DateTime.Now;
orderreturn.CreateUserID = this.UserID;
orderreturn.ReturnContent = Common.NoHTML(txtremark.Value);
orderreturn.ReturnState = (int)Enums.AuditState.未提交;
orderreturn.ts = DateTime.Now;
orderreturn.modifyuser = this.UserID;
if (new Hi.BLL.DIS_OrderReturn().Update(orderreturn))
{
Response.Redirect("returnorderinfo.aspx?KeyID=" + Common.DesEncrypt(order.ID.ToString(), Common.EncryptKey));
}
}
}
else
{
JScript.AlertMsgOne(this, "订单处理中，不能申请退货！", JScript.IconOption.哭脸);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection objCn = new SqlConnection(sqlControl1.ConnectionString);
serverConnection = new ServerConnection(objCn);
Server server = new Server(serverConnection);
Char[] EnvArr = Environment.NewLine.ToCharArray();
int keyCount = 0;
for (int i = 0; i < lstTables.CheckedItems.Count; i++)
{
string strTableName = lstTables.CheckedItems[i].ToString();
string strSQL = "";
/***SELECT**/
if (chkSelect.Checked)
{
strSQL = "CREATE PROCEDURE [" + strTableName.ToLower() + "_get_all] " + Environment.NewLine;
strSQL += "As" + Environment.NewLine;
strSQL += " SELECT * FROM [" + strTableName + "]" + Environment.NewLine;
txtSQL.Text += strSQL + Environment.NewLine + Environment.NewLine;
}
strSQL = "";
/***DELETE**/
if (chkDelete.Checked)
{
strSQL = "CREATE PROCEDURE [" + strTableName.ToLower() + "_delete_by_id] " + Environment.NewLine;
/***Now Declare Params**/
Hashtable objTable = (Hashtable)JSStaticClass.WhereColumns[strTableName];
if (objTable.Keys.Count > 0)
{
strSQL += "(";
keyCount = 0;
foreach (object KeyID in objTable.Keys)
{
keyCount++;
strSQL += "@" + KeyID.ToString().Replace(" ", "") + " " + server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns[KeyID.ToString()].DataType;//.SqlDataType;
if (server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns[KeyID.ToString()].DataType.SqlDataType == SqlDataType.NVarCharMax)
{
strSQL += "(MAX)";
}
if (server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns[KeyID.ToString()].DataType.SqlDataType == SqlDataType.VarCharMax)
{
strSQL += "(MAX)";
}
else if (server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns[KeyID.ToString()].DataType.Name.ToUpper().Contains("CHAR"))
{
strSQL += "(" + server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns[KeyID.ToString()].DataType.MaximumLength + ")";
}
if (keyCount < objTable.Keys.Count)
{
strSQL += "," + Environment.NewLine;
}
}
strSQL += ")" + Environment.NewLine;
}
strSQL += " As Delete from [" + strTableName + "]" + Environment.NewLine;
if (objTable.Keys.Count > 0)
{
strSQL += " Where ";
keyCount = 0;
foreach (object KeyID in objTable.Keys)
{
keyCount++;
strSQL += KeyID.ToString().Replace(" ", "") + " = " + "@" + KeyID.ToString().Replace(" ", "");
if (keyCount < objTable.Keys.Count)
{
strSQL += " and " + Environment.NewLine;
}
}
}
txtSQL.Text += strSQL + Environment.NewLine + Environment.NewLine;
}
/***INSERT**/
if (chkInsert.Checked)
{
strSQL = "CREATE PROCEDURE [" + strTableName.ToLower() + "_add] " + Environment.NewLine;
/***Now Declare Params**/
Hashtable objTable = (Hashtable)JSStaticClass.WhereColumns[strTableName];
Hashtable objIDTable = (Hashtable)JSStaticClass.TableColumns[strTableName];
//if (objTable.Keys.Count > 0)
//{
strSQL += "(";
keyCount = 0;
foreach (Column item in server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns)
{
keyCount++;
if (objIDTable[item.Name] == null)
{
strSQL += "@" + item.Name.ToString().Replace(" ", "") + " " + item.DataType; //.SqlDataType;
if (item.DataType.SqlDataType == SqlDataType.VarCharMax)
{
strSQL += "(MAX)";
}
if (item.DataType.SqlDataType == SqlDataType.NVarCharMax)
{
strSQL += "(MAX)";
}
else if (item.DataType.Name.ToUpper().Contains("CHAR"))
{
strSQL += "(" + item.DataType.MaximumLength + ")";
}
if (keyCount < server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns.Count)
{
strSQL += "," + Environment.NewLine;
}
}
}
strSQL += ")" + Environment.NewLine;
//}
strSQL += " As Insert Into [" + strTableName + "] (" + Environment.NewLine;
keyCount = 0;
foreach (Column item in server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns)
{
keyCount++;
if (objIDTable[item.Name] == null)
{
strSQL += item.Name.ToString().Replace(" ", "");
if (keyCount < server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns.Count)
{
strSQL += "," + Environment.NewLine;
}
}
}
strSQL += ") Values (" + Environment.NewLine;
keyCount = 0;
foreach (Column item in server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns)
{
keyCount++;
if (objIDTable[item.Name] == null)
{
strSQL += "@" + item.Name.ToString().Replace(" ", "");
if (keyCount < server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns.Count)
{
strSQL += "," + Environment.NewLine;
}
}
}
strSQL += ")" + Environment.NewLine;
strSQL += "select SCOPE_IDENTITY()";
txtSQL.Text += strSQL + Environment.NewLine + Environment.NewLine;
}
/***UPDATE**/
if (chkUpdate.Checked)
{
strSQL = "CREATE PROCEDURE [" + strTableName.ToLower() + "_update] " + Environment.NewLine;
/***Now Declare Params**/
Hashtable objTable = (Hashtable)JSStaticClass.WhereColumns[strTableName];
Hashtable objIDTable = (Hashtable)JSStaticClass.TableColumns[strTableName];
//if (objTable.Keys.Count > 0)
//{
strSQL += "(";
keyCount = 0;
foreach (Column item in server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns)
{
keyCount++;
//if (objIDTable[item.Name] == null)
//{
strSQL += "@" + item.Name.ToString().Replace(" ", "") + " " + item.DataType; //.SqlDataType;
if (item.DataType.SqlDataType == SqlDataType.VarCharMax)
{
strSQL += "(MAX)";
}
if (item.DataType.SqlDataType == SqlDataType.NVarCharMax)
{
strSQL += "(MAX)";
}
else if (item.DataType.Name.ToUpper().Contains("CHAR"))
{
strSQL += "(" + item.DataType.MaximumLength + ")";
}
if (keyCount < server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns.Count)
{
strSQL += "," + Environment.NewLine;
}
//}
}
strSQL += ")" + Environment.NewLine;
//}
strSQL += " As Update [" + strTableName + "] set " + Environment.NewLine;
keyCount = 0;
foreach (Column item in server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns)
{
keyCount++;
if (objIDTable[item.Name] == null && objTable[item.Name] == null)
{
strSQL += item.Name.ToString().Replace(" ", "") + " = @" + item.Name.ToString().Replace(" ", "");
if (keyCount < server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns.Count)
{
strSQL += "," + Environment.NewLine;
}
}
}
strSQL += "";
if (objTable.Keys.Count > 0)
{
strSQL += Environment.NewLine + " Where ";
keyCount = 0;
foreach (object KeyID in objTable.Keys)
{
keyCount++;
strSQL += KeyID.ToString().Replace(" ", "") + " = " + "@" + KeyID.ToString().Replace(" ", "");
if (keyCount < objTable.Keys.Count)
{
strSQL += " and " + Environment.NewLine;
}
}
}
txtSQL.Text += strSQL + Environment.NewLine + Environment.NewLine;
}
/***UPDATE/INSERT**/
if (chkInsUpd.Checked)
{
strSQL = "CREATE PROCEDURE [" + strTableName + "_AddUpdate] " + Environment.NewLine;
/***Now Declare Params**/
Hashtable objTable = (Hashtable)JSStaticClass.WhereColumns[strTableName];
Hashtable objIDTable = (Hashtable)JSStaticClass.TableColumns[strTableName];
//if (objTable.Keys.Count > 0)
//{
strSQL += "(";
keyCount = 0;
foreach (Column item in server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns)
{
keyCount++;
//if (objIDTable[item.Name] == null)
//{
strSQL += "@" + item.Name.ToString().Replace(" ", "") + " " + item.DataType; //.SqlDataType;
if (item.DataType.SqlDataType == SqlDataType.VarCharMax)
{
strSQL += "(MAX)";
}
else if (item.DataType.Name.ToUpper().Contains("CHAR"))
{
strSQL += "(" + item.DataType.MaximumLength + ")";
}
if (keyCount < server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns.Count)
{
strSQL += "," + Environment.NewLine;
}
//}
}
strSQL += ")" + Environment.NewLine;
//}
strSQL += " As Begin" + Environment.NewLine;
strSQL += "If (Select ";
if (objIDTable.Keys.Count > 0)
{
keyCount = 0;
foreach (object KeyID in objIDTable.Keys)
{
keyCount++;
strSQL += KeyID.ToString().Replace(" ", "");
if (keyCount < objIDTable.Keys.Count)
{
strSQL += " , ";
}
}
}
strSQL += " from [" + strTableName + "]";
if (objTable.Keys.Count > 0)
{
strSQL += Environment.NewLine + " Where ";
keyCount = 0;
foreach (object KeyID in objTable.Keys)
{
keyCount++;
strSQL += KeyID.ToString().Replace(" ", "") + " = " + "@" + KeyID.ToString().Replace(" ", "");
if (keyCount < objTable.Keys.Count)
{
strSQL += " and " + Environment.NewLine;
}
}
}
strSQL += ") <> 0" + Environment.NewLine;
strSQL += "Begin" + Environment.NewLine;
strSQL += " Update [" + strTableName + "] set " + Environment.NewLine;
keyCount = 0;
foreach (Column item in server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns)
{
keyCount++;
if (objIDTable[item.Name] == null && objTable[item.Name] == null)
{
strSQL += item.Name.ToString().Replace(" ", "") + " = @" + item.Name.ToString().Replace(" ", "");
if (keyCount < server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns.Count)
{
strSQL += "," + Environment.NewLine;
}
}
}
strSQL += "";
if (objTable.Keys.Count > 0)
{
strSQL += Environment.NewLine + " Where ";
keyCount = 0;
foreach (object KeyID in objTable.Keys)
{
keyCount++;
strSQL += KeyID.ToString().Replace(" ", "") + " = " + "@" + KeyID.ToString().Replace(" ", "");
if (keyCount < objTable.Keys.Count)
{
strSQL += " and " + Environment.NewLine;
}
}
}
strSQL += Environment.NewLine + "End" + Environment.NewLine;
strSQL += "Else" + Environment.NewLine;
strSQL += "Begin" + Environment.NewLine;
strSQL += " Insert Into [" + strTableName + "] (" + Environment.NewLine;
keyCount = 0;
foreach (Column item in server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns)
{
keyCount++;
if (objIDTable[item.Name] == null)
{
strSQL += item.Name.ToString().Replace(" ", "");
if (keyCount < server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns.Count)
{
strSQL += "," + Environment.NewLine;
}
}
}
strSQL += ") Values (" + Environment.NewLine;
keyCount = 0;
foreach (Column item in server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns)
{
keyCount++;
if (objIDTable[item.Name] == null)
{
strSQL += "@" + item.Name.ToString().Replace(" ", "");
if (keyCount < server.Databases[sqlControl1.DatabaseName].Tables[strTableName].Columns.Count)
{
strSQL += "," + Environment.NewLine;
}
}
}
strSQL += ")" + Environment.NewLine;
strSQL += "select SCOPE_IDENTITY()" + Environment.NewLine;
strSQL += "End" + Environment.NewLine;
strSQL += "End" + Environment.NewLine;
txtSQL.Text += strSQL + Environment.NewLine + Environment.NewLine;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetName = "RelationPriceAgreement";
if (!IsPostBack)
{
Common.AddPriceAgreementTypeList(DropDownList_AgreementType_SelectedValue.Items, true);
}
URLPopUpControlLink.URLToPopup = "WebFormPopup.aspx?UC=ShowLinks&UCE=OrderBase&BO=OrderSet as it inner join OrderLineSet as ol on it.id=ol.Order.Id inner join RelationPriceAgreementSet as ra on ol.RelationPriceAgreement.Id = ra.Id &SF=it.Id,it.Description,it.OrderNumber,it.BookingDateTime&DF=x,Omschrijving,Ordernummer,Boekdatum en -tijd&SEL=ra.Id&ORD=it.BookingDateTime desc&LNK=Id&ID=" + KeyID.ToString();
URLPopUpControlShowContract.URLToPopup = "WebFormPopup.aspx?UC=ShowReport&d=DataSetRelationPriceAgreement&r=ReportRelationPriceAgreement&Id=" + KeyID.ToString();
}
private void Page_Load(object sender, System.EventArgs e)
{
int i = -1;
string content = string.Empty;
string title = string.Empty;
DateTime todayAdjusted = Utilities.GetCurrentPortalTime();
if (MyConfiguration.EnableUserTimeConversion)
{
todayAdjusted = Utilities.ConvertPortalToUserTime(todayAdjusted);
}
try
{
ContentDejourController cdc = new ContentDejourController();
if (!(string.IsNullOrEmpty(Request.QueryString["KeyID"])))
{
int keyID = 0;
if (int.TryParse(Request.QueryString["KeyID"], out keyID))
{
CurrentItem = cdc.GetContent(keyID, ModuleId);
}
}
if (CurrentItem.KeyID == -1)
{
switch (MyConfiguration.SelectBy)
{
case Enums.SelectBy.Month:
Months = (new MonthArray()).AddMonth(todayAdjusted.Month);
break;
case Enums.SelectBy.DayofMonth:
Days = (new DayArray()).AddDay(todayAdjusted.Day);
break;
case Enums.SelectBy.DayofYear:
Days = new DayArray(todayAdjusted.DayOfYear | DayArray.ModeFlag);
break;
case Enums.SelectBy.MonthAndDayofMonth:
Months = (new MonthArray()).AddMonth(todayAdjusted.Month);
Days = (new DayArray()).AddDay(todayAdjusted.Day);
break;
case Enums.SelectBy.DayofWeek:
DaysofWeek = (new DayofWeekArray()).AddDay(Convert.ToInt32(todayAdjusted.DayOfWeek));
break;
case Enums.SelectBy.MonthAndDayofWeek:
Months = (new MonthArray()).AddMonth(todayAdjusted.Month);
DaysofWeek = (new DayofWeekArray()).AddDay(Convert.ToInt32(todayAdjusted.DayOfWeek));
break;
case Enums.SelectBy.TimeSpan:
Time = Convert.ToInt32(todayAdjusted.TimeOfDay.TotalMinutes);
break;
case Enums.SelectBy.DateSpan:
Today = new DateInteger(todayAdjusted.Date, false);
break;
case Enums.SelectBy.DateAndTimeSpan:
Today = new DateInteger(todayAdjusted.Date, false);
Time = Convert.ToInt32(todayAdjusted.TimeOfDay.TotalMinutes);
break;
case Enums.SelectBy.Random:
//Do nothing as they will be handled below
break;
}
if (!(string.IsNullOrEmpty(MyConfiguration.ProfilePropertyName)))
{
string tmp = null;
if (UserId == -1)
{
tmp = "<Unauthenticated>";
}
else
{
ProfilePropertyDefinition ppd = UserInfo.Profile.GetProperty(MyConfiguration.ProfilePropertyName);
if (ppd == null)
{
tmp = string.Empty;
}
else
{
tmp = ppd.PropertyValue;
if (tmp == null)
{
if (string.IsNullOrEmpty(ppd.DefaultValue))
{
tmp = "<Default>";
}
else
{
tmp = ppd.DefaultValue;
}
}
}
}
ProfilePropertyValue = tmp;
}
if (!(string.IsNullOrEmpty(Request.QueryString["GroupId"])))
{
int.TryParse(Request.QueryString["GroupId"], out _GroupID);
}
if (MyConfiguration.MultipleHandling == Enums.MultipleHandling.TimeSpan)
{
Time = Convert.ToInt32(todayAdjusted.TimeOfDay.TotalMinutes);
}
// get ContentDejourInfo object(s)
ContentsDejour = cdc.GetContents(ModuleId, Months, Days, DaysofWeek, Today, Time, MyConfiguration.CategoryID, GroupID, ProfilePropertyValue, MyConfiguration.IncludeDisabled);
if (ContentsDejour.Count > 1)
{
int minViews = int.MaxValue;
int leastViewed = 0;
switch (MyConfiguration.MultipleHandling)
{
case Enums.MultipleHandling.Random:
i = (new Random()).Next(0, ContentsDejour.Count);
break;
case Enums.MultipleHandling.First:
i = 0;
break;
case Enums.MultipleHandling.Sequential:
case Enums.MultipleHandling.LeastViewed:
System.Web.HttpCookie cookie = Request.Cookies["ContentDejour" + TabModuleId.ToString()];
int[] views = new int[ContentsDejour.Count + 1];
if (cookie != null)
{
i = int.Parse(cookie.Values["LastViewed"]);
for (int j = 0; j < ContentsDejour.Count; j++)
{
string v = cookie.Values[j.ToString()];
if (string.IsNullOrEmpty(v))
{
views[j] = 0;
}
else
{
views[j] = int.Parse(v);
}
if (views[j] < minViews)
{
leastViewed = j;
minViews = views[j];
}
}
}
if (MyConfiguration.MultipleHandling == Enums.MultipleHandling.Sequential)
{
i = (i + 1) % ContentsDejour.Count;
}
else
{
i = leastViewed;
}
views[i]++;
cookie = new HttpCookie("ContentDejour" + TabModuleId.ToString());
cookie.Values["LastViewed"] = i.ToString();
for (int j = 0; j < views.Length; j++)
{
cookie.Values[j.ToString()] = views[j].ToString();
}
cookie.Expires = todayAdjusted.Date.AddMinutes(Convert.ToDouble(ContentsDejour[i].EndTime));
Response.Cookies.Add(cookie);
break;
case Enums.MultipleHandling.Last:
i = ContentsDejour.Count - 1;
break;
case Enums.MultipleHandling.TimeSpan:
ContentsDejour.Sort(new ContentDejourInfoComparer("TimeDuration ASC"));
i = 0;
break;
}
}
else if ((ContentsDejour.Count == 1) && ContentsDejour[0].IsWithinTimeSpan(todayAdjusted.TimeOfDay))
{
i = 0;
}
}
else
{
ContentsDejour.Add(CurrentItem);
if (ContentsDejour.Count == 1)
{
i = 0;
}
}
if (i == -1)
{
if (MyConfiguration.HideWhenNoContent && !IsEditable)
{
ContainerControl.Visible = false;
}
else
{
lnkEdit.Visible = false;
divContent.InnerHtml = LocalizeSharedResource("NO_CONTENT");
}
}
else
{
KeyID = ContentsDejour[i].KeyID;
title = Server.HtmlDecode(ContentsDejour[i].Title);
content = HttpUtility.HtmlDecode(ContentsDejour[i].DesktopHTML);
TokenReplace tr = null;
if (MyConfiguration.ReplaceTokens)
{
tr = new TokenReplace(ContentsDejour[i]);
tr.ModuleId = ModuleId;
tr.AccessingUser = UserInfo;
tr.DebugMessages = !(PortalSettings.UserMode == PortalSettings.Mode.View);
content = tr.ReplaceEnvironmentTokens(content);
title = tr.ReplaceEnvironmentTokens(title);
}
// set edit link
if (IsEditable)
{
lnkEdit.NavigateUrl = EditUrl("KeyID", KeyID.ToString());
lnkEdit.Visible = true;
}
else
{
lnkEdit.Visible = false;
}
// add content to module
divContent.InnerHtml = Globals.ManageUploadDirectory(content, PortalSettings.HomeDirectory);
// replace module title if so specified in settings
if (MyConfiguration.ReplaceTitle && !(string.IsNullOrEmpty(title)))
{
ModuleConfiguration.ModuleTitle = title;
}
}
}
catch (Exception exc)
{
Exceptions.ProcessModuleLoadException(this, exc);
}
}