/// <summary>
/// 增加用户
/// </summary>
public int Add(Tz888.Model.Mail.MailInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MailInfo(");
strSql.Append("LoginName,UserName,PanyName,PositionId,Address,LinkUrl,audit,ProvinceId,CityId,industry,Mial,Mobile,Phone,typeID,groupID,remark,Mdatetime)");
strSql.Append(" values (");
strSql.Append("@LoginName,@UserName,@PanyName,@PositionId,@Address,@LinkUrl,@audit,@ProvinceId,@CityId,@industry,@Mial,@Mobile,@Phone,@typeID,@groupID,@remark,@Mdatetime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@LoginName", SqlDbType.NVarChar, 200),
new SqlParameter("@UserName", SqlDbType.VarChar, 100),
new SqlParameter("@PanyName", SqlDbType.NVarChar, 200),
new SqlParameter("@PositionId", SqlDbType.Int, 4),
new SqlParameter("@Address", SqlDbType.NVarChar, 300),
new SqlParameter("@LinkUrl", SqlDbType.NVarChar, 300),
new SqlParameter("@audit", SqlDbType.Int, 4),
new SqlParameter("@ProvinceId", SqlDbType.Int, 4),
new SqlParameter("@CityId", SqlDbType.Int, 4),
new SqlParameter("@industry", SqlDbType.Int, 4),
new SqlParameter("@Mial", SqlDbType.NVarChar, 200),
new SqlParameter("@Mobile", SqlDbType.VarChar, 50),
new SqlParameter("@Phone", SqlDbType.VarChar, 50),
new SqlParameter("@typeID", SqlDbType.Int, 4),
new SqlParameter("@groupID", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.VarChar, 200),
new SqlParameter("@Mdatetime", SqlDbType.DateTime)
};
parameters[0].Value = model.LoginName;
parameters[1].Value = model.UserName;
parameters[2].Value = model.PanyName;
parameters[3].Value = model.PositionId;
parameters[4].Value = model.Address;
parameters[5].Value = model.LinkUrl;
parameters[6].Value = model.audit;
parameters[7].Value = model.ProvinceId;
parameters[8].Value = model.CityId;
parameters[9].Value = model.industry;
parameters[10].Value = model.Mial;
parameters[11].Value = model.Mobile;
parameters[12].Value = model.phone;
parameters[13].Value = model.typeID;
parameters[14].Value = model.groupID;
parameters[15].Value = model.remark;
parameters[16].Value = model.Mdatetime;
object obj = DBHelpers.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public int Add(Tz888.Model.Mail.MailInfo model)
{
return(dal.Add(model));
}
public int Update(Tz888.Model.Mail.MailInfo model)
{
return(dal.Update(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Tz888.Model.Mail.MailInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update MailInfo set ");
strSql.Append("LoginName=@LoginName,");
strSql.Append("UserName=@UserName,");
strSql.Append("PanyName=@PanyName,");
strSql.Append("PositionId=@PositionId,");
strSql.Append("Address=@Address,");
strSql.Append("LinkUrl=@LinkUrl,");
strSql.Append("audit=@audit,");
strSql.Append("ProvinceId=@ProvinceId,");
strSql.Append("CityId=@CityId,");
strSql.Append("industry=@industry,");
strSql.Append("Mial=@Mial,");
strSql.Append("Mobile=@Mobile,");
strSql.Append("Phone=@Phone,");
strSql.Append("typeID=@typeID,");
strSql.Append("groupID=@groupID,");
strSql.Append("remark=@remark");
strSql.Append(" where UserID=@UserID ");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@LoginName", SqlDbType.NVarChar, 200),
new SqlParameter("@UserName", SqlDbType.VarChar, 100),
new SqlParameter("@PanyName", SqlDbType.NVarChar, 200),
new SqlParameter("@PositionId", SqlDbType.Int, 4),
new SqlParameter("@Address", SqlDbType.NVarChar, 300),
new SqlParameter("@LinkUrl", SqlDbType.NVarChar, 300),
new SqlParameter("@audit", SqlDbType.Int, 4),
new SqlParameter("@ProvinceId", SqlDbType.Int, 4),
new SqlParameter("@CityId", SqlDbType.Int, 4),
new SqlParameter("@industry", SqlDbType.Int, 4),
new SqlParameter("@Mial", SqlDbType.NVarChar, 200),
new SqlParameter("@Mobile", SqlDbType.VarChar, 50),
new SqlParameter("@Phone", SqlDbType.VarChar, 100),
new SqlParameter("@typeID", SqlDbType.Int, 4),
new SqlParameter("@groupID", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.VarChar, 200)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.LoginName;
parameters[2].Value = model.UserName;
parameters[3].Value = model.PanyName;
parameters[4].Value = model.PositionId;
parameters[5].Value = model.Address;
parameters[6].Value = model.LinkUrl;
parameters[7].Value = model.audit;
parameters[8].Value = model.ProvinceId;
parameters[9].Value = model.CityId;
parameters[10].Value = model.industry;
parameters[11].Value = model.Mial;
parameters[12].Value = model.Mobile;
parameters[13].Value = model.phone;
parameters[14].Value = model.typeID;
parameters[15].Value = model.groupID;
parameters[16].Value = model.remark;
return(DBHelpers.ExecuteCommand(strSql.ToString(), parameters));
}
/// <summary>
/// 得到一个对象实体集合
/// </summary>
public List <Tz888.Model.Mail.MailInfo> GetModelList(string par)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select UserID,LoginName,UserName,PanyName,PositionId,Address,LinkUrl,audit,ProvinceId,CityId,industry,Mial,Mobile,typeID,groupID,remark,Mdatetime from MailInfo ");
strSql.Append(" where " + par + " order by Mdatetime desc");
List <Tz888.Model.Mail.MailInfo> list = new List <Tz888.Model.Mail.MailInfo>();
DataSet ds = DBHelpers.Query(strSql.ToString());
foreach (DataRow row in ds.Tables[0].Rows)
{
Tz888.Model.Mail.MailInfo model = new Tz888.Model.Mail.MailInfo();
if (row["UserID"].ToString() != "")
{
model.UserID = int.Parse(row["UserID"].ToString());
}
model.LoginName = row["LoginName"].ToString();
model.UserName = row["UserName"].ToString();
model.PanyName = row["PanyName"].ToString();
if (row["PositionId"].ToString() != "")
{
model.PositionId = int.Parse(row["PositionId"].ToString());
}
model.Address = row["Address"].ToString();
model.LinkUrl = row["LinkUrl"].ToString();
if (row["audit"].ToString() != "")
{
model.audit = int.Parse(row["audit"].ToString());
}
if (row["ProvinceId"].ToString() != "")
{
model.ProvinceId = int.Parse(row["ProvinceId"].ToString());
}
if (row["CityId"].ToString() != "")
{
model.CityId = int.Parse(row["CityId"].ToString());
}
if (row["industry"].ToString() != "")
{
model.industry = int.Parse(row["industry"].ToString());
}
model.Mial = row["Mial"].ToString();
model.Mobile = row["Mobile"].ToString();
if (row["typeID"].ToString() != "")
{
model.typeID = int.Parse(row["typeID"].ToString());
}
if (row["groupID"].ToString() != "")
{
model.groupID = int.Parse(row["groupID"].ToString());
}
model.remark = row["remark"].ToString();
if (row["Mdatetime"].ToString() != "")
{
model.Mdatetime = row["Mdatetime"].ToString();
}
list.Add(model);
}
return(list);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Tz888.Model.Mail.MailInfo GetModel(int UserID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 UserID,LoginName,UserName,PanyName,PositionId,Address,LinkUrl,audit,ProvinceId,CityId,industry,Mial,Mobile,Phone,typeID,groupID,remark,Mdatetime from MailInfo ");
strSql.Append(" where UserID=@UserID ");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4)
};
parameters[0].Value = UserID;
Tz888.Model.Mail.MailInfo model = new Tz888.Model.Mail.MailInfo();
DataSet ds = DBHelpers.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
model.LoginName = ds.Tables[0].Rows[0]["LoginName"].ToString();
model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
model.PanyName = ds.Tables[0].Rows[0]["PanyName"].ToString();
if (ds.Tables[0].Rows[0]["PositionId"].ToString() != "")
{
model.PositionId = int.Parse(ds.Tables[0].Rows[0]["PositionId"].ToString());
}
model.Address = ds.Tables[0].Rows[0]["Address"].ToString();
model.LinkUrl = ds.Tables[0].Rows[0]["LinkUrl"].ToString();
if (ds.Tables[0].Rows[0]["audit"].ToString() != "")
{
model.audit = int.Parse(ds.Tables[0].Rows[0]["audit"].ToString());
}
if (ds.Tables[0].Rows[0]["ProvinceId"].ToString() != "")
{
model.ProvinceId = int.Parse(ds.Tables[0].Rows[0]["ProvinceId"].ToString());
}
if (ds.Tables[0].Rows[0]["CityId"].ToString() != "")
{
model.CityId = int.Parse(ds.Tables[0].Rows[0]["CityId"].ToString());
}
if (ds.Tables[0].Rows[0]["industry"].ToString() != "")
{
model.industry = int.Parse(ds.Tables[0].Rows[0]["industry"].ToString());
}
model.Mial = ds.Tables[0].Rows[0]["Mial"].ToString();
model.Mobile = ds.Tables[0].Rows[0]["Mobile"].ToString();
model.phone = ds.Tables[0].Rows[0]["Phone"].ToString();
if (ds.Tables[0].Rows[0]["typeID"].ToString() != "")
{
model.typeID = int.Parse(ds.Tables[0].Rows[0]["typeID"].ToString());
}
if (ds.Tables[0].Rows[0]["groupID"].ToString() != "")
{
model.groupID = int.Parse(ds.Tables[0].Rows[0]["groupID"].ToString());
}
model.remark = ds.Tables[0].Rows[0]["remark"].ToString();
if (ds.Tables[0].Rows[0]["Mdatetime"].ToString() != "")
{
model.Mdatetime = ds.Tables[0].Rows[0]["Mdatetime"].ToString();
}
return(model);
}
else
{
return(null);
}
}
