/// <summary> ///添加一条数据(返)插入的数据的id) /// </summary> public int Add(Models.BigClass Models) { string sqlStr = " insert into [MS_BigClass](CREATE_GUID,CLASS_NAME,CLASS_CODE,SORT,LAST_CHANGE_TIME,LAST_CHANGE_IP,LAST_CHANGE_GUID,STATE) values(@CREATE_GUID,@CLASS_NAME,@CLASS_CODE,@SORT,@LAST_CHANGE_TIME,@LAST_CHANGE_IP,@LAST_CHANGE_GUID,@STATE);select @@identity "; using (var connection = new ConnectionCode().GetConnection()) { return(connection.Query <int>(sqlStr, Models).SingleOrDefault()); } }
/// <summary> ///根据id修改一条数据(返)修改结果) /// </summary> public bool Update(Models.BigClass Models) { string sqlStr = " update [MS_BigClass] set CREATE_GUID=@CREATE_GUID,CLASS_NAME=@CLASS_NAME,CLASS_CODE=@CLASS_CODE,SORT=@SORT,LAST_CHANGE_TIME=@LAST_CHANGE_TIME,LAST_CHANGE_IP=@LAST_CHANGE_IP,LAST_CHANGE_GUID=@LAST_CHANGE_GUID,STATE=@STATE where id = @id"; using (var connection = new ConnectionCode().GetConnection()) { return(connection.Execute(sqlStr, Models) > 0); } }
public ActionResult SumbitBigClass(Models.BigClass model) { if (string.IsNullOrWhiteSpace(model.CLASS_NAME) || string.IsNullOrWhiteSpace(model.CLASS_CODE)) { return(Success("提交失败")); } model.CREATE_GUID = System.Guid.NewGuid().ToString(); return(Success("提交失败")); }