/// <summary>
/// 修改供应商购物信息
/// </summary>
/// <param name="model">实体</param>
/// <param name="supplierId">供应商基本信息ID</param>
/// <returns></returns>
public bool UpdateShopping(EyouSoft.Model.SupplierStructure.SupplierShopping model, int supplierId)
{
DbCommand cmd = this._db.GetSqlStringCommand(SQL_Update);
this._db.AddInParameter(cmd, "SaleProduct", DbType.String, model.SaleProduct);
this._db.AddInParameter(cmd, "GuideWord", DbType.String, model.GuideWord);
this._db.AddInParameter(cmd, "Id", DbType.Int32, supplierId);
this._db.AddInParameter(cmd, "AgreementFile", DbType.String, model.AgreementFile);
return(EyouSoft.Toolkit.DAL.DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false);
}
private void loadXls()
{
string data = Utils.GetFormValue("dataxls");
string[] s = data.Split(';');
EyouSoft.BLL.SupplierStructure.SupplierShopping ssBLL = new EyouSoft.BLL.SupplierStructure.SupplierShopping();
List <EyouSoft.Model.SupplierStructure.SupplierShopping> list = new List <EyouSoft.Model.SupplierStructure.SupplierShopping>();
for (int i = 0; i < s.Length; i++)
{
string[] smodel = s[i].Split(',');
if (smodel.Length == 13 && !string.IsNullOrEmpty(smodel[0]) && !string.IsNullOrEmpty(smodel[1]) && !string.IsNullOrEmpty(smodel[2]))
{
EyouSoft.Model.SupplierStructure.SupplierShopping ssModel = new EyouSoft.Model.SupplierStructure.SupplierShopping();
ssModel.ProvinceName = HttpUtility.UrlDecode(smodel[0]); //省份
ssModel.CityName = HttpUtility.UrlDecode(smodel[1]); //城市
ssModel.UnitName = HttpUtility.UrlDecode(smodel[2]); //单位名称
ssModel.SaleProduct = HttpUtility.UrlDecode(smodel[3]); //销售产品
ssModel.GuideWord = HttpUtility.UrlDecode(smodel[4]); //导游词
ssModel.UnitAddress = HttpUtility.UrlDecode(smodel[5]); //地址
ssModel.OperatorId = SiteUserInfo.ID; //操作人
ssModel.IssueTime = DateTime.Now; //添加时间
ssModel.CompanyId = CurrentUserCompanyID; //公司编号
ssModel.AgreementFile = string.Empty; //协议
ssModel.IsDelete = false; //是否删除
ssModel.SupplierType = EyouSoft.Model.EnumType.CompanyStructure.SupplierType.购物; //单位类型
ssModel.TradeNum = 0; //交易次数
//联系人
ssModel.SupplierContact = new List <EyouSoft.Model.CompanyStructure.SupplierContact>();
EyouSoft.Model.CompanyStructure.SupplierContact scModel = new EyouSoft.Model.CompanyStructure.SupplierContact();
scModel.ContactName = HttpUtility.UrlDecode(smodel[6]); //姓名
scModel.JobTitle = HttpUtility.UrlDecode(smodel[7]); //职务
scModel.ContactTel = HttpUtility.UrlDecode(smodel[8]); //电话
scModel.ContactMobile = HttpUtility.UrlDecode(smodel[9]); //手机
scModel.QQ = HttpUtility.UrlDecode(smodel[10]); //QQ
scModel.Email = HttpUtility.UrlDecode(smodel[11]); //email
ssModel.SupplierContact.Add(scModel);
ssModel.Remark = HttpUtility.UrlDecode(smodel[12]);
list.Add(ssModel);
}
}
bool res = ssBLL.ImportExcelData(list);
Response.Clear();
Response.Write(string.Format("{{\"res\":{0}}}", res ? 1 : -1));
Response.End();
}
/// <summary>
/// 分页获取供应商购物信息
/// </summary>
/// <param name="pageSize">每页数</param>
/// <param name="pageIndex">起始页</param>
/// <param name="recordCount">总数</param>
/// <param name="supplierType">供应商类型</param>
/// <param name="queryModel">查询实体</param>
public IList <EyouSoft.Model.SupplierStructure.SupplierShopping> GetList(int pageSize, int pageIndex, ref int recordCount, int companyId, EyouSoft.Model.EnumType.CompanyStructure.SupplierType supplierType, EyouSoft.Model.SupplierStructure.SupplierQuery queryModel)
{
IList <EyouSoft.Model.SupplierStructure.SupplierShopping> ls = new List <EyouSoft.Model.SupplierStructure.SupplierShopping>();
string tableName = "tbl_CompanySupplier";
StringBuilder fields = new StringBuilder();
fields.Append(" Id,UnitAddress,ProvinceName,CityName,");
fields.Append(" (select top 1 ContactName,ContactTel,ContactFax from tbl_SupplierContact a where a.SupplierId = tbl_CompanySupplier.[Id] for xml raw,root('root')) as ContactXML,");
fields.Append(" (select top 1 SaleProduct from tbl_SupplierShopping b where b.Id = tbl_CompanySupplier.[Id] for xml raw,root('root')) as ShoppingXML,");
fields.Append(" UnitName,TradeNum ");
string primaryKey = "Id";
string orderbyStr = "IssueTime desc";
StringBuilder strWhere = new StringBuilder(" IsDelete='0' ");
strWhere.AppendFormat(" and SupplierType={0}", Convert.ToByte((int)supplierType));
strWhere.AppendFormat(" and CompanyId = {0}", companyId);
if (queryModel != null)
{
if (queryModel.ProvinceId > 0)
{
strWhere.AppendFormat(" and ProvinceId={0}", queryModel.ProvinceId);
}
if (queryModel.CityId > 0)
{
strWhere.AppendFormat(" and CityId={0}", queryModel.CityId);
}
if (!string.IsNullOrEmpty(queryModel.UnitName))
{
strWhere.AppendFormat(" and UnitName like '%{0}%'", queryModel.UnitName);
}
}
using (IDataReader dr = DbHelper.ExecuteReader(this._db, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields.ToString(), strWhere.ToString(), orderbyStr))
{
while (dr.Read())
{
EyouSoft.Model.SupplierStructure.SupplierShopping model = new EyouSoft.Model.SupplierStructure.SupplierShopping();
model.Id = dr.GetInt32(dr.GetOrdinal("Id"));
model.ProvinceName = dr.IsDBNull(dr.GetOrdinal("ProvinceName")) ? "" : dr.GetString(dr.GetOrdinal("ProvinceName"));
model.CityName = dr.IsDBNull(dr.GetOrdinal("CityName")) ? "" : dr.GetString(dr.GetOrdinal("CityName"));
model.UnitAddress = dr.IsDBNull(dr.GetOrdinal("UnitAddress")) ? "" : dr.GetOrdinal("UnitAddress").ToString();
model.UnitName = dr.GetString(dr.GetOrdinal("UnitName"));
model.TradeNum = dr.GetInt32(dr.GetOrdinal("TradeNum"));
model.SupplierContact = GetContactList(dr.IsDBNull(dr.GetOrdinal("ContactXML")) ? "" : dr.GetString(dr.GetOrdinal("ContactXML")));
model.SaleProduct = GetShoppingList(dr.IsDBNull(dr.GetOrdinal("ShoppingXML")) ? "" : dr.GetString(dr.GetOrdinal("ShoppingXML")));
ls.Add(model);
model = null;
}
}
return(ls);
}
private void bind()
{
tid = Utils.GetInt(Utils.GetQueryStringValue("tid"));
if (tid > 0)
{
//获取model
ssModel = csBll.GetModel(tid);
}
else
{
ssModel.SupplierType = EyouSoft.Model.EnumType.CompanyStructure.SupplierType.购物;
}
}
/// <summary>
/// 修改供应商购物信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateShopping(EyouSoft.Model.SupplierStructure.SupplierShopping model)
{
int successId = supplierBase.UpdateSupplierBase(model);
if (successId == 1)
{
return(Dal.UpdateShopping(model, model.Id));
}
else
{
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
csBll = new EyouSoft.BLL.SupplierStructure.SupplierShopping();
ssModel = new EyouSoft.Model.SupplierStructure.SupplierShopping();
if (!CheckGrant(global::Common.Enum.TravelPermission.供应商管理_购物_栏目))
{
Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.供应商管理_购物_栏目, false);
return;
}
ucProvince1.CompanyId = CurrentUserCompanyID;
ucProvince1.IsFav = true;
ucCity1.CompanyId = CurrentUserCompanyID;
ucCity1.IsFav = true;
if (Page.IsPostBack)
{
Save();
}
else
{
type = Utils.GetQueryStringValue("type");
switch (type)
{
case "modify":
if (CheckGrant(global::Common.Enum.TravelPermission.供应商管理_购物_修改))
{
bind();
}
else
{
Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.供应商管理_购物_修改, false);
}
break;
case "show":
show = true;
bind();
break;
default:
if (!CheckGrant(global::Common.Enum.TravelPermission.供应商管理_购物_新增))
{
Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.供应商管理_购物_新增, false);
}
break;
}
bindProandCity();
}
}
/// <summary>
/// 获取供应商购物实体
/// </summary>
/// <param name="id">ID</param>
/// <returns></returns>
public EyouSoft.Model.SupplierStructure.SupplierShopping GetModel(int id)
{
EyouSoft.Model.SupplierStructure.SupplierShopping model = null;
DbCommand cmd = this._db.GetStoredProcCommand("proc_Supplier_GetShopping");
this._db.AddInParameter(cmd, "Id", DbType.Int32, id);
using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(cmd, this._db))
{
if (rdr.Read())
{
#region 供应商-购物信息
model = new EyouSoft.Model.SupplierStructure.SupplierShopping();
model.Id = rdr.GetInt32(rdr.GetOrdinal("Id"));
model.ProvinceId = rdr.GetInt32(rdr.GetOrdinal("ProvinceId"));
model.ProvinceName = rdr.IsDBNull(rdr.GetOrdinal("ProvinceName")) ? "" : rdr.GetString(rdr.GetOrdinal("ProvinceName"));
model.CityId = rdr.GetInt32(rdr.GetOrdinal("CityId"));
model.CityName = rdr.IsDBNull(rdr.GetOrdinal("CityName")) ? "" : rdr.GetString(rdr.GetOrdinal("GuideWord"));
model.UnitName = rdr.GetString(rdr.GetOrdinal("UnitName"));
model.SupplierType = (EyouSoft.Model.EnumType.CompanyStructure.SupplierType)Enum.Parse(typeof(EyouSoft.Model.EnumType.CompanyStructure.SupplierType), rdr.GetByte(rdr.GetOrdinal("SupplierType")).ToString());
model.UnitAddress = rdr.IsDBNull(rdr.GetOrdinal("UnitAddress")) ? "" : rdr.GetString(rdr.GetOrdinal("UnitAddress"));
//model.c = rdr.GetInt32(rdr.GetOrdinal("Commission"));
model.AgreementFile = rdr.IsDBNull(rdr.GetOrdinal("AgreementFile")) ? "" : rdr.GetString(rdr.GetOrdinal("AgreementFile"));
model.TradeNum = rdr.GetInt32(rdr.GetOrdinal("TradeNum"));
model.Remark = rdr.IsDBNull(rdr.GetOrdinal("Remark")) ? "" : rdr.GetString(rdr.GetOrdinal("Remark"));
model.CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId"));
model.OperatorId = rdr.GetInt32(rdr.GetOrdinal("OperatorId"));
model.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
model.IsDelete = Convert.ToBoolean(rdr.GetOrdinal("IsDelete"));
model.SaleProduct = rdr.IsDBNull(rdr.GetOrdinal("SaleProduct")) ? "" : rdr.GetString(rdr.GetOrdinal("SaleProduct"));
model.GuideWord = rdr.IsDBNull(rdr.GetOrdinal("GuideWord")) ? "" : rdr.GetString(rdr.GetOrdinal("GuideWord"));
#endregion
#region 供应商联系人信息
rdr.NextResult();
IList <EyouSoft.Model.CompanyStructure.SupplierContact> ls = new List <EyouSoft.Model.CompanyStructure.SupplierContact>();
while (rdr.Read())
{
EyouSoft.Model.CompanyStructure.SupplierContact contactModel = new EyouSoft.Model.CompanyStructure.SupplierContact();
contactModel.Id = rdr.GetInt32(rdr.GetOrdinal("Id"));
contactModel.CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId"));
contactModel.SupplierId = rdr.GetInt32(rdr.GetOrdinal("SupplierId"));
contactModel.SupplierType = (EyouSoft.Model.EnumType.CompanyStructure.SupplierType)Enum.Parse(typeof(EyouSoft.Model.EnumType.CompanyStructure.SupplierType), rdr.GetByte(rdr.GetOrdinal("SupplierType")).ToString());
contactModel.ContactName = rdr.IsDBNull(rdr.GetOrdinal("ContactName")) ? "" : rdr.GetString(rdr.GetOrdinal("ContactName"));
contactModel.JobTitle = rdr.IsDBNull(rdr.GetOrdinal("JobTitle")) ? "" : rdr.GetString(rdr.GetOrdinal("JobTitle"));
contactModel.ContactFax = rdr.IsDBNull(rdr.GetOrdinal("ContactFax")) ? "" : rdr.GetString(rdr.GetOrdinal("ContactFax"));
contactModel.ContactTel = rdr.IsDBNull(rdr.GetOrdinal("ContactTel")) ? "" : rdr.GetString(rdr.GetOrdinal("ContactTel"));
contactModel.ContactMobile = rdr.IsDBNull(rdr.GetOrdinal("ContactMobile")) ? "" : rdr.GetString(rdr.GetOrdinal("ContactMobile"));
contactModel.QQ = rdr.IsDBNull(rdr.GetOrdinal("QQ")) ? "" : rdr.GetString(rdr.GetOrdinal("QQ"));
contactModel.Email = rdr.IsDBNull(rdr.GetOrdinal("Email")) ? "" : rdr.GetString(rdr.GetOrdinal("Email"));
ls.Add(contactModel);
contactModel = null;
}
#endregion
model.SupplierContact = ls;
}
}
return(model);
}
private void Save()
{
tid = Utils.GetInt(Utils.GetFormValue("tid"));
if (tid > 0)
{
ssModel = csBll.GetModel(tid);
}
else
{
ssModel.SupplierType = EyouSoft.Model.EnumType.CompanyStructure.SupplierType.购物;
}
if (string.IsNullOrEmpty(ssModel.AgreementFile))
{
string[] allowExtensions = new string[] { ".jpeg", ".jpg", ".bmp", ".gif", ".pdf", ".xls", ".xlsx", ".doc", ".docx", ".png", ".txt", ".rar" };
string msg = string.Empty;
bool nameForm = EyouSoft.Common.Function.UploadFile.CheckFileType(Request.Files, "workAgree", allowExtensions, null, out msg);
if (!nameForm)
{
lstMsg.Text = msg;
return;
}
}
ssModel.CityName = Utils.GetFormValue("cityname");
ssModel.ProvinceName = Utils.GetFormValue("proname");
ssModel.ProvinceId = ucProvince1.ProvinceId;
ssModel.CityId = ucCity1.CityId;
ssModel.UnitName = Utils.GetFormValue("unionname");
ssModel.SaleProduct = Utils.GetFormValue("goods");
ssModel.UnitAddress = Utils.GetFormValue("txtAddress");
ssModel.GuideWord = Utils.GetFormValue("tourGuids");
ssModel.Remark = Utils.GetFormValue("remark");
ssModel.SaleProduct = Utils.GetFormValue("goodsName");
if (Request.Files.Count > 0)
{
string filepath = string.Empty;
string oldfilename = string.Empty;
bool result = EyouSoft.Common.Function.UploadFile.FileUpLoad(Request.Files["workAgree"], "SupplierControlFile", out filepath, out oldfilename);
if (result)
{
ssModel.AgreementFile = filepath;
}
}
ssModel.CompanyId = this.SiteUserInfo.CompanyID;
ssModel.OperatorId = this.SiteUserInfo.ID;
ssModel.SupplierContact = new List <EyouSoft.Model.CompanyStructure.SupplierContact>();
string[] accmanname = Utils.GetFormValues("inname");
string[] accmandate = Utils.GetFormValues("indate");
string[] accmanphone = Utils.GetFormValues("inphone");
string[] accmanmobile = Utils.GetFormValues("inmobile");
string[] accmanfax = Utils.GetFormValues("infax");
string[] accmanqq = Utils.GetFormValues("inqq");
string[] accmanemail = Utils.GetFormValues("inemail");
for (int i = 0; i < accmanname.Length; i++)
{
EyouSoft.Model.CompanyStructure.SupplierContact scModel = new EyouSoft.Model.CompanyStructure.SupplierContact();
scModel.ContactName = accmanname[i];
scModel.JobTitle = accmandate[i];
scModel.ContactTel = accmanphone[i];
scModel.ContactMobile = accmanmobile[i];
scModel.QQ = accmanqq[i];
scModel.Email = accmanemail[i];
scModel.ContactFax = accmanfax[i];
scModel.SupplierType = EyouSoft.Model.EnumType.CompanyStructure.SupplierType.购物;
ssModel.SupplierContact.Add(scModel);
}
bool res = false;
if (tid > 0)
{
res = csBll.UpdateShopping(ssModel);
}
else
{
res = csBll.AddShopping(ssModel);
}
if (res)
{
MessageBox.ResponseScript(this, string.Format(";alert('{0}');window.parent.Boxy.getIframeDialog('{1}').hide();{2}", "保存成功!", Utils.GetQueryStringValue("iframeId"), tid > 0 ? "window.parent.location.reload();" : "window.parent.location.href='/SupplierControl/Shopping/Default.aspx';"));
}
else
{
MessageBox.ResponseScript(this, ";alert('保存失败!');");
}
}
/// <summary>
/// 添加供应商购物信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddShopping(EyouSoft.Model.SupplierStructure.SupplierShopping model)
{
int supplierId = supplierBase.AddSupplierBase(model);
return(Dal.AddShopping(model, supplierId));
}
