protected void InitPage()
{
DAL.McManaDAL.MerInfoMaintDAL func = new DAL.McManaDAL.MerInfoMaintDAL();
int mer_id = int.Parse(Request.QueryString["mer_id"]);
McBasicInfo mc = func.GetMerchantInfoByID(mer_id);
MerBas_Name.Text = mc.MerName;
MerBas_Intro.Text = mc.MerInfo;
MerBas_Pic.ImageUrl = mc.MerPic;
MerBas_Address.Text = mc.MerAddr;
MerBas_Phone.Text = mc.MerPhone;
MerBas_Web.Text = mc.MerWebsite;
MerBas_Email.Text = mc.RegEmail;
MerBas_Relat.Text = mc.RegName;
MerBas_StarLevel.Text = mc.MerStarLever.ToString();
string[] city_Pro = func.GetCityAndProvin(mc.CityID);
MerBas_Province.Text = city_Pro[1];
MerBas_City.Text = city_Pro[0];
int count = 0;
DataSet ds = func.GetAllProductByMerID(mer_id, AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, out count);
AspNetPager1.RecordCount = count;
PrdRpt.DataSource = ds;
PrdRpt.DataBind();
}
protected void InitPage()
{
int mer_id = int.Parse(Request.QueryString["mer_id"]);
MerInfoMaintDAL func = new MerInfoMaintDAL();
McBasicInfo mc = func.GetMerchantInfoByID(mer_id);
MerInfoMod_Name.Text = mc.MerName;
MerInfoMod_Introduction.Text = mc.MerInfo;
MerInfoMod_Pic.Src = mc.MerPic;
MerInfoMod_Address.Text = mc.MerAddr;
MerInfoMod_Telephone.Text = mc.MerPhone;
MerInfoMod_Website.Text = mc.MerWebsite;
MerInfoMod_Email.Text = mc.RegEmail;
MerInfoMod_Relat.Text = mc.RegName;
string[] city_Pro = func.GetCityAndProvin(mc.CityID);
MerInfoMod_Province.DataSource = func.GetAllProvince();
MerInfoMod_Province.DataValueField = "pro_id";
MerInfoMod_Province.DataTextField = "pro_name";
MerInfoMod_Province.DataBind();
MerInfoMod_Province.Text = city_Pro[1];
MerInfoMod_City.DataSource = func.GetAllCityByProvin(int.Parse(MerInfoMod_Province.SelectedValue));
MerInfoMod_City.DataValueField = "city_id";
MerInfoMod_City.DataTextField = "city_name";
MerInfoMod_City.DataBind();
MerInfoMod_City.Text = city_Pro[0];
}
/// <summary>
/// 修改商家信息
/// </summary>
/// <param name="mc">商家实体类</param>
/// <returns></returns>
public int UpdateMerchant(McBasicInfo mc)
{
DBConnection dbc = new DBConnection();
string sqlString = @"UPDATE [shuaka].[dbo].[mc_BasicInfo]
SET [city_id] = @city_id
,[mer_name] = @mer_name
,[mer_address] = @mer_address
,[mer_phone] = @mer_phone
,[mer_info]= @mer_info
,[reg_name] = @reg_name
,[reg_email] = @reg_email
,[mer_pic] = @mer_pic
,[mer_website] = @mer_website
,[mer_star_level] = @mer_star_level
WHERE [mer_id]=@mer_id";
SqlParameter[] paras =
{
new SqlParameter("city_id", mc.CityID),
new SqlParameter("mer_name", mc.MerName),
new SqlParameter("mer_address", mc.MerAddr),
new SqlParameter("mer_phone", mc.MerPhone),
new SqlParameter("mer_info", mc.MerInfo),
new SqlParameter("reg_name", mc.RegName),
new SqlParameter("reg_email", mc.RegEmail),
new SqlParameter("mer_pic", mc.MerPic),
new SqlParameter("mer_website", mc.MerWebsite),
new SqlParameter("mer_star_level", mc.MerStarLever),
new SqlParameter("mer_id", mc.MerID)
};
return(dbc.Execute(sqlString, paras));
}
/// <summary>
/// 更改商家信息
/// </summary>
public bool UpdateMerInfo(McBasicInfo mbi, string telephone)
{
dbc = new DBConnection();
strSql = @"UPDATE [shuaka].[dbo].[mc_BasicInfo]
SET [mer_type] = @MerType
,[mer_name] = @MerName
,[mer_address] = @MerAddr
,[mer_phone] = @MerPhone
,[mer_postcode] = @MerPostcode
,[mer_discount] = @MerDiscount
,[mer_pic] = @MerPic
,[mer_info] = @MerInfo
WHERE [reg_telephone]=@TeleP";
SqlParameter[] paras = { new SqlParameter("MerType", mbi.MerType),
new SqlParameter("MerName", mbi.MerName),
new SqlParameter("MerAddr", mbi.MerAddr),
new SqlParameter("MerPhone", mbi.MerPhone),
new SqlParameter("MerPostcode", mbi.MerPostcode),
new SqlParameter("MerDiscount", mbi.MerDiscount),
new SqlParameter("MerPic", mbi.MerPic),
new SqlParameter("MerInfo", mbi.MerInfo),
new SqlParameter("TeleP", telephone) };
if (dbc.Execute(strSql, paras) > 0)
{
return(true);
}
else
{
return(false);
}
}
static void Main(string[] args)
{
McBasicInfo mbi = new McBasicInfo();
mbi.IndID = 12304;
mbi.CityID = 23566;
mbi.MerType = "tt";
mbi.MerName = "bingbing";
mbi.MerAddr = "dfkjsfsdfjsd";
mbi.MerPhone = "1238651561";
mbi.MerPostcode = "0074";
mbi.MerDiscount = "15";
mbi.RegName = "nimei";
mbi.RegDuty = "jingli";
mbi.RegEmail = "dfdsf";
mbi.RegPhone = "12345678911";
mbi.RegTelePhone = "12345698712";
mbi.MerPwd = "dsfdfds";
mbi.MerPic = "C:\\";
mbi.MerInfo = "sdfsd";
mbi.MerWebsite = "www.baidu.com";
mbi.MerState = 0;
mbi.MerStarLever = 1;
mbi.RecMerState = true;
mbi.MerID = 123255;
mbi.MerAddr = "xianjiaoda";
JoinManaDAL jmd = new JoinManaDAL();
int j = jmd.AddMcDAL(mbi);
System.Console.Write(j);
LoginManaDAL lmd = new LoginManaDAL();
DBConnection dbc = new DBConnection();
System.Console.Write(lmd.McLogin("12345698712", "dsfdfds"));
}
/// <summary>
/// 商家加盟
/// </summary>
/// <param name="mcb"></param>
/// <returns></returns>
public bool JoinManage(McBasicInfo mcb)
{
JoinManaDAL jom = new JoinManaDAL();
jom.AddMcDAL(mcb);
return(true);
}
protected void InitPage()
{
MerInfoMaintDAL func = new MerInfoMaintDAL();
int mer_id = int.Parse(Session["user_ID"].ToString());
McBasicInfo mc = func.GetMerchantInfoByID(mer_id);
MerBas_Name.Text = mc.MerName;
MerBas_Intro.Text = mc.MerInfo;
MerBas_Pic.ImageUrl = Request.ApplicationPath + "/" + mc.MerPic;
MerBas_Address.Text = mc.MerAddr;
MerBas_Phone.Text = mc.MerPhone;
MerBas_Web.Text = mc.MerWebsite;
MerBas_Email.Text = mc.RegEmail;
MerBas_Relat.Text = mc.RegName;
MerBas_StarLevel.Text = "";
for (int i = 0; i < int.Parse(mc.MerStarLever.ToString()); i++)
{
MerBas_StarLevel.Text += " ★ ";
}
string[] city_Pro = func.GetCityAndProvin(mc.CityID);
MerBas_Province.Text = city_Pro[1];
MerBas_City.Text = city_Pro[0];
string state = "";
switch (mc.MerState)
{
case 0:
state = "未审核";
break;
case 1:
state = "已通过";
break;
case 2:
state = "未通过";
break;
}
MerBas_State.Text = state;
int count = 0;
DataSet ds = func.GetAllProductByMerID(mer_id, AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, out count);
AspNetPager1.RecordCount = count;
MerProductList.DataSource = ds;
MerProductList.DataBind();
}
protected void InitPage()
{
int mer_id = int.Parse(Request.QueryString["mer_id"]);
MerInfoMaintDAL func = new MerInfoMaintDAL();
McBasicInfo mc = func.GetMerchantInfoByID(mer_id);
MerInfoMod_Name.Text = mc.MerName;
MerInfoMod_Introduction.Text = mc.MerInfo;
MerInfoMod_Pic.ImageUrl = mc.MerPic;
MerInfoMod_Address.Text = mc.MerAddr;
MerInfoMod_Telephone.Text = mc.MerPhone;
MerInfoMod_Website.Text = mc.MerWebsite;
MerInfoMod_Email.Text = mc.RegEmail;
MerInfoMod_Relat.Text = mc.RegName;
MerInfoMod_StarLevel.SelectedValue = mc.MerStarLever.ToString();
MerInfoMod_Province.SelectedValue = "0";
MerInfoMod_City.SelectedValue = "0";
}
protected void UploadBtn_Click(object sender, EventArgs e)
{
if (!(uploadF.Value == null || uploadF.Value.Equals("")))
{
string path = uploadF.PostedFile.FileName;
string fileExt = path.Substring(path.LastIndexOf('.') + 1);
if (fileExt.ToLower().Equals("jpg") || fileExt.ToLower().Equals("png") || fileExt.ToLower().Equals("gif"))
{
string filePath = Server.MapPath("UpFiles") + "/mer_pic";
string serverName = DateTime.Now.ToString("yyyyMMddHHmmss") + "." + fileExt;
uploadF.PostedFile.SaveAs(filePath + "/" + serverName);
MerInfoMaintDAL func = new MerInfoMaintDAL();
McBasicInfo mc = new McBasicInfo();
int mer_id = int.Parse(Request.QueryString["mer_id"]);
mc.MerID = mer_id;
mc.MerName = MerInfoMod_Name.Text;
mc.MerInfo = MerInfoMod_Introduction.Text;
mc.MerAddr = MerInfoMod_Address.Text;
mc.MerPic = "UpFiles/mer_pic/" + serverName;
mc.MerPhone = MerInfoMod_Telephone.Text;
mc.MerWebsite = MerInfoMod_Website.Text;
mc.RegEmail = MerInfoMod_Email.Text;
mc.RegName = MerInfoMod_Relat.Text;
mc.CityID = int.Parse(MerInfoMod_City.SelectedValue);
func.UpdateMerchant(mc);
MerInfoMod_Pic.Src = "UpFiles/mer_pic/" + serverName;
}
else
{
Response.Write("<script>alert('不被允许的文件格式');</script>");
}
}
else
{
Response.Write("<script>alert('没有文件');</script>");
}
}
protected void MerJoin_Submit_Click(object sender, EventArgs e)
{
DAL.McManaDAL.JoinManaDAL jm = new DAL.McManaDAL.JoinManaDAL();
if (!jm.IsExist(MerJoin_RelaTelePhone.Text))
{
JoinManaBLL jmb = new JoinManaBLL();
McBasicInfo mcb = new McBasicInfo();
string indType = MerJoin_Type.SelectedValue.ToString();
mcb.IndID = Convert.ToInt32(indType);
mcb.CityID = jmb.GetCityIDByName(Cityddl.SelectedValue.ToString());
mcb.MerType = MerJoin_Type.SelectedValue.ToString();
mcb.MerName = MerJoin_Name.Text;
mcb.MerAddr = MerJoin_Address.Text;
mcb.MerPhone = MerJoin_Phone.Text;
mcb.MerPostcode = MerJoin_PostCode.Text;
mcb.MerDiscount = MerJoin_MemberDiscountRate.SelectedValue.ToString();
mcb.RegName = MerJoin_RelaName.Text;
mcb.RegDuty = MerJoin_RelaDuty.Text;
mcb.RegPhone = MerJoin_RelaPhone.Text;
mcb.RegTelePhone = MerJoin_RelaTelePhone.Text;
mcb.RegEmail = MerJoin_RelaEmail.Text;
mcb.MerPwd = MerJoin_Pwd.Value;
mcb.MerPic = "";
mcb.MerInfo = MerJoin_Info.Value;
mcb.MerWebsite = MerJoin_WebSite.Text;
mcb.MerState = 0;
mcb.RecMerState = false;
mcb.MerStarLever = 0;
jmb.JoinManage(mcb);
Response.Write("<script>alert('恭喜注册成功！');location.href='../MerchantLogin/MerchantLogin.aspx'</script>");
}
else
{
Response.Write("<script>alert('手机号已经被注册，请更换手机号！');</script>");
}
}
protected void MerInfoMod_Submit_Click(object sender, EventArgs e)
{
MerInfoMaintDAL func = new MerInfoMaintDAL();
McBasicInfo mc = new McBasicInfo();
int mer_id = int.Parse(Request.QueryString["mer_id"]);
mc.MerID = mer_id;
mc.MerName = MerInfoMod_Name.Text;
mc.MerInfo = MerInfoMod_Introduction.Text;
mc.MerPic = MerInfoMod_Pic.ImageUrl;
mc.MerAddr = MerInfoMod_Address.Text;
mc.MerPhone = MerInfoMod_Telephone.Text;
mc.MerWebsite = MerInfoMod_Website.Text;
mc.RegEmail = MerInfoMod_Email.Text;
mc.RegName = MerInfoMod_Relat.Text;
mc.MerStarLever = int.Parse(MerInfoMod_StarLevel.SelectedValue);
mc.CityID = 2;
func.UpdateMerchant(mc);
Response.Redirect("MerchantShowInfoProtect.aspx?mer_id=" + mer_id);
}
protected void MerInfoMod_Submit_Click(object sender, EventArgs e)
{
MerInfoMaintDAL func = new MerInfoMaintDAL();
McBasicInfo mc = new McBasicInfo();
int mer_id = int.Parse(Request.QueryString["mer_id"]);
McBasicInfo mc_old = func.GetMerchantInfoByID(mer_id);
mc.MerID = mer_id;
mc.MerName = MerInfoMod_Name.Text;
mc.MerInfo = MerInfoMod_Introduction.Text;
mc.MerAddr = MerInfoMod_Address.Text;
mc.MerPic = mc_old.MerPic;
mc.MerPhone = MerInfoMod_Telephone.Text;
mc.MerWebsite = MerInfoMod_Website.Text;
mc.RegEmail = MerInfoMod_Email.Text;
mc.RegName = MerInfoMod_Relat.Text;
mc.CityID = int.Parse(MerInfoMod_City.SelectedValue);
func.UpdateMerchant(mc);
Response.Redirect("MerchantManage/MerShowInfoMaintain.aspx?mer_id=" + mer_id);
}
/// <summary>
/// 根据商家ID获得商家信息
/// </summary>
/// <param name="mer_id">商家ID</param>
/// <returns></returns>
public McBasicInfo GetMerchantInfoByID(int mer_id)
{
DBConnection dbc = new DBConnection();
string sqlString = @"SELECT [mer_id]
,[ind_id]
,[city_id]
,[mer_type]
,[mer_name]
,[mer_address]
,[mer_phone]
,[mer_postcode]
,[mer_discount]
,[reg_name]
,[reg_duty]
,[reg_phone]
,[reg_telephone]
,[reg_email]
,[mer_pwd]
,[mer_pic]
,[mer_info]
,[mer_website]
,case [mer_state] when 1 then '可用' else '不可用' end as mer_state
,[rec_mer_state]
,[mer_star_level]
FROM [shuaka].[dbo].[mc_BasicInfo]
WHERE [mer_id]= @mer_id";
SqlParameter[] paras =
{
new SqlParameter("mer_id", mer_id)
};
DataSet ds = dbc.GetDataSet(sqlString, paras);
object[] mc_Array = ds.Tables[0].Rows[0].ItemArray;
McBasicInfo mc = new McBasicInfo();
mc.MerID = int.Parse((mc_Array[0]).ToString());
mc.IndID = int.Parse(mc_Array[1].ToString());
mc.CityID = int.Parse(mc_Array[2].ToString());
mc.MerType = mc_Array[3].ToString();
mc.MerName = mc_Array[4].ToString();
mc.MerAddr = mc_Array[5].ToString();
mc.MerPhone = mc_Array[6].ToString();
mc.MerPostcode = mc_Array[7].ToString();
mc.MerDiscount = mc_Array[8].ToString();
mc.RegName = mc_Array[9].ToString();
mc.RegDuty = mc_Array[10].ToString();
mc.RegPhone = mc_Array[11].ToString();
mc.RegTelePhone = mc_Array[12].ToString();
mc.RegEmail = mc_Array[13].ToString();
mc.MerPwd = mc_Array[14].ToString();
mc.MerPic = mc_Array[15].ToString();
mc.MerInfo = mc_Array[16].ToString();
mc.MerWebsite = mc_Array[17].ToString();
mc.MerState = (mc_Array[18].ToString().Equals("可用") == true ? 1 : 0);
mc.RecMerState = mc_Array[19].ToString().Equals("1") ? true : false;
mc.MerStarLever = int.Parse(mc_Array[20].ToString());
return(mc);
}
//入盟申请，插入记录
public int AddMcDAL(McBasicInfo mcb)
{
string strSql = @"INSERT INTO [shuaka].[dbo].[mc_BasicInfo]
([ind_id]
,[city_id]
,[mer_type]
,[mer_name]
,[mer_address]
,[mer_phone]
,[mer_postcode]
,[mer_discount]
,[reg_name]
,[reg_duty]
,[reg_phone]
,[reg_telephone]
,[reg_email]
,[mer_pwd]
,[mer_pic]
,[mer_info]
,[mer_website]
,[mer_state]
,[rec_mer_state]
,[mer_star_level])
VALUES
(@IndID
,@CityID
,@MerType
,@MerName
,@MerAddress
,@MerPhone
,@MerPostCode
,@MerDiscount
,@RegName
,@RegDuty
,@RegPhone
,@RegTelephone
,@RegEmail
,@MerPwd
,@MerPic
,@MerInfo
,@MerWebsite
,@MerState
,@RecMerState
,@MerStarLevel) SELECT @@IDENTITY AS 'mer_id'";
SqlParameter[] paras = { new SqlParameter("IndID", mcb.IndID),
new SqlParameter("CityID", mcb.CityID),
new SqlParameter("MerType", mcb.MerType),
new SqlParameter("MerName", mcb.MerName),
new SqlParameter("MerAddress", mcb.MerAddr),
new SqlParameter("MerPhone", mcb.MerPhone),
new SqlParameter("MerPostCode", mcb.MerPostcode),
new SqlParameter("MerDiscount", mcb.MerDiscount),
new SqlParameter("RegName", mcb.RegName),
new SqlParameter("RegDuty", mcb.RegDuty),
new SqlParameter("RegPhone", mcb.RegPhone),
new SqlParameter("RegTelephone", mcb.RegTelePhone),
new SqlParameter("RegEmail", mcb.RegEmail),
new SqlParameter("MerPwd", mcb.MerPwd),
new SqlParameter("MerPic", mcb.MerPic),
new SqlParameter("MerInfo", mcb.MerInfo),
new SqlParameter("MerWebsite", mcb.MerWebsite),
new SqlParameter("MerState", mcb.MerState),
new SqlParameter("RecMerState", mcb.RecMerState),
new SqlParameter("MerStarLevel", mcb.MerStarLever) };
ds = dbc.GetDataSet(strSql, paras);
string temp = ds.Tables[0].Rows[0]["mer_id"].ToString();
return(Convert.ToInt32(temp));
}
