/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.MainTenanceLogModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update maintenancelog set ");
strSql.Append("settingID=@settingID,");
strSql.Append("devhouseID=@devhouseID,");
strSql.Append("orderCode=@orderCode,");
strSql.Append("orderContent=@orderContent,");
strSql.Append("orderType=@orderType,");
strSql.Append("createTime=@createTime,");
strSql.Append("operateTime=@operateTime,");
strSql.Append("status=@status,");
strSql.Append("remark=@remark");
strSql.Append(" where mID=@mID");
MySqlParameter[] parameters =
{
new MySqlParameter("@settingID", MySqlDbType.Int32, 10),
new MySqlParameter("@devhouseID", MySqlDbType.Int32, 10),
new MySqlParameter("@orderCode", MySqlDbType.VarChar, 18),
new MySqlParameter("@orderContent", MySqlDbType.VarChar, 500),
new MySqlParameter("@orderType", MySqlDbType.Int32, 4),
new MySqlParameter("@createTime", MySqlDbType.DateTime),
new MySqlParameter("@operateTime", MySqlDbType.DateTime),
new MySqlParameter("@status", MySqlDbType.Int32, 4),
new MySqlParameter("@remark", MySqlDbType.VarChar, 50),
new MySqlParameter("@mID", MySqlDbType.Int32, 10)
};
parameters[0].Value = model.settingID;
parameters[1].Value = model.devhouseID;
parameters[2].Value = model.orderCode;
parameters[3].Value = model.orderContent;
parameters[4].Value = model.orderType;
parameters[5].Value = model.createTime;
parameters[6].Value = model.operateTime;
parameters[7].Value = model.status;
parameters[8].Value = model.remark;
parameters[9].Value = model.mID;
int rows = MySQLHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MainTenanceLogModel DataRowToModel(DataRow row)
{
Model.MainTenanceLogModel model = new Model.MainTenanceLogModel();
if (row != null)
{
if (row["mID"] != null && row["mID"].ToString() != "")
{
model.mID = int.Parse(row["mID"].ToString());
}
if (row["settingID"] != null && row["settingID"].ToString() != "")
{
model.settingID = int.Parse(row["settingID"].ToString());
}
if (row["devhouseID"] != null && row["devhouseID"].ToString() != "")
{
model.devhouseID = int.Parse(row["devhouseID"].ToString());
}
if (row["orderCode"] != null)
{
model.orderCode = row["orderCode"].ToString();
}
if (row["orderContent"] != null)
{
model.orderContent = row["orderContent"].ToString();
}
if (row["orderType"] != null && row["orderType"].ToString() != "")
{
model.orderType = int.Parse(row["orderType"].ToString());
}
if (row["createTime"] != null && row["createTime"].ToString() != "")
{
model.createTime = DateTime.Parse(row["createTime"].ToString());
}
if (row["operateTime"] != null && row["operateTime"].ToString() != "")
{
model.operateTime = DateTime.Parse(row["operateTime"].ToString());
}
if (row["status"] != null && row["status"].ToString() != "")
{
model.status = int.Parse(row["status"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.MainTenanceLogModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into maintenancelog(");
strSql.Append("settingID,devhouseID,orderCode,orderContent,orderType,createTime,operateTime,status,remark)");
strSql.Append(" values (");
strSql.Append("@settingID,@devhouseID,@orderCode,@orderContent,@orderType,@createTime,@operateTime,@status,@remark)");
MySqlParameter[] parameters =
{
new MySqlParameter("@settingID", MySqlDbType.Int32, 10),
new MySqlParameter("@devhouseID", MySqlDbType.Int32, 10),
new MySqlParameter("@orderCode", MySqlDbType.VarChar, 18),
new MySqlParameter("@orderContent", MySqlDbType.VarChar, 500),
new MySqlParameter("@orderType", MySqlDbType.Int32, 4),
new MySqlParameter("@createTime", MySqlDbType.DateTime),
new MySqlParameter("@operateTime", MySqlDbType.DateTime),
new MySqlParameter("@status", MySqlDbType.Int32, 4),
new MySqlParameter("@remark", MySqlDbType.VarChar, 50)
};
parameters[0].Value = model.settingID;
parameters[1].Value = model.devhouseID;
parameters[2].Value = model.orderCode;
parameters[3].Value = model.orderContent;
parameters[4].Value = model.orderType;
parameters[5].Value = model.createTime;
parameters[6].Value = model.operateTime;
parameters[7].Value = model.status;
parameters[8].Value = model.remark;
int rows = MySQLHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MainTenanceLogModel GetModel(int mID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select mID,settingID,devhouseID,orderCode,orderContent,orderType,createTime,operateTime,status,remark from maintenancelog ");
strSql.Append(" where mID=@mID");
MySqlParameter[] parameters =
{
new MySqlParameter("@mID", MySqlDbType.Int32)
};
parameters[0].Value = mID;
Model.MainTenanceLogModel model = new Model.MainTenanceLogModel();
DataTable dt = MySQLHelper.ExecuteToDataTable(strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
return(DataRowToModel(dt.Rows[0]));
}
else
{
return(null);
}
}
