/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(SMS.Model.AuditEnterprise model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update plat_AuditEnterprise set ");
strSql.Append("AuditResult=@AuditResult,");
strSql.Append("Auditor=@Auditor,");
strSql.Append("AuditTime=@AuditTime,");
strSql.Append("EnterpriseResult=@EnterpriseResult,");
strSql.Append("AuditRemark=@AuditRemark");
strSql.Append(" where EnterpriseCode=@EnterpriseCode");
MySqlParameter[] parameters =
{
new MySqlParameter("@EnterpriseCode", MySqlDbType.VarChar, 64),
new MySqlParameter("@AuditResult", MySqlDbType.Int16, 5),
new MySqlParameter("@Auditor", MySqlDbType.VarChar, 64),
new MySqlParameter("@AuditTime", MySqlDbType.DateTime),
new MySqlParameter("@EnterpriseResult", MySqlDbType.Int16, 5),
new MySqlParameter("@AuditRemark", MySqlDbType.VarChar, 128)
};
parameters[0].Value = model.EnterpriseCode;
parameters[1].Value = model.AuditResult;
parameters[2].Value = model.Auditor;
parameters[3].Value = model.AuditTime;
parameters[4].Value = model.EnterpriseResult;
parameters[5].Value = model.AuditRemark;
int rows = DBUtility.MySqlHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public static bool Add(SMS.Model.AuditEnterprise model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into plat_AuditEnterprise(");
strSql.Append("EnterpriseCode,AuditResult,Auditor,AuditTime,EnterpriseResult,AuditRemark,CreateTime)");
strSql.Append(" values (");
strSql.Append("@EnterpriseCode,@AuditResult,@Auditor,@AuditTime,@EnterpriseResult,@AuditRemark,@CreateTime)");
MySqlParameter[] parameters =
{
new MySqlParameter("@EnterpriseCode", MySqlDbType.VarChar, 64),
new MySqlParameter("@AuditResult", MySqlDbType.Int16, 5),
new MySqlParameter("@Auditor", MySqlDbType.VarChar, 64),
new MySqlParameter("@AuditTime", MySqlDbType.DateTime),
new MySqlParameter("@EnterpriseResult", MySqlDbType.Int16, 5),
new MySqlParameter("@AuditRemark", MySqlDbType.VarChar, 128),
new MySqlParameter("@CreateTime", MySqlDbType.DateTime)
};
parameters[0].Value = model.EnterpriseCode;
parameters[1].Value = model.AuditResult == true ? 1 : 0;
parameters[2].Value = model.Auditor;
parameters[3].Value = model.AuditTime;
parameters[4].Value = model.EnterpriseResult == true ? 1 : 0;
parameters[5].Value = model.AuditRemark;
parameters[6].Value = model.CreateTime;
int rows = DBUtility.MySqlHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
static SMS.Model.AuditEnterprise DataRowToModel(DataRow row)
{
SMS.Model.AuditEnterprise model = new SMS.Model.AuditEnterprise();
if (row != null)
{
if (row["EnterpriseCode"] != null)
{
model.EnterpriseCode = row["EnterpriseCode"].ToString();
}
if (row["AuditResult"] != null && row["AuditResult"].ToString() != "")
{
model.AuditResult = row["AuditResult"].ToString() == "1" ? true : false;
}
if (row["Auditor"] != null)
{
model.Auditor = row["Auditor"].ToString();
}
if (row["AuditTime"] != null && row["AuditTime"].ToString() != "")
{
model.AuditTime = DateTime.Parse(row["AuditTime"].ToString());
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["EnterpriseResult"] != null && row["EnterpriseResult"].ToString() != "")
{
model.EnterpriseResult = row["EnterpriseResult"].ToString() == "1" ? true : false;
}
if (row["AuditRemark"] != null)
{
model.AuditRemark = row["AuditRemark"].ToString();
}
}
return(model);
}
