/// <summary>
/// 得到一个对象实体
/// </summary>
public MemberInfoModel GetModel(int memberId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from T_Member_Info ");
strSql.Append(" where memberId=@memberId ");
SqlParameter[] parameters =
{
new SqlParameter("@memberId", SqlDbType.Int, 4)
};
parameters[0].Value = memberId;
MemberInfoModel model = new MemberInfoModel();
DataSet ds = adoHelper.ExecuteSqlDataset(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["memberId"].ToString() != "")
{
model.memberId = int.Parse(ds.Tables[0].Rows[0]["memberId"].ToString());
}
model.memberName = ds.Tables[0].Rows[0]["memberName"].ToString();
model.password = ds.Tables[0].Rows[0]["password"].ToString();
model.memberStatus = ds.Tables[0].Rows[0]["memberStatus"].ToString();
model.memberType = ds.Tables[0].Rows[0]["memberType"].ToString();
model.memberCompanyType = ds.Tables[0].Rows[0]["memberCompanyType"].ToString();
model.areaName = ds.Tables[0].Rows[0]["areaName"].ToString();
model.memberCompanyName = ds.Tables[0].Rows[0]["memberCompanyName"].ToString();
model.memberCompanyCode = ds.Tables[0].Rows[0]["memberCompanyCode"].ToString();
model.memberTrueName = ds.Tables[0].Rows[0]["memberTrueName"].ToString();
model.sex = ds.Tables[0].Rows[0]["sex"].ToString();
model.tel = ds.Tables[0].Rows[0]["tel"].ToString();
model.fax = ds.Tables[0].Rows[0]["fax"].ToString();
model.mobile = ds.Tables[0].Rows[0]["mobile"].ToString();
model.address = ds.Tables[0].Rows[0]["address"].ToString();
model.post = ds.Tables[0].Rows[0]["post"].ToString();
model.email = ds.Tables[0].Rows[0]["email"].ToString();
if (ds.Tables[0].Rows[0]["regTime"].ToString() != "")
{
model.regTime = DateTime.Parse(ds.Tables[0].Rows[0]["regTime"].ToString());
}
//model.regType = ds.Tables[0].Rows[0]["regType"].ToString();
if (ds.Tables[0].Rows[0]["shFlag"].ToString() != "")
{
model.shFlag = int.Parse(ds.Tables[0].Rows[0]["shFlag"].ToString());
}
if (ds.Tables[0].Rows[0]["shTime"].ToString() != "")
{
model.shTime = DateTime.Parse(ds.Tables[0].Rows[0]["shTime"].ToString());
}
model.shPerson = ds.Tables[0].Rows[0]["shPerson"].ToString();
model.unPassReason = ds.Tables[0].Rows[0]["unPassReason"].ToString();
if (ds.Tables[0].Rows[0]["buyMoneyAccount"].ToString() != "")
{
model.buyMoneyAccount = decimal.Parse(ds.Tables[0].Rows[0]["buyMoneyAccount"].ToString());
}
if (ds.Tables[0].Rows[0]["buyMoneyAccountUsed"].ToString() != "")
{
model.buyMoneyAccountUsed = decimal.Parse(ds.Tables[0].Rows[0]["buyMoneyAccountUsed"].ToString());
}
if (ds.Tables[0].Rows[0]["freeMoenyAccount"].ToString() != "")
{
model.freeMoenyAccount = decimal.Parse(ds.Tables[0].Rows[0]["freeMoenyAccount"].ToString());
}
if (ds.Tables[0].Rows[0]["freeMoenyAccountUsed"].ToString() != "")
{
model.freeMoenyAccountUsed = decimal.Parse(ds.Tables[0].Rows[0]["freeMoenyAccountUsed"].ToString());
}
model.memberLevel = ds.Tables[0].Rows[0]["memberLevel"].ToString();
if (ds.Tables[0].Rows[0]["levelServiceStartTime"].ToString() != "")
{
model.levelServiceStartTime = DateTime.Parse(ds.Tables[0].Rows[0]["levelServiceStartTime"].ToString());
}
if (ds.Tables[0].Rows[0]["levelServiceEndTime"].ToString() != "")
{
model.levelServiceEndTime = DateTime.Parse(ds.Tables[0].Rows[0]["levelServiceEndTime"].ToString());
}
if (ds.Tables[0].Rows[0]["iscompany"].ToString() != "")
{
model.iscompany = int.Parse(ds.Tables[0].Rows[0]["iscompany"].ToString());
}
if (ds.Tables[0].Rows[0]["ishangzhou"].ToString() != "")
{
model.ishangzhou = int.Parse(ds.Tables[0].Rows[0]["ishangzhou"].ToString());
}
model.companyInfo = ds.Tables[0].Rows[0]["companyInfo"].ToString();
model.url_qy = ds.Tables[0].Rows[0]["url_qy"].ToString();
model.url_business = ds.Tables[0].Rows[0]["url_business"].ToString();
if (ds.Tables[0].Rows[0]["downloadNumber"].ToString() != "")
{
model.downloadNumber = int.Parse(ds.Tables[0].Rows[0]["downloadNumber"].ToString());
}
if (ds.Tables[0].Rows[0]["trustNumber"].ToString() != "")
{
model.trustNumber = int.Parse(ds.Tables[0].Rows[0]["trustNumber"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MemberInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Member_Info(");
strSql.Append("memberName,password,memberStatus,memberInPlatfroms,memberType,memberCompanyType,areaName,memberCompanyName,memberCompanyCode,memberTrueName,sex,tel,fax,mobile,address,post,email,regTime,regType,shFlag,shTime,shPerson,unPassReason,buyMoneyAccount,buyMoneyAccountUsed,freeMoenyAccount,freeMoenyAccountUsed,memberLevel,levelServiceStartTime,levelServiceEndTime,ishangzhou,iscompany,companyinfo,url_qy,url_business,downloadNumber,trustNumber)");
strSql.Append(" values (");
strSql.Append("@memberName,@password,@memberStatus,@memberInPlatfroms,@memberType,@memberCompanyType,@areaName,@memberCompanyName,@memberCompanyCode,@memberTrueName,@sex,@tel,@fax,@mobile,@address,@post,@email,@regTime,@regType,@shFlag,@shTime,@shPerson,@unPassReason,@buyMoneyAccount,@buyMoneyAccountUsed,@freeMoenyAccount,@freeMoenyAccountUsed,@memberLevel,@levelServiceStartTime,@levelServiceEndTime,@ishangzhou,@iscompany,@companyinfo,@url_qy,@url_business,@downloadNumber,@trustNumber)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@memberName", SqlDbType.VarChar, 50),
new SqlParameter("@password", SqlDbType.VarChar, 50),
new SqlParameter("@memberStatus", SqlDbType.VarChar, 50),
new SqlParameter("@memberInPlatfroms", SqlDbType.VarChar, 50),
new SqlParameter("@memberType", SqlDbType.VarChar, 50),
new SqlParameter("@memberCompanyType", SqlDbType.VarChar, 50),
new SqlParameter("@areaName", SqlDbType.VarChar, 50),
new SqlParameter("@memberCompanyName", SqlDbType.VarChar, 100),
new SqlParameter("@memberCompanyCode", SqlDbType.VarChar, 50),
new SqlParameter("@memberTrueName", SqlDbType.VarChar, 50),
new SqlParameter("@sex", SqlDbType.VarChar, 50),
new SqlParameter("@tel", SqlDbType.VarChar, 50),
new SqlParameter("@fax", SqlDbType.VarChar, 50),
new SqlParameter("@mobile", SqlDbType.VarChar, 50),
new SqlParameter("@address", SqlDbType.VarChar, 500),
new SqlParameter("@post", SqlDbType.VarChar, 50),
new SqlParameter("@email", SqlDbType.VarChar, 50),
new SqlParameter("@regTime", SqlDbType.DateTime),
new SqlParameter("@regType", SqlDbType.VarChar, 50),
new SqlParameter("@shFlag", SqlDbType.Int, 4),
new SqlParameter("@shTime", SqlDbType.DateTime),
new SqlParameter("@shPerson", SqlDbType.VarChar, 50),
new SqlParameter("@unPassReason", SqlDbType.VarChar, 500),
new SqlParameter("@buyMoneyAccount", SqlDbType.Decimal, 9),
new SqlParameter("@buyMoneyAccountUsed", SqlDbType.Decimal, 9),
new SqlParameter("@freeMoenyAccount", SqlDbType.Decimal, 9),
new SqlParameter("@freeMoenyAccountUsed", SqlDbType.Decimal, 9),
new SqlParameter("@memberLevel", SqlDbType.VarChar, 50),
new SqlParameter("@levelServiceStartTime", SqlDbType.DateTime),
new SqlParameter("@levelServiceEndTime", SqlDbType.DateTime),
new SqlParameter("@ishangzhou", SqlDbType.Int, 4),
new SqlParameter("@iscompany", SqlDbType.Int, 4),
new SqlParameter("@companyinfo", SqlDbType.VarChar, 500),
new SqlParameter("@url_qy", SqlDbType.VarChar, 500),
new SqlParameter("@url_business", SqlDbType.VarChar, 500),
new SqlParameter("@downloadNumber", SqlDbType.Int, 4),
new SqlParameter("@trustNumber", SqlDbType.Int, 4)
};
parameters[0].Value = model.memberName;
parameters[1].Value = model.password;
parameters[2].Value = model.memberStatus;
parameters[3].Value = model.memberInPlatfroms;
parameters[4].Value = model.memberType;
parameters[5].Value = model.memberCompanyType;
parameters[6].Value = model.areaName;
parameters[7].Value = model.memberCompanyName;
parameters[8].Value = model.memberCompanyCode;
parameters[9].Value = model.memberTrueName;
parameters[10].Value = model.sex;
parameters[11].Value = model.tel;
parameters[12].Value = model.fax;
parameters[13].Value = model.mobile;
parameters[14].Value = model.address;
parameters[15].Value = model.post;
parameters[16].Value = model.email;
parameters[17].Value = model.regTime;
parameters[18].Value = model.regType;
parameters[19].Value = model.shFlag;
parameters[20].Value = model.shTime;
parameters[21].Value = model.shPerson;
parameters[22].Value = model.unPassReason;
parameters[23].Value = model.buyMoneyAccount;
parameters[24].Value = model.buyMoneyAccountUsed;
parameters[25].Value = model.freeMoenyAccount;
parameters[26].Value = model.freeMoenyAccountUsed;
parameters[27].Value = model.memberLevel;
parameters[28].Value = model.levelServiceStartTime;
parameters[29].Value = model.levelServiceEndTime;
parameters[30].Value = model.ishangzhou;
parameters[31].Value = model.iscompany;
parameters[32].Value = model.companyInfo;
parameters[33].Value = model.url_qy;
parameters[34].Value = model.url_business;
parameters[35].Value = model.downloadNumber;
parameters[36].Value = model.trustNumber;
object obj = adoHelper.ExecuteSqlScalar(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(MemberInfoModel model)
{
return(dal.Update(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(MemberInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Member_Info set ");
strSql.Append("memberName=@memberName,");
strSql.Append("password=@password,");
strSql.Append("memberStatus=@memberStatus,");
strSql.Append("memberInPlatfroms=@memberInPlatfroms,");
strSql.Append("memberType=@memberType,");
strSql.Append("memberCompanyType=@memberCompanyType,");
strSql.Append("areaName=@areaName,");
strSql.Append("memberCompanyName=@memberCompanyName,");
strSql.Append("memberCompanyCode=@memberCompanyCode,");
strSql.Append("memberTrueName=@memberTrueName,");
strSql.Append("sex=@sex,");
strSql.Append("tel=@tel,");
strSql.Append("fax=@fax,");
strSql.Append("mobile=@mobile,");
strSql.Append("address=@address,");
strSql.Append("post=@post,");
strSql.Append("email=@email,");
strSql.Append("regTime=@regTime,");
strSql.Append("regType=@regType,");
strSql.Append("shFlag=@shFlag,");
strSql.Append("shTime=@shTime,");
strSql.Append("shPerson=@shPerson,");
strSql.Append("unPassReason=@unPassReason,");
strSql.Append("buyMoneyAccount=@buyMoneyAccount,");
strSql.Append("buyMoneyAccountUsed=@buyMoneyAccountUsed,");
strSql.Append("freeMoenyAccount=@freeMoenyAccount,");
strSql.Append("freeMoenyAccountUsed=@freeMoenyAccountUsed,");
strSql.Append("memberLevel=@memberLevel,");
strSql.Append("levelServiceStartTime=@levelServiceStartTime,");
strSql.Append("levelServiceEndTime=@levelServiceEndTime,");
strSql.Append("companyinfo=@companyinfo,");
strSql.Append("url_qy=@url_qy,");
strSql.Append("url_business=@url_business, ");
strSql.Append("downloadNumber=@downloadNumber, ");
strSql.Append("trustNumber=@trustNumber ");
strSql.Append(" where memberId=@memberId ");
SqlParameter[] parameters =
{
new SqlParameter("@memberId", SqlDbType.Int, 4),
new SqlParameter("@memberName", SqlDbType.VarChar, 50),
new SqlParameter("@password", SqlDbType.VarChar, 50),
new SqlParameter("@memberStatus", SqlDbType.VarChar, 50),
new SqlParameter("@memberInPlatfroms", SqlDbType.VarChar, 50),
new SqlParameter("@memberType", SqlDbType.VarChar, 50),
new SqlParameter("@memberCompanyType", SqlDbType.VarChar, 50),
new SqlParameter("@areaName", SqlDbType.VarChar, 50),
new SqlParameter("@memberCompanyName", SqlDbType.VarChar, 100),
new SqlParameter("@memberCompanyCode", SqlDbType.VarChar, 50),
new SqlParameter("@memberTrueName", SqlDbType.VarChar, 50),
new SqlParameter("@sex", SqlDbType.VarChar, 50),
new SqlParameter("@tel", SqlDbType.VarChar, 50),
new SqlParameter("@fax", SqlDbType.VarChar, 50),
new SqlParameter("@mobile", SqlDbType.VarChar, 50),
new SqlParameter("@address", SqlDbType.VarChar, 500),
new SqlParameter("@post", SqlDbType.VarChar, 50),
new SqlParameter("@email", SqlDbType.VarChar, 50),
new SqlParameter("@regTime", SqlDbType.DateTime),
new SqlParameter("@regType", SqlDbType.VarChar, 50),
new SqlParameter("@shFlag", SqlDbType.Int, 4),
new SqlParameter("@shTime", SqlDbType.DateTime),
new SqlParameter("@shPerson", SqlDbType.VarChar, 50),
new SqlParameter("@unPassReason", SqlDbType.VarChar, 500),
new SqlParameter("@buyMoneyAccount", SqlDbType.Decimal, 9),
new SqlParameter("@buyMoneyAccountUsed", SqlDbType.Decimal, 9),
new SqlParameter("@freeMoenyAccount", SqlDbType.Decimal, 9),
new SqlParameter("@freeMoenyAccountUsed", SqlDbType.Decimal, 9),
new SqlParameter("@memberLevel", SqlDbType.VarChar, 50),
new SqlParameter("@levelServiceStartTime", SqlDbType.DateTime),
new SqlParameter("@levelServiceEndTime", SqlDbType.DateTime),
new SqlParameter("@companyinfo", SqlDbType.VarChar, 500),
new SqlParameter("@url_qy", SqlDbType.VarChar, 500),
new SqlParameter("@url_business", SqlDbType.VarChar, 500),
new SqlParameter("@downloadNumber", SqlDbType.Int, 4),
new SqlParameter("@trustNumber", SqlDbType.Int, 4)
};
parameters[0].Value = model.memberId;
parameters[1].Value = model.memberName;
parameters[2].Value = model.password;
parameters[3].Value = model.memberStatus;
parameters[4].Value = model.memberInPlatfroms;
parameters[5].Value = model.memberType;
parameters[6].Value = model.memberCompanyType;
parameters[7].Value = model.areaName;
parameters[8].Value = model.memberCompanyName;
parameters[9].Value = model.memberCompanyCode;
parameters[10].Value = model.memberTrueName;
parameters[11].Value = model.sex;
parameters[12].Value = model.tel;
parameters[13].Value = model.fax;
parameters[14].Value = model.mobile;
parameters[15].Value = model.address;
parameters[16].Value = model.post;
parameters[17].Value = model.email;
parameters[18].Value = model.regTime;
parameters[19].Value = model.regType;
parameters[20].Value = model.shFlag;
parameters[21].Value = model.shTime;
parameters[22].Value = model.shPerson;
parameters[23].Value = model.unPassReason;
parameters[24].Value = model.buyMoneyAccount;
parameters[25].Value = model.buyMoneyAccountUsed;
parameters[26].Value = model.freeMoenyAccount;
parameters[27].Value = model.freeMoenyAccountUsed;
parameters[28].Value = model.memberLevel;
parameters[29].Value = model.levelServiceStartTime;
parameters[30].Value = model.levelServiceEndTime;
parameters[31].Value = model.companyInfo;
parameters[32].Value = model.url_qy;
parameters[33].Value = model.url_business;
parameters[34].Value = model.downloadNumber;
parameters[35].Value = model.trustNumber;
return(adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MemberInfoModel model)
{
return(dal.Add(model));
}