/// <summary> /// 部分修改保存 /// </summary> /// <param name="model">对象clsCheckComType的一个实例参数</param> /// <returns></returns> public int UpdatePartTag(clsCheckComType model, out string errMsg) { errMsg = string.Empty; int rtn = 0; try { sb.Length = 0; sb.Append("UPDATE TCHECKCOMTYPE SET"); sb.AppendFormat(" NameCall='{0}'", model.NameCall); sb.AppendFormat(",AreaCall='{0}'", model.AreaCall); sb.AppendFormat(",AreaTitle='{0}'", model.AreaTitle); sb.AppendFormat(",NameTitle='{0}'", model.NameTitle); sb.AppendFormat(",DomainTitle='{0}'", model.DomainTitle); sb.AppendFormat(",SampleTitle='{0}'", model.SampleTitle); sb.Append(" WHERE ID="); sb.Append(model.ID); DataBase.ExecuteCommand(sb.ToString(), out errMsg); sb.Length = 0; rtn = 1; } catch (Exception e) { errMsg = e.Message; } return(rtn); }
/// <summary> /// 插入一条明细记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(clsCheckComType model, out string errMsg) { errMsg = string.Empty; int rtn = 0; try { sb.Length = 0; sb.Append("INSERT INTO tcheckcomtype(TypeName,NameCall,AreaCall,VerType,IsReadOnly,IsLock,ComKind,AreaTitle,NameTitle,DomainTitle,SampleTitle)VALUES('"); sb.Append(model.TypeName); sb.Append("','"); sb.Append(model.NameCall); sb.Append("','"); sb.Append(model.AreaCall); sb.Append("','"); sb.Append(model.VerType); sb.Append("',"); sb.Append(model.IsReadOnly); sb.Append(","); sb.Append(model.IsLock); sb.Append(",'"); sb.Append(model.ComKind); sb.Append("','"); sb.Append(model.AreaTitle); sb.Append("','"); sb.Append(model.NameTitle); sb.Append("','"); sb.Append(model.DomainTitle); sb.Append("','"); sb.Append(model.SampleTitle); sb.Append("')"); DataBase.ExecuteCommand(sb.ToString(), out errMsg); sb.Length = 0; rtn = 1; } catch (Exception e) { //Log.WriteLog("添加clsCheckType",e); errMsg = e.Message; } return(rtn); }