/// <summary>
/// 得到一个对象实体
/// </summary>
public Leadin.Model.MemberDetail DataRowToModel(DataRow row)
{
Leadin.Model.MemberDetail model = new Leadin.Model.MemberDetail();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["MemberId"] != null && row["MemberId"].ToString() != "")
{
model.MemberId = int.Parse(row["MemberId"].ToString());
}
if (row["Sex"] != null && row["Sex"].ToString() != "")
{
model.Sex = int.Parse(row["Sex"].ToString());
}
if (row["Age"] != null && row["Age"].ToString() != "")
{
model.Age = int.Parse(row["Age"].ToString());
}
if (row["CompanyName"] != null)
{
model.CompanyName = row["CompanyName"].ToString();
}
if (row["CompanyAddress"] != null)
{
model.CompanyAddress = row["CompanyAddress"].ToString();
}
if (row["Position"] != null)
{
model.Position = row["Position"].ToString();
}
if (row["Birthday"] != null && row["Birthday"].ToString() != "")
{
model.Birthday = DateTime.Parse(row["Birthday"].ToString());
}
if (row["NameInfo"] != null)
{
model.NameInfo = row["NameInfo"].ToString();
}
if (row["SubName"] != null)
{
model.SubName = row["SubName"].ToString();
}
if (row["City"] != null)
{
model.City = row["City"].ToString();
}
if (row["AddressInfo"] != null)
{
model.AddressInfo = row["AddressInfo"].ToString();
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Leadin.Model.MemberDetail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_MemberDetail set ");
strSql.Append("MemberId=@MemberId,");
strSql.Append("Sex=@Sex,");
strSql.Append("Age=@Age,");
strSql.Append("CompanyName=@CompanyName,");
strSql.Append("CompanyAddress=@CompanyAddress,");
strSql.Append("Position=@Position,");
strSql.Append("Birthday=@Birthday,");
strSql.Append("NameInfo=@NameInfo,");
strSql.Append("SubName=@SubName,");
strSql.Append("City=@City,");
strSql.Append("AddressInfo=@AddressInfo,");
strSql.Append("Remark=@Remark");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@MemberId", SqlDbType.Int, 4),
new SqlParameter("@Sex", SqlDbType.Int, 4),
new SqlParameter("@Age", SqlDbType.Int, 4),
new SqlParameter("@CompanyName", SqlDbType.NVarChar, 200),
new SqlParameter("@CompanyAddress", SqlDbType.NVarChar, 200),
new SqlParameter("@Position", SqlDbType.NVarChar, 200),
new SqlParameter("@Birthday", SqlDbType.DateTime),
new SqlParameter("@NameInfo", SqlDbType.NVarChar, 100),
new SqlParameter("@SubName", SqlDbType.NVarChar, 100),
new SqlParameter("@City", SqlDbType.NVarChar, 100),
new SqlParameter("@AddressInfo", SqlDbType.NVarChar, 200),
new SqlParameter("@Remark", SqlDbType.NText),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = model.MemberId;
parameters[1].Value = model.Sex;
parameters[2].Value = model.Age;
parameters[3].Value = model.CompanyName;
parameters[4].Value = model.CompanyAddress;
parameters[5].Value = model.Position;
parameters[6].Value = model.Birthday;
parameters[7].Value = model.NameInfo;
parameters[8].Value = model.SubName;
parameters[9].Value = model.City;
parameters[10].Value = model.AddressInfo;
parameters[11].Value = model.Remark;
parameters[12].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Leadin.Model.MemberDetail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_MemberDetail(");
strSql.Append("MemberId,Sex,Age,CompanyName,CompanyAddress,Position,Birthday,NameInfo,SubName,City,AddressInfo,Remark)");
strSql.Append(" values (");
strSql.Append("@MemberId,@Sex,@Age,@CompanyName,@CompanyAddress,@Position,@Birthday,@NameInfo,@SubName,@City,@AddressInfo,@Remark)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@MemberId", SqlDbType.Int, 4),
new SqlParameter("@Sex", SqlDbType.Int, 4),
new SqlParameter("@Age", SqlDbType.Int, 4),
new SqlParameter("@CompanyName", SqlDbType.NVarChar, 200),
new SqlParameter("@CompanyAddress", SqlDbType.NVarChar, 200),
new SqlParameter("@Position", SqlDbType.NVarChar, 200),
new SqlParameter("@Birthday", SqlDbType.DateTime),
new SqlParameter("@NameInfo", SqlDbType.NVarChar, 100),
new SqlParameter("@SubName", SqlDbType.NVarChar, 100),
new SqlParameter("@City", SqlDbType.NVarChar, 100),
new SqlParameter("@AddressInfo", SqlDbType.NVarChar, 200),
new SqlParameter("@Remark", SqlDbType.NText)
};
parameters[0].Value = model.MemberId;
parameters[1].Value = model.Sex;
parameters[2].Value = model.Age;
parameters[3].Value = model.CompanyName;
parameters[4].Value = model.CompanyAddress;
parameters[5].Value = model.Position;
parameters[6].Value = model.Birthday;
parameters[7].Value = model.NameInfo;
parameters[8].Value = model.SubName;
parameters[9].Value = model.City;
parameters[10].Value = model.AddressInfo;
parameters[11].Value = model.Remark;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Leadin.Model.MemberDetail GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,MemberId,Sex,Age,CompanyName,CompanyAddress,Position,Birthday,NameInfo,SubName,City,AddressInfo,Remark from tb_MemberDetail ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
Leadin.Model.MemberDetail model = new Leadin.Model.MemberDetail();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 提交信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnOk_Click(object sender, EventArgs e)
{
Leadin.Model.Member model = new Leadin.Model.Member();
Leadin.Model.MemberDetail modeldetail = new Leadin.Model.MemberDetail();
bool IsEdit = string.IsNullOrEmpty(Request.Params["id"]);
if (!IsEdit)
{
model = bll.GetModel(int.Parse(Request.Params["id"]));
modeldetail = blldetail.GetModel(int.Parse(blldetail.GetList("MemberId=" + model.Id).Tables[0].Rows[0]["Id"].ToString()));
}
model.Account = txtAccount.Text;
model.Email = txtEmail.Text;
model.HeaderImg = txtHeaderImg.Text;
model.OpenId = "";
model.Phone = txtPhone.Text;
model.Pwd = Leadin.Common.DESEncrypt.Encrypt(txtPass.Text);
model.StateInfo = ckState.Checked ? 1 : 0;
model.TypeId = int.Parse(ddlType.SelectedValue);
modeldetail.AddressInfo = txtAddress.Text;
modeldetail.Age = int.Parse(txtAge.Text);
modeldetail.CompanyAddress = txtCompanyAddress.Text;
modeldetail.CompanyName = txtCompanyName.Text;
modeldetail.NameInfo = txtName.Text;
modeldetail.Position = txtPosition.Text;
modeldetail.Remark = txtRemark.Text;
modeldetail.Sex = rbman.Checked ? 1 : (rbwoman.Checked ? 0 : 3);
modeldetail.SubName = txtSubName.Text;
if (IsEdit)
{
model.AddTime = DateTime.Now;
model.Num = SetNumId("VIP");
int mid = bll.Add(model);
modeldetail.MemberId = mid;
if (mid > 0)
{
if (blldetail.Add(modeldetail) > 0)
{
JsMessage("success", "会员添加成功！", 1000, "List.aspx");
}
else
{
JsMessage("error", "会员添加失败，请检查您的输入！", 1000, "back");
}
}
else
{
JsMessage("error", "会员添加失败，请检查您的输入！", 1000, "back");
}
}
else
{
if (bll.Update(model))
{
if (blldetail.Update(modeldetail))
{
JsMessage("success", "会员编辑成功！", 1000, "List.aspx");
}
else
{
JsMessage("error", "会员编辑失败，请检查您的输入！", 1000, "back");
}
}
else
{
JsMessage("error", "会员编辑失败，请检查您的输入！", 1000, "back");
}
}
}
/// <summary>
/// 导入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDaoru_Click(object sender, EventArgs e)
{
if (fileExecl.FileName != "")
{
DataTable tblOrder = ExcelRender.RenderFromExcel(fileExecl.FileContent);
int successNum = 0;
int errorNum = 0;
foreach (DataRow item in tblOrder.Rows)
{
if (bll.GetList(" Account='" + item["会员帐号"].ToString() + "'").Tables[0].Rows.Count <= 0)
{
Leadin.Model.Member model = new Leadin.Model.Member();
model.Account = item["会员帐号"].ToString();
//model.AddTime = Convert.ToDateTime(item["注册时间"].ToString());
model.Email = item["邮箱"].ToString();
model.HeaderImg = "";
model.Num = SetNumId("VIP");
model.OpenId = "";
model.Phone = item["会员手机号"].ToString();
model.Pwd = Leadin.Common.DESEncrypt.Encrypt("vanyin888");
model.StateInfo = 1;
model.TypeId = 10000;
int mid = bll.Add(model);
if (mid > 0)
{
Leadin.Model.MemberDetail modeldetail = new Leadin.Model.MemberDetail();
modeldetail.AddressInfo = "";
modeldetail.Age = 0;
modeldetail.City = "";
modeldetail.CompanyAddress = item["具体地址"].ToString();
modeldetail.CompanyName = item["会员昵称"].ToString();
modeldetail.MemberId = mid;
modeldetail.NameInfo = item["会员真实姓名"].ToString();
modeldetail.Position = "";
modeldetail.Remark = item["项目编号"].ToString();
modeldetail.Sex = 1;
modeldetail.SubName = "";
if (bllDetail.Add(modeldetail) > 0)
{
successNum++;
}
else
{
errorNum++;
}
}
else
{
errorNum++;
}
}
}
JsMessage("success", "数据导入成功", 1000, "List.aspx");
}
else
{
JsMessage("error", "请选择文件", 1000, "back");
}
}
