/// <summary>
/// 得到一个对象实体
/// </summary>
public Demo.MySQLModelQuery.Model.SysUserModel GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" from `sysuser` ");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32)
};
parameters[0].Value = ID;
Demo.MySQLModelQuery.Model.SysUserModel model = new Demo.MySQLModelQuery.Model.SysUserModel();
DataSet ds = MySQLHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataTableToList(ds.Tables[0])[0]);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Demo.MySQLModelQuery.Model.SysUserModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update `sysuser` set ");
strSql.Append(" `dr` = @dr , ");
strSql.Append(" `ts` = @ts , ");
strSql.Append(" `UserName` = @UserName , ");
strSql.Append(" `Password` = @Password , ");
strSql.Append(" `RealName` = @RealName , ");
strSql.Append(" `Phone` = @Phone , ");
strSql.Append(" `Mobile` = @Mobile , ");
strSql.Append(" `Email` = @Email , ");
strSql.Append(" `Status` = @Status , ");
strSql.Append(" `Description` = @Description ");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32, 11),
new MySqlParameter("@dr", MySqlDbType.Bit),
new MySqlParameter("@ts", MySqlDbType.DateTime),
new MySqlParameter("@UserName", MySqlDbType.VarChar, 30),
new MySqlParameter("@Password", MySqlDbType.VarChar, 40),
new MySqlParameter("@RealName", MySqlDbType.VarChar, 50),
new MySqlParameter("@Phone", MySqlDbType.VarChar, 20),
new MySqlParameter("@Mobile", MySqlDbType.VarChar, 20),
new MySqlParameter("@Email", MySqlDbType.VarChar, 100),
new MySqlParameter("@Status", MySqlDbType.Int32, 11),
new MySqlParameter("@Description", MySqlDbType.Text)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.dr;
parameters[2].Value = model.ts;
parameters[3].Value = model.UserName;
parameters[4].Value = model.Password;
parameters[5].Value = model.RealName;
parameters[6].Value = model.Phone;
parameters[7].Value = model.Mobile;
parameters[8].Value = model.Email;
parameters[9].Value = model.Status;
parameters[10].Value = model.Description;
int rows = MySQLHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获得数据列表
/// </summary>
private List <Demo.MySQLModelQuery.Model.SysUserModel> DataTableToList(DataTable dt)
{
List <Demo.MySQLModelQuery.Model.SysUserModel> modelList = new List <Demo.MySQLModelQuery.Model.SysUserModel>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Demo.MySQLModelQuery.Model.SysUserModel model;
for (int n = 0; n < rowsCount; n++)
{
model = new Demo.MySQLModelQuery.Model.SysUserModel();
if (dt.Rows[n]["ID"].ToString() != "")
{
model.ID = int.Parse(dt.Rows[n]["ID"].ToString());
}
if (dt.Rows[n]["dr"].ToString() != "")
{
if ((dt.Rows[n]["dr"].ToString() == "1") || (dt.Rows[n]["dr"].ToString().ToLower() == "true"))
{
model.dr = true;
}
else
{
model.dr = false;
}
}
if (dt.Rows[n]["ts"].ToString() != "")
{
model.ts = DateTime.Parse(dt.Rows[n]["ts"].ToString());
}
model.UserName = dt.Rows[n]["UserName"].ToString();
model.Password = dt.Rows[n]["Password"].ToString();
model.RealName = dt.Rows[n]["RealName"].ToString();
model.Phone = dt.Rows[n]["Phone"].ToString();
model.Mobile = dt.Rows[n]["Mobile"].ToString();
model.Email = dt.Rows[n]["Email"].ToString();
if (dt.Rows[n]["Status"].ToString() != "")
{
model.Status = int.Parse(dt.Rows[n]["Status"].ToString());
}
model.Description = dt.Rows[n]["Description"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Demo.MySQLModelQuery.Model.SysUserModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into `sysuser`(");
strSql.Append("`dr`,`ts`,`UserName`,`Password`,`RealName`,`Phone`,`Mobile`,`Email`,`Status`,`Description`");
strSql.Append(") values (");
strSql.Append("@dr,@ts,@UserName,@Password,@RealName,@Phone,@Mobile,@Email,@Status,@Description");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
MySqlParameter[] parameters =
{
new MySqlParameter("@dr", MySqlDbType.Bit),
new MySqlParameter("@ts", MySqlDbType.DateTime),
new MySqlParameter("@UserName", MySqlDbType.VarChar, 30),
new MySqlParameter("@Password", MySqlDbType.VarChar, 40),
new MySqlParameter("@RealName", MySqlDbType.VarChar, 50),
new MySqlParameter("@Phone", MySqlDbType.VarChar, 20),
new MySqlParameter("@Mobile", MySqlDbType.VarChar, 20),
new MySqlParameter("@Email", MySqlDbType.VarChar, 100),
new MySqlParameter("@Status", MySqlDbType.Int32, 11),
new MySqlParameter("@Description", MySqlDbType.Text)
};
parameters[0].Value = model.dr;
parameters[1].Value = model.ts;
parameters[2].Value = model.UserName;
parameters[3].Value = model.Password;
parameters[4].Value = model.RealName;
parameters[5].Value = model.Phone;
parameters[6].Value = model.Mobile;
parameters[7].Value = model.Email;
parameters[8].Value = model.Status;
parameters[9].Value = model.Description;
object obj = MySQLHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}