/// <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);
}
