public bool Update(RequireModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update ARCHIVE_REQUIRED set ");
builder.Append("TableName=@TableName,");
builder.Append("OptionName=@OptionName,");
builder.Append("ChinName =@ChinName,");
builder.Append("Comment=@Comment, ");
builder.Append("Isrequired=@Isrequired, ");
builder.Append("TabName=@TabName, ");
builder.Append("ItemValue=@ItemValue ");
builder.Append(" where ID=@ID");
MySqlParameter[] cmdParms = new MySqlParameter[]
{
new MySqlParameter("@TableName", MySqlDbType.String),
new MySqlParameter("@OptionName", MySqlDbType.String),
new MySqlParameter("@ChinName", MySqlDbType.String),
new MySqlParameter("@Comment", MySqlDbType.String),
new MySqlParameter("@Isrequired", MySqlDbType.String),
new MySqlParameter("@TabName", MySqlDbType.String),
new MySqlParameter("@SetValue", MySqlDbType.String),
new MySqlParameter("@ItemValue", MySqlDbType.String),
new MySqlParameter("@ID", MySqlDbType.Int32, 8)
};
cmdParms[0].Value = model.TableName;
cmdParms[1].Value = model.OptionName;
cmdParms[2].Value = model.ChinName;
cmdParms[3].Value = model.Comment;
cmdParms[4].Value = model.Isrequired;
cmdParms[5].Value = model.TabName;
cmdParms[6].Value = model.SetValue;
cmdParms[7].Value = model.ItemValue;
cmdParms[8].Value = model.ID;
return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public IActionResult AddRequire_FromBody([FromBody] RequireModel value)
{
try
{
var result = requiresModelContext.RequireModelItems.Where(item => item.Id == value.Id).ToList();
if (result.Count != 0)
{
//已经有该需求了
return(BadRequest());
}
else
{
value.Id = 0;//这里不允许显式插入主键
requiresModelContext.Add(value);
requiresModelContext.SaveChanges();
}
return(Ok());
}
catch (Exception ex)
{
var exString = ex.ToString();
return(BadRequest());
}
}
public RequireModel DataRowToModel(DataRow row)
{
RequireModel RequiredModel = new RequireModel();
if (row != null)
{
if ((row["ID"] != null) && (row["ID"].ToString() != ""))
{
RequiredModel.ID = int.Parse(row["ID"].ToString());
}
if (row["TableName"] != null)
{
RequiredModel.TableName = row["TableName"].ToString();
}
if (row["OptionName"] != null)
{
RequiredModel.OptionName = row["OptionName"].ToString();
}
if (row["ChinName"] != null)
{
RequiredModel.ChinName = row["ChinName"].ToString();
}
if (row["Comment"] != null)
{
RequiredModel.Comment = row["Comment"].ToString();
}
if ((row["Isrequired"] != null))
{
RequiredModel.Isrequired = row["Isrequired"].ToString();
}
if ((row["TabName"] != null))
{
RequiredModel.TabName = row["TabName"].ToString();
}
if ((row["SetValue"] != null))
{
RequiredModel.SetValue = row["SetValue"].ToString();
}
if ((row["Content"] != null))
{
RequiredModel.Content = row["Content"].ToString();
}
if ((row["TypeName"] != null))
{
RequiredModel.TypeName = row["TypeName"].ToString();
}
if ((row["ItemValue"] != null))
{
RequiredModel.ItemValue = row["ItemValue"].ToString();
}
if ((row["IsDecimalPlace"] != null))
{
RequiredModel.IsDecimalPlace = row["IsDecimalPlace"].ToString();
}
if ((row["DecimalPlace"] != null))
{
int i = 0;
if (int.TryParse(row["DecimalPlace"].ToString(), out i))
{
RequiredModel.DecimalPlace = i;
}
else
{
RequiredModel.DecimalPlace = 0;
}
}
if ((row["IsOdevity"] != null))
{
RequiredModel.IsOdevity = row["IsOdevity"].ToString();
}
}
return(RequiredModel);
}
