/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from " + databaseprefix + "user_oauth_app ");
strSql.Append(" where id=@id");
OleDbParameter[] parameters =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters[0].Value = id;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int deptId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from dept ");
strSql.Append(" where deptId=@deptId");
OleDbParameter[] parameters =
{
new OleDbParameter("@deptId", OleDbType.Integer, 4)
};
parameters[0].Value = deptId;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool UpdateTypeidByIdList(int typeid, string IdList)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dbo_Article set ");
strSql.Append("dbo_Typeid=@dbo_Typeid");
strSql.Append(" where ID in (" + IdList + ") ");
OleDbParameter[] parameters =
{
new OleDbParameter("@dbo_Typeid", OleDbType.Integer, 4)
};
parameters[0].Value = typeid;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from [db_theExamNo] ");
strSql.Append(" where ID=@ID ");
OleDbParameter[] parameters =
{
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = ID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据，带事务
/// </summary>
public bool Delete(OleDbConnection conn, OleDbTransaction trans, string nav_name)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from " + databaseprefix + "navigation");
strSql.Append(" where name=@name");
OleDbParameter[] parameters =
{
new OleDbParameter("@name", OleDbType.VarChar, 50)
};
parameters[0].Value = nav_name;
int rows = DbHelperOleDb.ExecuteSql(conn, trans, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string Pid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from SaleInfo ");
strSql.Append(" where Pid=@Pid ");
OleDbParameter[] parameters =
{
new OleDbParameter("@Pid", OleDbType.VarChar, 50)
};
parameters[0].Value = Pid;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string Code)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from GoodsInfo ");
strSql.Append(" where Code=@Code ");
OleDbParameter[] parameters =
{
new OleDbParameter("@Code", OleDbType.VarChar, 50)
};
parameters[0].Value = Code;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int QFUREFCODE)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from QFUREFERENCE ");
strSql.Append(" where QFUREFCODE=@QFUREFCODE");
OleDbParameter[] parameters =
{
new OleDbParameter("@QFUREFCODE", OleDbType.Integer, 4)
};
parameters[0].Value = QFUREFCODE;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string methodName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from tb_GBT282892012_TensileSel ");
strSql.Append(" where methodName=@methodName");
OleDbParameter[] parameters =
{
new OleDbParameter("@methodName", OleDbType.VarChar)
};
parameters[0].Value = methodName;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string testNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from tb_GBT282892012_Twist ");
strSql.Append(" where testNo=@testNo");
OleDbParameter[] parameters =
{
new OleDbParameter("@testNo", OleDbType.VarChar)
};
parameters[0].Value = testNo;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Update(Rain.Model.user_oauth_app model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update " + this.databaseprefix + "user_oauth_app set ");
stringBuilder.Append("title=@title,");
stringBuilder.Append("img_url=@img_url,");
stringBuilder.Append("app_id=@app_id,");
stringBuilder.Append("app_key=@app_key,");
stringBuilder.Append("[remark]=@remark,");
stringBuilder.Append("sort_id=@sort_id,");
stringBuilder.Append("is_lock=@is_lock,");
stringBuilder.Append("api_path=@api_path");
stringBuilder.Append(" where id=@id");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[9]
{
new OleDbParameter("@title", OleDbType.VarChar, 100),
new OleDbParameter("@img_url", OleDbType.VarChar, (int)byte.MaxValue),
new OleDbParameter("@app_id", OleDbType.VarChar, 100),
new OleDbParameter("@app_key", OleDbType.VarChar, 500),
new OleDbParameter("@remark", OleDbType.VarChar, 500),
new OleDbParameter("@sort_id", OleDbType.Integer, 4),
new OleDbParameter("@is_lock", OleDbType.Integer, 4),
new OleDbParameter("@api_path", OleDbType.VarChar, (int)byte.MaxValue),
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray[0].Value = (object)model.title;
oleDbParameterArray[1].Value = (object)model.img_url;
oleDbParameterArray[2].Value = (object)model.app_id;
oleDbParameterArray[3].Value = (object)model.app_key;
oleDbParameterArray[4].Value = (object)model.remark;
oleDbParameterArray[5].Value = (object)model.sort_id;
oleDbParameterArray[6].Value = (object)model.is_lock;
oleDbParameterArray[7].Value = (object)model.api_path;
oleDbParameterArray[8].Value = (object)model.id;
return(DbHelperOleDb.ExecuteSql(stringBuilder.ToString(), oleDbParameterArray) > 0);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HR_Test.Model.Standard model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_Standard(");
strSql.Append("standardNo,standardName,testType,resultTableName,selTableName,methodTableName,sign)");
strSql.Append(" values (");
strSql.Append("@standardNo,@standardName,@testType,@resultTableName,@selTableName,@methodTableName,@sign)");
OleDbParameter[] parameters =
{
new OleDbParameter("@standardNo", OleDbType.VarChar, 255),
new OleDbParameter("@standardName", OleDbType.VarChar, 255),
new OleDbParameter("@testType", OleDbType.VarChar, 255),
new OleDbParameter("@resultTableName", OleDbType.VarChar, 255),
new OleDbParameter("@selTableName", OleDbType.VarChar, 255),
new OleDbParameter("@methodTableName", OleDbType.VarChar, 255),
new OleDbParameter("@sign", OleDbType.VarChar, 0)
};
parameters[0].Value = model.standardNo;
parameters[1].Value = model.standardName;
parameters[2].Value = model.testType;
parameters[3].Value = model.resultTableName;
parameters[4].Value = model.selTableName;
parameters[5].Value = model.methodTableName;
parameters[6].Value = model.sign;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HR_Test.Model.GBT236152009_SelHeng model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_GBT236152009_SelHeng(");
strSql.Append("methodName,Fmax,T1,T1_,S,T1c,isSaveCurve)");
strSql.Append(" values (");
strSql.Append("@methodName,@Fmax,@T1,@T1_,@S,@T1c,@isSaveCurve)");
OleDbParameter[] parameters =
{
new OleDbParameter("@methodName", OleDbType.VarChar, 255),
new OleDbParameter("@Fmax", OleDbType.Boolean, 1),
new OleDbParameter("@T1", OleDbType.Boolean, 1),
new OleDbParameter("@T1_", OleDbType.Boolean, 1),
new OleDbParameter("@S", OleDbType.Boolean, 1),
new OleDbParameter("@T1c", OleDbType.Boolean, 1),
new OleDbParameter("@isSaveCurve", OleDbType.Boolean, 1)
};
parameters[0].Value = model.methodName;
parameters[1].Value = model.Fmax;
parameters[2].Value = model.T1;
parameters[3].Value = model.T1_;
parameters[4].Value = model.S;
parameters[5].Value = model.T1c;
parameters[6].Value = model.isSaveCurve;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(cycms.Model.FriendLink model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo_FriendLink(");
strSql.Append("dbo_FactoryLink,dbo_FactoryProductName,dbo_FactoryLogoSrc,dbo_ProductImgLink,dbo_ProductImgSrc,dbo_ProductImgName,dbo_ProductInfo)");
strSql.Append(" values (");
strSql.Append("@dbo_FactoryLink,@dbo_FactoryProductName,@dbo_FactoryLogoSrc,@dbo_ProductImgLink,@dbo_ProductImgSrc,@dbo_ProductImgName,@dbo_ProductInfo)");
OleDbParameter[] parameters =
{
new OleDbParameter("@dbo_FactoryLink", OleDbType.VarChar, 255),
new OleDbParameter("@dbo_FactoryProductName", OleDbType.VarChar, 50),
new OleDbParameter("@dbo_FactoryLogoSrc", OleDbType.VarChar, 255),
new OleDbParameter("@dbo_ProductImgLink", OleDbType.VarChar, 255),
new OleDbParameter("@dbo_ProductImgSrc", OleDbType.VarChar, 255),
new OleDbParameter("@dbo_ProductImgName", OleDbType.VarChar, 255),
new OleDbParameter("@dbo_ProductInfo", OleDbType.VarChar, 0)
};
parameters[0].Value = model.dbo_FactoryLink;
parameters[1].Value = model.dbo_FactoryProductName;
parameters[2].Value = model.dbo_FactoryLogoSrc;
parameters[3].Value = model.dbo_ProductImgLink;
parameters[4].Value = model.dbo_ProductImgSrc;
parameters[5].Value = model.dbo_ProductImgName;
parameters[6].Value = model.dbo_ProductInfo;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Scheme_AutoGrp model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Scheme_AutoGrp set ");
strSql.Append(" intListNo = @intListNo , ");
strSql.Append(" chrGrpType = @chrGrpType , ");
strSql.Append(" intItemTypeOrPrjNo = @intItemTypeOrPrjNo , ");
strSql.Append(" chrSpecOrDataName = @chrSpecOrDataName ");
strSql.Append(" where schemeID=@schemeID ");
OleDbParameter[] parameters =
{
new OleDbParameter("@schemeID", OleDbType.Integer, 4),
new OleDbParameter("@intListNo", OleDbType.Integer, 4),
new OleDbParameter("@chrGrpType", OleDbType.VarChar, 8),
new OleDbParameter("@intItemTypeOrPrjNo", OleDbType.Integer, 4),
new OleDbParameter("@chrSpecOrDataName", OleDbType.VarChar, 50)
};
parameters[4].Value = model.schemeID;
parameters[5].Value = model.intListNo;
parameters[6].Value = model.chrGrpType;
parameters[7].Value = model.intItemTypeOrPrjNo;
parameters[8].Value = model.chrSpecOrDataName;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(cycms.Model.DownLoadFile model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo_DownLoadFile(");
strSql.Append("dbo_FileName,dbo_FileTitle,dbo_FileSize,dbo_Ptime,dbo_OtherInfo,dbo_TypeId,dbo_IsLock)");
strSql.Append(" values (");
strSql.Append("@dbo_FileName,@dbo_FileTitle,@dbo_FileSize,@dbo_Ptime,@dbo_OtherInfo,@dbo_TypeId,@dbo_IsLock)");
OleDbParameter[] parameters =
{
new OleDbParameter("@dbo_FileName", OleDbType.VarChar, 100),
new OleDbParameter("@dbo_FileTitle", OleDbType.VarChar, 100),
new OleDbParameter("@dbo_FileSize", OleDbType.Integer, 4),
new OleDbParameter("@dbo_Ptime", OleDbType.Date),
new OleDbParameter("@dbo_OtherInfo", OleDbType.VarChar, 0),
new OleDbParameter("@dbo_TypeId", OleDbType.Integer, 4),
new OleDbParameter("@dbo_IsLock", OleDbType.Boolean, 1)
};
parameters[0].Value = model.dbo_FileName;
parameters[1].Value = model.dbo_FileTitle;
parameters[2].Value = model.dbo_FileSize;
parameters[3].Value = model.dbo_Ptime;
parameters[4].Value = model.dbo_OtherInfo;
parameters[5].Value = model.dbo_TypeId;
parameters[6].Value = model.dbo_IsLock;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HR_Test.Model.GBT282892012_TensileSel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_GBT282892012_TensileSel(");
strSql.Append("methodName,FQmax,Q,Q_,SQ,Qc,isSaveCurve)");
strSql.Append(" values (");
strSql.Append("@methodName,@FQmax,@Q,@Q_,@SQ,@Qc,@isSaveCurve)");
OleDbParameter[] parameters =
{
new OleDbParameter("@methodName", OleDbType.VarChar, 255),
new OleDbParameter("@FQmax", OleDbType.Boolean, 1),
new OleDbParameter("@Q", OleDbType.Boolean, 1),
new OleDbParameter("@Q_", OleDbType.Boolean, 1),
new OleDbParameter("@SQ", OleDbType.Boolean, 1),
new OleDbParameter("@Qc", OleDbType.Boolean, 1),
new OleDbParameter("@isSaveCurve", OleDbType.Boolean, 1)
};
parameters[0].Value = model.methodName;
parameters[1].Value = model.FQmax;
parameters[2].Value = model.Q;
parameters[3].Value = model.Q_;
parameters[4].Value = model.SQ;
parameters[5].Value = model.Qc;
parameters[6].Value = model.isSaveCurve;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Dong.Model.OperInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OperInfo(");
strSql.Append("Code,Pwd,Name,Sex,CId,Phone,Role)");
strSql.Append(" values (");
strSql.Append("@Code,@Pwd,@Name,@Sex,@CId,@Phone,@Role)");
OleDbParameter[] parameters =
{
new OleDbParameter("@Code", OleDbType.VarChar, 50),
new OleDbParameter("@Pwd", OleDbType.VarChar, 50),
new OleDbParameter("@Name", OleDbType.VarChar, 50),
new OleDbParameter("@Sex", OleDbType.VarChar, 50),
new OleDbParameter("@CId", OleDbType.VarChar, 50),
new OleDbParameter("@Phone", OleDbType.VarChar, 50),
new OleDbParameter("@Role", OleDbType.Integer, 4)
};
parameters[0].Value = model.Code;
parameters[1].Value = model.Pwd;
parameters[2].Value = model.Name;
parameters[3].Value = model.Sex;
parameters[4].Value = model.CId;
parameters[5].Value = model.Phone;
parameters[6].Value = model.Role;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.DEVICEBASE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into DEVICEBASE(");
strSql.Append("NAME,FUNDING,LOSSINFO,PURCHASEPLAN,INVESTMENT,PURCHASEDATE,DESCRIPTION)");
strSql.Append(" values (");
strSql.Append("@NAME,@FUNDING,@LOSSINFO,@PURCHASEPLAN,@INVESTMENT,@PURCHASEDATE,@DESCRIPTION)");
OleDbParameter[] parameters =
{
new OleDbParameter("@NAME", OleDbType.VarChar, 50),
new OleDbParameter("@FUNDING", OleDbType.Double),
new OleDbParameter("@LOSSINFO", OleDbType.VarChar, 255),
new OleDbParameter("@PURCHASEPLAN", OleDbType.VarChar, 255),
new OleDbParameter("@INVESTMENT", OleDbType.Double),
new OleDbParameter("@PURCHASEDATE", OleDbType.Date),
new OleDbParameter("@DESCRIPTION", OleDbType.VarChar, 255)
};
parameters[0].Value = model.NAME;
parameters[1].Value = model.FUNDING;
parameters[2].Value = model.LOSSINFO;
parameters[3].Value = model.PURCHASEPLAN;
parameters[4].Value = model.INVESTMENT;
parameters[5].Value = model.PURCHASEDATE;
parameters[6].Value = model.DESCRIPTION;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(hm.Model.sysItem model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sysItem(");
strSql.Append("sicId,itemName,orders,col1,col2,col3,col4)");
strSql.Append(" values (");
strSql.Append("@sicId,@itemName,@orders,@col1,@col2,@col3,@col4)");
OleDbParameter[] parameters =
{
new OleDbParameter("@sicId", OleDbType.Integer, 4),
new OleDbParameter("@itemName", OleDbType.VarChar, 0),
new OleDbParameter("@orders", OleDbType.Integer, 4),
new OleDbParameter("@col1", OleDbType.VarChar, 255),
new OleDbParameter("@col2", OleDbType.VarChar, 255),
new OleDbParameter("@col3", OleDbType.VarChar, 255),
new OleDbParameter("@col4", OleDbType.Integer, 4)
};
parameters[0].Value = model.sicId;
parameters[1].Value = model.itemName;
parameters[2].Value = model.orders;
parameters[3].Value = model.col1;
parameters[4].Value = model.col2;
parameters[5].Value = model.col3;
parameters[6].Value = model.col4;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(hm.Model.web_site model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into web_site(");
strSql.Append("webName,title,keywords,description,logo,bottom,qq)");
strSql.Append(" values (");
strSql.Append("@webName,@title,@keywords,@description,@logo,@bottom,@qq)");
OleDbParameter[] parameters =
{
new OleDbParameter("@webName", OleDbType.VarChar, 255),
new OleDbParameter("@title", OleDbType.VarChar, 255),
new OleDbParameter("@keywords", OleDbType.VarChar, 255),
new OleDbParameter("@description", OleDbType.VarChar, 255),
new OleDbParameter("@logo", OleDbType.VarChar, 255),
new OleDbParameter("@bottom", OleDbType.VarChar, 0),
new OleDbParameter("@qq", OleDbType.VarChar, 255)
};
parameters[0].Value = model.webName;
parameters[1].Value = model.title;
parameters[2].Value = model.keywords;
parameters[3].Value = model.description;
parameters[4].Value = model.logo;
parameters[5].Value = model.bottom;
parameters[6].Value = model.qq;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(cycms.Model.TeacherStudyResume model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo_TeacherStudyResume(");
strSql.Append("dbo_StartTime,dbo_EndTime,dbo_School,dbo_Professional,dbo_GraduateTime,dbo_Remark,dbo_TeacherId)");
strSql.Append(" values (");
strSql.Append("@dbo_StartTime,@dbo_EndTime,@dbo_School,@dbo_Professional,@dbo_GraduateTime,@dbo_Remark,@dbo_TeacherId)");
OleDbParameter[] parameters =
{
new OleDbParameter("@dbo_StartTime", OleDbType.VarChar, 100),
new OleDbParameter("@dbo_EndTime", OleDbType.VarChar, 100),
new OleDbParameter("@dbo_School", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_Professional", OleDbType.VarChar, 100),
new OleDbParameter("@dbo_GraduateTime", OleDbType.VarChar, 100),
new OleDbParameter("@dbo_Remark", OleDbType.VarChar, 0),
new OleDbParameter("@dbo_TeacherId", OleDbType.Integer, 4)
};
parameters[0].Value = model.dbo_StartTime;
parameters[1].Value = model.dbo_EndTime;
parameters[2].Value = model.dbo_School;
parameters[3].Value = model.dbo_Professional;
parameters[4].Value = model.dbo_GraduateTime;
parameters[5].Value = model.dbo_Remark;
parameters[6].Value = model.dbo_TeacherId;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HR_Test.Model.GBT282892012_TwistSel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_GBT282892012_TwistSel(");
strSql.Append("methodName,FMmax,M,M_,SM,Mc,saveCurve)");
strSql.Append(" values (");
strSql.Append("@methodName,@FMmax,@M,@M_,@SM,@Mc,@saveCurve)");
OleDbParameter[] parameters =
{
new OleDbParameter("@methodName", OleDbType.VarChar, 255),
new OleDbParameter("@FMmax", OleDbType.Boolean, 1),
new OleDbParameter("@M", OleDbType.Boolean, 1),
new OleDbParameter("@M_", OleDbType.Boolean, 1),
new OleDbParameter("@SM", OleDbType.Boolean, 1),
new OleDbParameter("@Mc", OleDbType.Boolean, 1),
new OleDbParameter("@saveCurve", OleDbType.Boolean, 1)
};
parameters[0].Value = model.methodName;
parameters[1].Value = model.FMmax;
parameters[2].Value = model.M;
parameters[3].Value = model.M_;
parameters[4].Value = model.SM;
parameters[5].Value = model.Mc;
parameters[6].Value = model.saveCurve;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(cycms.Model.IPHistry model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo_IPHistry(");
strSql.Append("dbo_IPAddress,dbo_Address,dbo_Area,dbo_Ptime,dbo_Browser,dbo_Platform,dbo_PageTitle)");
strSql.Append(" values (");
strSql.Append("@dbo_IPAddress,@dbo_Address,@dbo_Area,@dbo_Ptime,@dbo_Browser,@dbo_Platform,@dbo_PageTitle)");
OleDbParameter[] parameters =
{
new OleDbParameter("@dbo_IPAddress", OleDbType.VarChar, 20),
new OleDbParameter("@dbo_Address", OleDbType.VarChar, 255),
new OleDbParameter("@dbo_Area", OleDbType.VarChar, 100),
new OleDbParameter("@dbo_Ptime", OleDbType.Date),
new OleDbParameter("@dbo_Browser", OleDbType.VarChar, 100),
new OleDbParameter("@dbo_Platform", OleDbType.VarChar, 100),
new OleDbParameter("@dbo_PageTitle", OleDbType.VarChar, 50)
};
parameters[0].Value = model.dbo_IPAddress;
parameters[1].Value = model.dbo_Address;
parameters[2].Value = model.dbo_Area;
parameters[3].Value = model.dbo_Ptime;
parameters[4].Value = model.dbo_Browser;
parameters[5].Value = model.dbo_Platform;
parameters[6].Value = model.dbo_PageTitle;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.TEACHERBASE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TEACHERBASE(");
strSql.Append("JOBNUMBER,NAME,SEX,PHOTO,PHONE,EXPHONE,DESCRIPTION)");
strSql.Append(" values (");
strSql.Append("@JOBNUMBER,@NAME,@SEX,@PHOTO,@PHONE,@EXPHONE,@DESCRIPTION)");
OleDbParameter[] parameters =
{
new OleDbParameter("@JOBNUMBER", OleDbType.VarChar, 255),
new OleDbParameter("@NAME", OleDbType.VarChar, 30),
new OleDbParameter("@SEX", OleDbType.Boolean, 1),
new OleDbParameter("@PHOTO", OleDbType.Binary, 0),
new OleDbParameter("@PHONE", OleDbType.VarChar, 20),
new OleDbParameter("@EXPHONE", OleDbType.VarChar, 20),
new OleDbParameter("@DESCRIPTION", OleDbType.VarChar, 255)
};
parameters[0].Value = model.JOBNUMBER;
parameters[1].Value = model.NAME;
parameters[2].Value = model.SEX;
parameters[3].Value = model.PHOTO;
parameters[4].Value = model.PHONE;
parameters[5].Value = model.EXPHONE;
parameters[6].Value = model.DESCRIPTION;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.TreatHistory model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TreatHistory(");
strSql.Append("PID,GID,Disease,IllYear,TreatInfo,TreatResult,MedicateHistory)");
strSql.Append(" values (");
strSql.Append("@PID,@GID,@Disease,@IllYear,@TreatInfo,@TreatResult,@MedicateHistory)");
OleDbParameter[] parameters =
{
new OleDbParameter("@PID", OleDbType.Integer, 4),
new OleDbParameter("@GID", OleDbType.Integer, 4),
new OleDbParameter("@Disease", OleDbType.VarChar, 50),
new OleDbParameter("@IllYear", OleDbType.VarChar, 50),
new OleDbParameter("@TreatInfo", OleDbType.VarChar, 50),
new OleDbParameter("@TreatResult", OleDbType.VarChar, 50),
new OleDbParameter("@MedicateHistory", OleDbType.VarChar, 50)
};
parameters[0].Value = model.PID;
parameters[1].Value = model.GID;
parameters[2].Value = model.Disease;
parameters[3].Value = model.IllYear;
parameters[4].Value = model.TreatInfo;
parameters[5].Value = model.TreatResult;
parameters[6].Value = model.MedicateHistory;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HR_Test.Model.StandardResultItemInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_StandardResultItemInfo(");
strSql.Append("standardNo,testType,paramName,unit,paramDiscrible,isCheck,sign)");
strSql.Append(" values (");
strSql.Append("@standardNo,@testType,@paramName,@unit,@paramDiscrible,@isCheck,@sign)");
OleDbParameter[] parameters =
{
new OleDbParameter("@standardNo", OleDbType.VarChar, 255),
new OleDbParameter("@testType", OleDbType.VarChar, 255),
new OleDbParameter("@paramName", OleDbType.VarChar, 255),
new OleDbParameter("@unit", OleDbType.VarChar, 0),
new OleDbParameter("@paramDiscrible", OleDbType.VarChar, 255),
new OleDbParameter("@isCheck", OleDbType.Boolean, 1),
new OleDbParameter("@sign", OleDbType.VarChar, 0)
};
parameters[0].Value = model.standardNo;
parameters[1].Value = model.testType;
parameters[2].Value = model.paramName;
parameters[3].Value = model.unit;
parameters[4].Value = model.paramDiscrible;
parameters[5].Value = model.isCheck;
parameters[6].Value = model.sign;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.BadReaction model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BadReaction(");
strSql.Append("PID,Peroid,ReactionName,OccurDate,Severity,TreatMethod,TreatResult)");
strSql.Append(" values (");
strSql.Append("@PID,@Peroid,@ReactionName,@OccurDate,@Severity,@TreatMethod,@TreatResult)");
OleDbParameter[] parameters =
{
new OleDbParameter("@PID", OleDbType.Integer, 4),
new OleDbParameter("@Peroid", OleDbType.Integer, 4),
new OleDbParameter("@ReactionName", OleDbType.VarChar, 50),
new OleDbParameter("@OccurDate", OleDbType.Date),
new OleDbParameter("@Severity", OleDbType.VarChar, 50),
new OleDbParameter("@TreatMethod", OleDbType.VarChar, 50),
new OleDbParameter("@TreatResult", OleDbType.VarChar, 50)
};
parameters[0].Value = model.PID;
parameters[1].Value = model.Peroid;
parameters[2].Value = model.ReactionName;
parameters[3].Value = model.OccurDate;
parameters[4].Value = model.Severity;
parameters[5].Value = model.TreatMethod;
parameters[6].Value = model.TreatResult;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Express.Model.OrgOrder model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OrgOrder(");
strSql.Append("orderno,pid,temp0,temp1,temp2,remark,imtime)");
strSql.Append(" values (");
strSql.Append("@orderno,@pid,@temp0,@temp1,@temp2,@remark,@imtime)");
OleDbParameter[] parameters =
{
new OleDbParameter("@orderno", OleDbType.VarChar, 30),
new OleDbParameter("@pid", OleDbType.VarChar, 30),
new OleDbParameter("@temp0", OleDbType.VarChar, 30),
new OleDbParameter("@temp1", OleDbType.VarChar, 30),
new OleDbParameter("@temp2", OleDbType.VarChar, 30),
new OleDbParameter("@remark", OleDbType.VarChar, 100),
new OleDbParameter("@imtime", OleDbType.Date)
};
parameters[0].Value = model.orderno;
parameters[1].Value = model.pid;
parameters[2].Value = model.temp0;
parameters[3].Value = model.temp1;
parameters[4].Value = model.temp2;
parameters[5].Value = model.remark;
parameters[6].Value = model.imtime;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(ERM.MDL.docFormat model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.code != null)
{
strSql1.Append("code,");
strSql2.Append("'" + model.code + "',");
}
if (model.typename != null)
{
strSql1.Append("typename,");
strSql2.Append("'" + model.typename + "',");
}
strSql.Append("insert into docFormat(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
DbHelperOleDb.ExecuteSql(strSql.ToString());
}
