/// <summary> /// 增加一条数据 /// </summary> public long Add(SmartLaw.Model.Questionary model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Questionary("); strSql.Append("Title,IsValid)"); strSql.Append(" values ("); strSql.Append("@Title,@IsValid)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@Title", MySqlDbType.VarChar,64), new MySqlParameter("@IsValid", MySqlDbType.Bit,1) }; parameters[0].Value = model.Title; parameters[1].Value = model.IsValid; try { object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters); return Convert.ToInt64(obj); } catch (Exception ee) { return 0; } }
/// <summary> /// 增加一条数据 /// </summary> public long Add(SmartLaw.Model.Question model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Question("); strSql.Append("QuestionaryID,Content,Answer,Orders,IsSingle)"); strSql.Append(" values ("); strSql.Append("@QuestionaryID,@Content,@Answer,@Orders,@IsSingle)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@QuestionaryID", MySqlDbType.VarChar,64), new MySqlParameter("@Content", MySqlDbType.VarChar,64), new MySqlParameter("@Answer", MySqlDbType.VarChar,256), new MySqlParameter("@Orders", MySqlDbType.Int32), new MySqlParameter("@IsSingle", MySqlDbType.Bit)}; parameters[0].Value = model.QuestionaryID; parameters[1].Value = model.Content; parameters[2].Value = getAnswersString(model.Answer); parameters[3].Value = model.Orders; parameters[4].Value = model.IsSingle; object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return 0; } else { return Convert.ToInt64(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public long Add(SmartLaw.Model.UserAnswer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into UserAnswer("); strSql.Append("QuestionID,UserID,Orders,Answer)"); strSql.Append(" values ("); strSql.Append("@QuestionID,@UserID,@Orders,@Answer)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@QuestionID", MySqlDbType.Int64), new MySqlParameter("@UserID", MySqlDbType.Int64), new MySqlParameter("@Orders", MySqlDbType.Int64), new MySqlParameter("@Answer", MySqlDbType.VarChar,64)}; parameters[0].Value = model.QuestionID; parameters[1].Value = model.UserID; parameters[2].Value = model.Orders; parameters[3].Value = getAnswersString(model.Answer); object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return 0; } else { return Convert.ToInt64(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(SmartLaw.Model.MessageToObject model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into MessageToObject("); strSql.Append("AutoID,MsgID,ObjType,ObjValue)"); strSql.Append(" values ("); strSql.Append("@AutoID,@MsgID,@ObjType,@ObjValue)"); MySqlParameter[] parameters = { new MySqlParameter("@AutoID", MySqlDbType.Int64), new MySqlParameter("@MsgID", MySqlDbType.Int64), new MySqlParameter("@ObjType", MySqlDbType.VarChar,50), new MySqlParameter("@ObjValue", MySqlDbType.VarChar,50) }; parameters[0].Value = model.AutoID; parameters[1].Value = model.MsgID; parameters[2].Value = model.ObjType; parameters[3].Value = model.ObjValue; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public long Add(SmartLaw.Model.Category model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Category("); strSql.Append("CategoryName,ParentCategoryID,Orders,LastModifyTime,IsValid,Memo)"); strSql.Append(" values ("); strSql.Append("@CategoryName,@ParentCategoryID,@Orders,@LastModifyTime,@IsValid,@Memo)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@CategoryName", MySqlDbType.VarChar,50), new MySqlParameter("@ParentCategoryID", MySqlDbType.Int64), new MySqlParameter("@Orders", MySqlDbType.Int32), new MySqlParameter("@LastModifyTime", MySqlDbType.DateTime), new MySqlParameter("@IsValid", MySqlDbType.Bit,1), new MySqlParameter("@Memo", MySqlDbType.VarChar,50)}; parameters[0].Value = model.CategoryName; parameters[1].Value = model.ParentCategoryID; parameters[2].Value = model.Orders; parameters[3].Value = model.LastModifyTime; parameters[4].Value = model.IsValid; parameters[5].Value = model.Memo; object obj = DbHelperMySQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt64(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(SmartLaw.Model.NoticeRegionalRelation model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into NoticeRegionalRelation("); strSql.Append("AutoID,NoticeID,RegionalID)"); strSql.Append(" values ("); strSql.Append("@AutoID,@NoticeID,@RegionalID)"); MySqlParameter[] parameters = { new MySqlParameter("@AutoID", MySqlDbType.Int64), new MySqlParameter("@NoticeID", MySqlDbType.Int64), new MySqlParameter("@RegionalID", MySqlDbType.VarChar,50)}; parameters[0].Value = model.AutoID; parameters[1].Value = model.NoticeID; parameters[2].Value = model.RegionalID; int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(SmartLaw.Model.Integral model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Integral("); strSql.Append("SimCardNo,Items,IntegralAdded,TotalIntegral,LastModifyTime)"); strSql.Append(" values ("); strSql.Append("@SimCardNo,@Items,@IntegralAdded,@TotalIntegral,@LastModifyTime)"); MySqlParameter[] parameters = { new MySqlParameter("@SimCardNo", MySqlDbType.VarChar,50), new MySqlParameter("@Items", MySqlDbType.VarChar,50), new MySqlParameter("@IntegralAdded", MySqlDbType.Int32), new MySqlParameter("@TotalIntegral", MySqlDbType.Int64,20), new MySqlParameter("@LastModifyTime", MySqlDbType.DateTime)}; parameters[0].Value = model.SimCardNo; parameters[1].Value = model.Items; parameters[2].Value = model.IntegralAdded; parameters[3].Value = model.TotalIntegral; parameters[4].Value = model.LastModifyTime; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public long Add(SmartLaw.Model.Notice model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Notice("); strSql.Append("Contents,Orders,Publisher,LastModifyTime,IsValid)"); strSql.Append(" values ("); strSql.Append("@Contents,@Orders,@Publisher,@LastModifyTime,@IsValid)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@Contents", MySqlDbType.Text), new MySqlParameter("@Orders", MySqlDbType.Int64), new MySqlParameter("@Publisher", MySqlDbType.VarChar,50), new MySqlParameter("@LastModifyTime", MySqlDbType.DateTime), new MySqlParameter("@IsValid", MySqlDbType.Bit,1) }; parameters[0].Value = model.Contents; parameters[1].Value = model.Orders; parameters[2].Value = model.Publisher; parameters[3].Value = model.LastModifyTime; parameters[4].Value = model.IsValid; object obj = DbHelperMySQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt64(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(SmartLaw.Model.Log model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into log("); strSql.Append("OperationItem,OperationTime,OperationDetail,Operator,Memo)"); strSql.Append(" values ("); strSql.Append("@OperationItem,@OperationTime,@OperationDetail,@Operator,@Memo)"); MySqlParameter[] parameters = { new MySqlParameter("@OperationItem", MySqlDbType.VarChar,50), new MySqlParameter("@OperationTime", MySqlDbType.DateTime), new MySqlParameter("@OperationDetail", MySqlDbType.Text), new MySqlParameter("@Operator", MySqlDbType.VarChar,50), new MySqlParameter("@Memo", MySqlDbType.Text)}; parameters[0].Value = model.OperationItem; parameters[1].Value = model.OperationTime; parameters[2].Value = model.OperationDetail; parameters[3].Value = model.Operator; parameters[4].Value = model.Memo; int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(SmartLaw.Model.SysCode model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into T_SYSCODE("); strSql.Append("SYSCodeID,SYSCodeContext,LastModifytime,ISValid,Memo)"); strSql.Append(" values ("); strSql.Append("@SYSCodeID,@SYSCodeContext,@LastModifytime,@ISValid,@Memo)"); MySqlParameter[] parameters = { new MySqlParameter("@SYSCodeID", MySqlDbType.VarChar,50), new MySqlParameter("@SYSCodeContext", MySqlDbType.VarChar,50), new MySqlParameter("@LastModifytime", MySqlDbType.DateTime), new MySqlParameter("@ISValid", MySqlDbType.Bit,1), new MySqlParameter("@Memo", MySqlDbType.VarChar,50)}; parameters[0].Value = model.SYSCodeID; parameters[1].Value = model.SYSCodeContext; parameters[2].Value = model.LastModifytime; parameters[3].Value = model.ISValid; parameters[4].Value = model.Memo; int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public long Add(SmartLaw.Model.UserBehavior model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into userbehavior("); strSql.Append("SimCardNO,CategoryID,IPAddr,ScanTime,Remarks,Behavior)"); strSql.Append(" values ("); strSql.Append("@SimCardNO,@CategoryID,@IPAddr,@ScanTime,@Remarks,@Behavior)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@SimCardNO", MySqlDbType.VarChar,50), new MySqlParameter("@CategoryID", MySqlDbType.Int64), new MySqlParameter("@IPAddr", MySqlDbType.VarChar,15), new MySqlParameter("@ScanTime", MySqlDbType.DateTime), new MySqlParameter("@Remarks", MySqlDbType.VarChar,128), new MySqlParameter("@Behavior", MySqlDbType.VarChar,128)}; parameters[0].Value = model.SimCardNO; parameters[1].Value = model.CategoryID; parameters[2].Value = model.IPAddr; parameters[3].Value = model.ScanTime; parameters[4].Value = model.Remarks; parameters[5].Value = model.Behavior; object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return 0; } else { return Convert.ToInt64(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(SmartLaw.Model.SysUser model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into SysUser("); strSql.Append("UserID,Password,EmployeeID,UserName,IsValid)"); strSql.Append(" values ("); strSql.Append("@UserID,@Password,@EmployeeID,@UserName,@IsValid)"); MySqlParameter[] parameters = { new MySqlParameter("@UserID", MySqlDbType.VarChar,50), new MySqlParameter("@Password", MySqlDbType.VarChar,50), new MySqlParameter("@EmployeeID", MySqlDbType.VarChar,50), new MySqlParameter("@UserName", MySqlDbType.VarChar,50), new MySqlParameter("@IsValid", MySqlDbType.Bit,1)}; parameters[0].Value = model.UserID; parameters[1].Value = model.Password; parameters[2].Value = model.EmployeeID; parameters[3].Value = model.UserName; parameters[4].Value = model.IsValid; StringBuilder strSql1 = new StringBuilder(); strSql1.Append("insert into T_SYSCODEDETIAL("); strSql1.Append("SYSCodeID,SYSCodeDetialID,SYSCodeDetialContext,LastModifyTime,IsValid,Memo)"); strSql1.Append(" values ("); strSql1.Append("@SYSCodeID,@SYSCodeDetialID,@SYSCodeDetialContext,@LastModifyTime,@IsValid,@Memo)"); MySqlParameter[] parameters1 = { new MySqlParameter("@SYSCodeID", MySqlDbType.VarChar,50), new MySqlParameter("@SYSCodeDetialID", MySqlDbType.VarChar,50), new MySqlParameter("@SYSCodeDetialContext", MySqlDbType.VarChar,50), new MySqlParameter("@LastModifyTime", MySqlDbType.DateTime), new MySqlParameter("@IsValid", MySqlDbType.Bit,1), new MySqlParameter("@Memo", MySqlDbType.VarChar,50)}; parameters1[0].Value = "SysUser"; parameters1[1].Value = model.UserID; parameters1[2].Value = model.UserName; parameters1[3].Value = DateTime.Now; parameters1[4].Value = model.IsValid; parameters1[5].Value = "操作员"; System.Collections.Hashtable sqlStringList=new System.Collections.Hashtable(); sqlStringList.Add(strSql,parameters); sqlStringList.Add(strSql1,parameters1); try { DbHelperMySQL.ExecuteSqlTran(sqlStringList); return true; } catch { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public long Add(SmartLaw.Model.Message model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Message("); strSql.Append("Title,Contents,Orders,MessageType,DisappearType,AvailableTime,ExpiredTime,LastModifyTime,Publisher,IsValid,AndOr,Memo,DataType)"); strSql.Append(" values ("); strSql.Append("@Title,@Contents,@Orders,@MessageType,@DisappearType,@AvailableTime,@ExpiredTime,@LastModifyTime,@Publisher,@IsValid,@AndOr,@Memo,@DataType)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@Title", MySqlDbType.VarChar,50), new MySqlParameter("@Contents", MySqlDbType.Text), new MySqlParameter("@Orders", MySqlDbType.Int32), new MySqlParameter("@MessageType", MySqlDbType.VarChar,50), new MySqlParameter("@DisappearType", MySqlDbType.VarChar,50), new MySqlParameter("@AvailableTime", MySqlDbType.DateTime), new MySqlParameter("@ExpiredTime", MySqlDbType.DateTime), new MySqlParameter("@LastModifyTime", MySqlDbType.DateTime), new MySqlParameter("@Publisher", MySqlDbType.VarChar,50), new MySqlParameter("@IsValid", MySqlDbType.Bit,1), new MySqlParameter("@AndOr", MySqlDbType.Bit,1), new MySqlParameter("@Memo", MySqlDbType.VarChar,50), new MySqlParameter("@DataType", MySqlDbType.VarChar,50)}; parameters[0].Value = model.Title; parameters[1].Value = model.Contents; parameters[2].Value = model.Orders; parameters[3].Value = model.MessageType; parameters[4].Value = model.DisappearType; parameters[5].Value = model.AvailableTime; parameters[6].Value = model.ExpiredTime; parameters[7].Value = model.LastModifyTime; parameters[8].Value = model.Publisher; parameters[9].Value = model.IsValid; parameters[10].Value = model.AndOr; parameters[11].Value = model.Memo; parameters[12].Value = model.DataType; object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return 0; } else { return Convert.ToInt64(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public long Add(SmartLaw.Model.Drugs model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Drugs("); strSql.Append("PZWH,CPMC,YWMC,SPM,JX,GG,SCDW,SCDZ,CPLB,YPZWH,PZRQ,BWM,BWMBZ)"); strSql.Append(" values ("); strSql.Append("@PZWH,@CPMC,@YWMC,@SPM,@JX,@GG,@SCDW,@SCDZ,@CPLB,@YPZWH,@PZRQ,@BWM,@BWMBZ)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@PZWH", MySqlDbType.VarChar,45), new MySqlParameter("@CPMC", MySqlDbType.VarChar,45), new MySqlParameter("@YWMC", MySqlDbType.Text), new MySqlParameter("@SPM", MySqlDbType.VarChar,45), new MySqlParameter("@JX", MySqlDbType.VarChar,45), new MySqlParameter("@GG", MySqlDbType.Text), new MySqlParameter("@SCDW", MySqlDbType.VarChar,45), new MySqlParameter("@SCDZ", MySqlDbType.VarChar,45), new MySqlParameter("@CPLB", MySqlDbType.VarChar,45), new MySqlParameter("@YPZWH", MySqlDbType.VarChar,45), new MySqlParameter("@PZRQ", MySqlDbType.DateTime), new MySqlParameter("@BWM", MySqlDbType.Text), new MySqlParameter("@BWMBZ", MySqlDbType.Text)}; parameters[0].Value = model.PZWH; parameters[1].Value = model.CPMC; parameters[2].Value = model.YWMC; parameters[3].Value = model.SPM; parameters[4].Value = model.JX; parameters[5].Value = model.GG; parameters[6].Value = model.SCDW; parameters[7].Value = model.SCDZ; parameters[8].Value = model.CPLB; parameters[9].Value = model.YPZWH; parameters[10].Value = model.PZRQ; parameters[11].Value = model.BWM; parameters[12].Value = model.BWMBZ; object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return 0; } else { return Convert.ToInt64(obj); } }
/// <summary> /// 新增问卷及其包含的问题 /// </summary> public long AddQuestionary(SmartLaw.Model.Questionary _qnModel,SmartLaw.Model.Question[] _qsModels ) { long qnID = qnDal.Add(_qnModel); if (qnID >= 0) { for (int j = 0; j < _qsModels.Length; ++j) { _qsModels[j].QuestionaryID = qnID; qsDal.Add(_qsModels[j]); } return qnID; } else { return -1; } }
/// <summary> /// 增加一条数据 /// </summary> public long Add(SmartLaw.Model.DrugsInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DrugsInfo("); strSql.Append("DrugName,Form,FormInfo,Spec,Unit,Price,ValidateTime,District,Company,Policy,Abbr,DataTime)"); strSql.Append(" values ("); strSql.Append("@DrugName,@Form,@FormInfo,@Spec,@Unit,@Price,@ValidateTime,@District,@Company,@Policy,@Abbr,@DataTime)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@DrugName", MySqlDbType.VarChar,64), new MySqlParameter("@Form", MySqlDbType.VarChar,32), new MySqlParameter("@FormInfo", MySqlDbType.VarChar,32), new MySqlParameter("@Spec", MySqlDbType.VarChar,128), new MySqlParameter("@Unit", MySqlDbType.VarChar,16), new MySqlParameter("@Price", MySqlDbType.Float), new MySqlParameter("@ValidateTime", MySqlDbType.VarChar,16), new MySqlParameter("@District", MySqlDbType.VarChar,32), new MySqlParameter("@Company", MySqlDbType.VarChar,128), new MySqlParameter("@Policy", MySqlDbType.VarChar,64), new MySqlParameter("@Abbr",MySqlDbType.VarChar,32), new MySqlParameter("@DataTime",MySqlDbType.DateTime)}; parameters[0].Value = model.DrugName; parameters[1].Value = model.Form; parameters[2].Value = model.FormInfo; parameters[3].Value = model.Spec; parameters[4].Value = model.Unit; parameters[5].Value = model.Price; parameters[6].Value = model.ValidateTime; parameters[7].Value = model.District; parameters[8].Value = model.Company; parameters[9].Value = model.Policy; parameters[10].Value = GetAbbr(model.DrugName); parameters[11].Value = model.DataTime; object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return 0; } else { return Convert.ToInt64(obj); } }
/// <summary> /// 增加一条公交线路数据 /// </summary> public long AddBusLine(SmartLaw.Model.BusLine model,out string msg) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into BusLine("); strSql.Append("RouteName,Station,Remarks)"); strSql.Append(" values ("); strSql.Append("@RouteName,@Station,@Remarks)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@RouteName", MySqlDbType.VarChar,128), new MySqlParameter("@Station", MySqlDbType.VarChar,2048), new MySqlParameter("@Remarks", MySqlDbType.VarChar,128)}; parameters[0].Value = model.RouteName; parameters[1].Value = getStationString(model.Station); parameters[2].Value = model.Remarks; object obj = DbHelperMySQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { msg = "插入线路信息失败"; return 0; } else { msg=""; foreach (string s in model.Station) { if (!ExistsStation(s)) { bool bl= AddStation(s); if (!bl) { msg += "添加站点" + s + "失败|"; } } } return Convert.ToInt64(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public long Add(SmartLaw.Model.News model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into News("); strSql.Append("Title,CategoryID,Contents,Publisher,DataSource,DataType,LastModifyTime,IsValid,Checked,Checker,CheckMemo)"); strSql.Append(" values ("); strSql.Append("@Title,@CategoryID,@Contents,@Publisher,@DataSource,@DataType,@LastModifyTime,@IsValid,@Checked,@Checker,@CheckMemo)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@Title", MySqlDbType.VarChar,50), new MySqlParameter("@CategoryID", MySqlDbType.Int64), new MySqlParameter("@Contents", MySqlDbType.Text), new MySqlParameter("@Publisher", MySqlDbType.VarChar,50), new MySqlParameter("@DataSource", MySqlDbType.VarChar,50), new MySqlParameter("@DataType", MySqlDbType.VarChar,50), new MySqlParameter("@LastModifyTime", MySqlDbType.DateTime), new MySqlParameter("@IsValid", MySqlDbType.Bit,1), new MySqlParameter("@Checked", MySqlDbType.Int32), new MySqlParameter("@Checker", MySqlDbType.VarChar,50), new MySqlParameter("@CheckMemo",MySqlDbType.VarChar,50)}; parameters[0].Value = model.Title; parameters[1].Value = model.CategoryID; parameters[2].Value = model.Contents; parameters[3].Value = model.Publisher; parameters[4].Value = model.DataSource; parameters[5].Value = model.DataType; parameters[6].Value = model.LastModifyTime; parameters[7].Value = model.IsValid; parameters[8].Value = model.Checked; parameters[9].Value = model.Checker; parameters[10].Value = model.CheckMemo; object obj = DbHelperMySQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt64(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public long Add(SmartLaw.Model.CategoryRegionalRelation model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into CategoryRegionalRelation("); strSql.Append("CategotyID,RegionalID)"); strSql.Append(" values ("); strSql.Append("@CategotyID,@RegionalID)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@CategotyID", MySqlDbType.Int64), new MySqlParameter("@RegionalID", MySqlDbType.VarChar,50)}; parameters[0].Value = model.CategotyID; parameters[1].Value = model.RegionalID; object obj = DbHelperMySQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt64(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public long Add(SmartLaw.Model.SysCodeRelation model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into SysCodeRelation("); strSql.Append("SysCodeDetialID,SysCodeDetialIDEx)"); strSql.Append(" values ("); strSql.Append("@SysCodeDetialID,@SysCodeDetialIDEx)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@SysCodeDetialID", MySqlDbType.VarChar,50), new MySqlParameter("@SysCodeDetialIDEx", MySqlDbType.VarChar,50)}; parameters[0].Value = model.SysCodeDetialID; parameters[1].Value = model.SysCodeDetialIDEx; object obj = DbHelperMySQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt64(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public long Add(SmartLaw.Model.Prize model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Prize("); strSql.Append("PrizeName,PrizeUnit,Points,Registrant,Stock,Remarks,RegTime,Picture)"); strSql.Append(" values ("); strSql.Append("@PrizeName,@PrizeUnit,@Points,@Registrant,@Stock,@Remarks,@RegTime,@Picture)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@PrizeName", MySqlDbType.VarChar,64), new MySqlParameter("@PrizeUnit", MySqlDbType.VarChar,16), new MySqlParameter("@Points", MySqlDbType.Int32), new MySqlParameter("@Registrant", MySqlDbType.VarChar,16), new MySqlParameter("@Stock", MySqlDbType.Int64), new MySqlParameter("@Remarks", MySqlDbType.VarChar,255), new MySqlParameter("@RegTime", MySqlDbType.DateTime), new MySqlParameter("@Picture", MySqlDbType.VarChar,128)}; parameters[0].Value = model.PrizeName; parameters[1].Value = model.PrizeUnit; parameters[2].Value = model.Points; parameters[3].Value = model.Registrant; parameters[4].Value = model.Stock; parameters[5].Value = model.Remarks; parameters[6].Value = model.RegTime; parameters[7].Value = model.Picture; object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return 0; } else { return Convert.ToInt64(obj); } }
/// <summary> /// 增加公告 /// </summary> public long Add(SmartLaw.Model.Message model) { return dal.Add(model); }
/// <summary> /// 增加公告 /// </summary> public long Add(SmartLaw.Model.Notice model) { return dal.Add(model); }
/// <summary> /// 更新公告 /// </summary> public bool Update(SmartLaw.Model.Notice model) { return dal.Update(model); }
/// <summary> /// 增加奖品 /// </summary> public long Add(SmartLaw.Model.Prize model) { return dal.Add(model); }
/// <summary> /// 更新奖品 /// </summary> public bool Update(SmartLaw.Model.Prize model) { return dal.Update(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(SmartLaw.Model.NoticeRegionalRelation model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update NoticeRegionalRelation set "); strSql.Append("NoticeID=@NoticeID,"); strSql.Append("RegionalID=@RegionalID"); strSql.Append(" where AutoID=@AutoID "); MySqlParameter[] parameters = { new MySqlParameter("@NoticeID", MySqlDbType.Int64), new MySqlParameter("@RegionalID", MySqlDbType.VarChar,50), new MySqlParameter("@AutoID", MySqlDbType.Int64)}; parameters[0].Value = model.NoticeID; parameters[1].Value = model.RegionalID; parameters[2].Value = model.AutoID; int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新公告 /// </summary> public bool Update(SmartLaw.Model.Message model) { return dal.Update(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(SmartLaw.Model.MessageToObject model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update MessageToObject set "); strSql.Append("MsgID=@MsgID,"); strSql.Append("ObjType=@ObjType"); strSql.Append("ObjValue=@ObjValue"); strSql.Append(" where AutoID=@AutoID "); MySqlParameter[] parameters = { new MySqlParameter("@AutoID", MySqlDbType.Int64), new MySqlParameter("@MsgID", MySqlDbType.Int64), new MySqlParameter("@ObjType", MySqlDbType.VarChar,50), new MySqlParameter("@ObjValue", MySqlDbType.VarChar,50) }; parameters[0].Value = model.AutoID; parameters[1].Value = model.MsgID; parameters[2].Value = model.ObjType; parameters[3].Value = model.ObjValue; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加区域 /// </summary> public bool Add(SmartLaw.Model.Regional model) { return dal.Add(model); }