/// <summary>
/// 增加一条数据
/// </summary>
public int Add(EccmMaintenanceOrderImplementModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into eccm_maintenance_order_implement(");
strSql.Append("order_id,equCode,implement_content,implement_time,uid_handle,ext1,ext2,ext3)");
strSql.Append(" values (");
strSql.Append("@order_id,@equCode,@implement_content,@implement_time,@uid_handle,@ext1,@ext2,@ext3);");
strSql.Append("select @@IDENTITY;");
MySqlParameter[] parameters =
{
new MySqlParameter("@order_id", MySqlDbType.Int32, 11),
new MySqlParameter("@equCode", MySqlDbType.VarChar, 50),
new MySqlParameter("@implement_content", MySqlDbType.Text),
new MySqlParameter("@implement_time", MySqlDbType.DateTime),
new MySqlParameter("@uid_handle", MySqlDbType.Int32, 11),
new MySqlParameter("@ext1", MySqlDbType.VarChar, 50),
new MySqlParameter("@ext2", MySqlDbType.VarChar, 50),
new MySqlParameter("@ext3", MySqlDbType.VarChar, 50)
};
parameters[0].Value = model.order_id;
parameters[1].Value = model.equCode;
parameters[2].Value = model.implement_content;
parameters[3].Value = model.implement_time;
parameters[4].Value = model.uid_handle;
parameters[5].Value = model.ext1;
parameters[6].Value = model.ext2;
parameters[7].Value = model.ext3;
object obj = MySQLHelper.ExecuteScalar(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(EccmMaintenanceOrderImplementModel model)
{
return(_dal.Add(model));
}