/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.musicorder DataRowToModel(DataRow row)
{
Maticsoft.Model.musicorder model = new Maticsoft.Model.musicorder();
if (row != null)
{
if (row["OrderId"] != null && row["OrderId"].ToString() != "")
{
model.OrderId = int.Parse(row["OrderId"].ToString());
}
if (row["OrderDate"] != null && row["OrderDate"].ToString() != "")
{
model.OrderDate = DateTime.Parse(row["OrderDate"].ToString());
}
if (row["Username"] != null)
{
model.Username = row["Username"].ToString();
}
if (row["FirstName"] != null)
{
model.FirstName = row["FirstName"].ToString();
}
if (row["LastName"] != null)
{
model.LastName = row["LastName"].ToString();
}
if (row["Address"] != null)
{
model.Address = row["Address"].ToString();
}
if (row["City"] != null)
{
model.City = row["City"].ToString();
}
if (row["State"] != null)
{
model.State = row["State"].ToString();
}
if (row["PostalCode"] != null)
{
model.PostalCode = row["PostalCode"].ToString();
}
if (row["Country"] != null)
{
model.Country = row["Country"].ToString();
}
if (row["Phone"] != null)
{
model.Phone = row["Phone"].ToString();
}
if (row["Email"] != null)
{
model.Email = row["Email"].ToString();
}
if (row["Total"] != null && row["Total"].ToString() != "")
{
model.Total = decimal.Parse(row["Total"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.musicorder model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update musicorder set ");
strSql.Append("OrderDate=@OrderDate,");
strSql.Append("Username=@Username,");
strSql.Append("FirstName=@FirstName,");
strSql.Append("LastName=@LastName,");
strSql.Append("Address=@Address,");
strSql.Append("City=@City,");
strSql.Append("State=@State,");
strSql.Append("PostalCode=@PostalCode,");
strSql.Append("Country=@Country,");
strSql.Append("Phone=@Phone,");
strSql.Append("Email=@Email,");
strSql.Append("Total=@Total");
strSql.Append(" where OrderId=@OrderId ");
MySqlParameter[] parameters =
{
new MySqlParameter("@OrderDate", MySqlDbType.DateTime),
new MySqlParameter("@Username", MySqlDbType.VarChar, 256),
new MySqlParameter("@FirstName", MySqlDbType.VarChar, 160),
new MySqlParameter("@LastName", MySqlDbType.VarChar, 160),
new MySqlParameter("@Address", MySqlDbType.VarChar, 70),
new MySqlParameter("@City", MySqlDbType.VarChar, 40),
new MySqlParameter("@State", MySqlDbType.VarChar, 40),
new MySqlParameter("@PostalCode", MySqlDbType.VarChar, 10),
new MySqlParameter("@Country", MySqlDbType.VarChar, 40),
new MySqlParameter("@Phone", MySqlDbType.VarChar, 24),
new MySqlParameter("@Email", MySqlDbType.VarChar, 160),
new MySqlParameter("@Total", MySqlDbType.Decimal, 10),
new MySqlParameter("@OrderId", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.OrderDate;
parameters[1].Value = model.Username;
parameters[2].Value = model.FirstName;
parameters[3].Value = model.LastName;
parameters[4].Value = model.Address;
parameters[5].Value = model.City;
parameters[6].Value = model.State;
parameters[7].Value = model.PostalCode;
parameters[8].Value = model.Country;
parameters[9].Value = model.Phone;
parameters[10].Value = model.Email;
parameters[11].Value = model.Total;
parameters[12].Value = model.OrderId;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.musicorder model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into musicorder(");
strSql.Append("OrderId,OrderDate,Username,FirstName,LastName,Address,City,State,PostalCode,Country,Phone,Email,Total)");
strSql.Append(" values (");
strSql.Append("@OrderId,@OrderDate,@Username,@FirstName,@LastName,@Address,@City,@State,@PostalCode,@Country,@Phone,@Email,@Total)");
MySqlParameter[] parameters =
{
new MySqlParameter("@OrderId", MySqlDbType.Int32, 11),
new MySqlParameter("@OrderDate", MySqlDbType.DateTime),
new MySqlParameter("@Username", MySqlDbType.VarChar, 256),
new MySqlParameter("@FirstName", MySqlDbType.VarChar, 160),
new MySqlParameter("@LastName", MySqlDbType.VarChar, 160),
new MySqlParameter("@Address", MySqlDbType.VarChar, 70),
new MySqlParameter("@City", MySqlDbType.VarChar, 40),
new MySqlParameter("@State", MySqlDbType.VarChar, 40),
new MySqlParameter("@PostalCode", MySqlDbType.VarChar, 10),
new MySqlParameter("@Country", MySqlDbType.VarChar, 40),
new MySqlParameter("@Phone", MySqlDbType.VarChar, 24),
new MySqlParameter("@Email", MySqlDbType.VarChar, 160),
new MySqlParameter("@Total", MySqlDbType.Decimal, 10)
};
parameters[0].Value = model.OrderId;
parameters[1].Value = model.OrderDate;
parameters[2].Value = model.Username;
parameters[3].Value = model.FirstName;
parameters[4].Value = model.LastName;
parameters[5].Value = model.Address;
parameters[6].Value = model.City;
parameters[7].Value = model.State;
parameters[8].Value = model.PostalCode;
parameters[9].Value = model.Country;
parameters[10].Value = model.Phone;
parameters[11].Value = model.Email;
parameters[12].Value = model.Total;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.musicorder GetModel(int OrderId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select OrderId,OrderDate,Username,FirstName,LastName,Address,City,State,PostalCode,Country,Phone,Email,Total from musicorder ");
strSql.Append(" where OrderId=@OrderId ");
MySqlParameter[] parameters =
{
new MySqlParameter("@OrderId", MySqlDbType.Int32, 11)
};
parameters[0].Value = OrderId;
Maticsoft.Model.musicorder model = new Maticsoft.Model.musicorder();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
