/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HR_Test.Model.GBT282892012_Tensile model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_GBT282892012_Tensile(");
strSql.Append("testMethodName,testNo,testSampleNo,reportNo,sendCompany,stuffCardNo,stuffSpec,stuffType,hotStatus,temperature,humidity,testStandard,testMethod,mathineType,testCondition,sampleCharacter,getSample,tester,assessor,sign,L,S0,FQmax,Q,isFinish,testDate,condition,controlmode,isUseExtensometer,isEffective)");
strSql.Append(" values (");
strSql.Append("@testMethodName,@testNo,@testSampleNo,@reportNo,@sendCompany,@stuffCardNo,@stuffSpec,@stuffType,@hotStatus,@temperature,@humidity,@testStandard,@testMethod,@mathineType,@testCondition,@sampleCharacter,@getSample,@tester,@assessor,@sign,@L,@S0,@FQmax,@Q,@isFinish,@testDate,@condition,@controlmode,@isUseExtensometer,@isEffective)");
OleDbParameter[] parameters =
{
new OleDbParameter("@testMethodName", OleDbType.VarChar, 100),
new OleDbParameter("@testNo", OleDbType.VarChar, 100),
new OleDbParameter("@testSampleNo", OleDbType.VarChar, 100),
new OleDbParameter("@reportNo", OleDbType.VarChar, 100),
new OleDbParameter("@sendCompany", OleDbType.VarChar, 100),
new OleDbParameter("@stuffCardNo", OleDbType.VarChar, 100),
new OleDbParameter("@stuffSpec", OleDbType.VarChar, 100),
new OleDbParameter("@stuffType", OleDbType.VarChar, 100),
new OleDbParameter("@hotStatus", OleDbType.VarChar, 100),
new OleDbParameter("@temperature", OleDbType.Double),
new OleDbParameter("@humidity", OleDbType.Double),
new OleDbParameter("@testStandard", OleDbType.VarChar, 100),
new OleDbParameter("@testMethod", OleDbType.VarChar, 100),
new OleDbParameter("@mathineType", OleDbType.VarChar, 100),
new OleDbParameter("@testCondition", OleDbType.VarChar, 100),
new OleDbParameter("@sampleCharacter", OleDbType.VarChar, 100),
new OleDbParameter("@getSample", OleDbType.VarChar, 100),
new OleDbParameter("@tester", OleDbType.VarChar, 100),
new OleDbParameter("@assessor", OleDbType.VarChar, 100),
new OleDbParameter("@sign", OleDbType.VarChar, 255),
new OleDbParameter("@L", OleDbType.Double),
new OleDbParameter("@S0", OleDbType.Double),
new OleDbParameter("@FQmax", OleDbType.Double),
new OleDbParameter("@Q", OleDbType.Double),
new OleDbParameter("@isFinish", OleDbType.Boolean, 1),
new OleDbParameter("@testDate", OleDbType.Date),
new OleDbParameter("@condition", OleDbType.VarChar, 255),
new OleDbParameter("@controlmode", OleDbType.VarChar, 255),
new OleDbParameter("@isUseExtensometer", OleDbType.Boolean, 1),
new OleDbParameter("@isEffective", OleDbType.Boolean, 1)
};
parameters[0].Value = model.testMethodName;
parameters[1].Value = model.testNo;
parameters[2].Value = model.testSampleNo;
parameters[3].Value = model.reportNo;
parameters[4].Value = model.sendCompany;
parameters[5].Value = model.stuffCardNo;
parameters[6].Value = model.stuffSpec;
parameters[7].Value = model.stuffType;
parameters[8].Value = model.hotStatus;
parameters[9].Value = model.temperature;
parameters[10].Value = model.humidity;
parameters[11].Value = model.testStandard;
parameters[12].Value = model.testMethod;
parameters[13].Value = model.mathineType;
parameters[14].Value = model.testCondition;
parameters[15].Value = model.sampleCharacter;
parameters[16].Value = model.getSample;
parameters[17].Value = model.tester;
parameters[18].Value = model.assessor;
parameters[19].Value = model.sign;
parameters[20].Value = model.L;
parameters[21].Value = model.S0;
parameters[22].Value = model.FQmax;
parameters[23].Value = model.Q;
parameters[24].Value = model.isFinish;
parameters[25].Value = model.testDate;
parameters[26].Value = model.condition;
parameters[27].Value = model.controlmode;
parameters[28].Value = model.isUseExtensometer;
parameters[29].Value = model.isEffective;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperOleDb.GetMaxID("ID", "KIDATTENDANCE"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperOleDb.GetMaxID("ID", "dbo_TeacherWorkResume"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperOleDb.GetMaxID("ID", "userinfo"));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.navigation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update " + databaseprefix + "navigation set ");
strSql.Append("parent_id=@parent_id,");
strSql.Append("channel_id=@channel_id,");
strSql.Append("nav_type=@nav_type,");
strSql.Append("[name]=@name,");
strSql.Append("title=@title,");
strSql.Append("sub_title=@sub_title,");
strSql.Append("icon_url=@icon_url,");
strSql.Append("link_url=@link_url,");
strSql.Append("sort_id=@sort_id,");
strSql.Append("is_lock=@is_lock,");
strSql.Append("[remark]=@remark,");
strSql.Append("action_type=@action_type,");
strSql.Append("is_sys=@is_sys");
strSql.Append(" where id=@id");
OleDbParameter[] parameters =
{
new OleDbParameter("@parent_id", OleDbType.Integer, 4),
new OleDbParameter("@channel_id", OleDbType.Integer, 4),
new OleDbParameter("@nav_type", OleDbType.VarChar, 50),
new OleDbParameter("@name", OleDbType.VarChar, 50),
new OleDbParameter("@title", OleDbType.VarChar, 100),
new OleDbParameter("@sub_title", OleDbType.VarChar, 100),
new OleDbParameter("@icon_url", OleDbType.VarChar, 255),
new OleDbParameter("@link_url", OleDbType.VarChar, 255),
new OleDbParameter("@sort_id", OleDbType.Integer, 4),
new OleDbParameter("@is_lock", OleDbType.Integer, 4),
new OleDbParameter("@remark", OleDbType.VarChar, 500),
new OleDbParameter("@action_type", OleDbType.VarChar, 500),
new OleDbParameter("@is_sys", OleDbType.Integer, 4),
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters[0].Value = model.parent_id;
parameters[1].Value = model.channel_id;
parameters[2].Value = model.nav_type;
parameters[3].Value = model.name;
parameters[4].Value = model.title;
parameters[5].Value = model.sub_title;
parameters[6].Value = model.icon_url;
parameters[7].Value = model.link_url;
parameters[8].Value = model.sort_id;
parameters[9].Value = model.is_lock;
parameters[10].Value = model.remark;
parameters[11].Value = model.action_type;
parameters[12].Value = model.is_sys;
parameters[13].Value = model.id;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(HR_Test.Model.GBT282892012_ShearSel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_GBT282892012_ShearSel set ");
strSql.Append("methodName=@methodName,");
strSql.Append("FTmax=@FTmax,");
strSql.Append("T=@T,");
strSql.Append("C1=@C1,");
strSql.Append("C1R_=@C1R_,");
strSql.Append("C1cR=@C1cR,");
strSql.Append("C1L_=@C1L_,");
strSql.Append("C1cL=@C1cL,");
strSql.Append("C1H_=@C1H_,");
strSql.Append("C1cH=@C1cH,");
strSql.Append("T_=@T_,");
strSql.Append("ST=@ST,");
strSql.Append("Tc=@Tc,");
strSql.Append("saveCurve=@saveCurve");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@methodName", OleDbType.VarChar, 255),
new OleDbParameter("@FTmax", OleDbType.Boolean, 1),
new OleDbParameter("@T", OleDbType.Boolean, 1),
new OleDbParameter("@C1", OleDbType.Boolean, 1),
new OleDbParameter("@C1R_", OleDbType.Boolean, 1),
new OleDbParameter("@C1cR", OleDbType.Boolean, 1),
new OleDbParameter("@C1L_", OleDbType.Boolean, 1),
new OleDbParameter("@C1cL", OleDbType.Boolean, 1),
new OleDbParameter("@C1H_", OleDbType.Boolean, 1),
new OleDbParameter("@C1cH", OleDbType.Boolean, 1),
new OleDbParameter("@T_", OleDbType.Boolean, 1),
new OleDbParameter("@ST", OleDbType.Boolean, 1),
new OleDbParameter("@Tc", OleDbType.Boolean, 1),
new OleDbParameter("@saveCurve", OleDbType.Boolean, 1),
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = model.methodName;
parameters[1].Value = model.FTmax;
parameters[2].Value = model.T;
parameters[3].Value = model.C1;
parameters[4].Value = model.C1R_;
parameters[5].Value = model.C1cR;
parameters[6].Value = model.C1L_;
parameters[7].Value = model.C1cL;
parameters[8].Value = model.C1H_;
parameters[9].Value = model.C1cH;
parameters[10].Value = model.T_;
parameters[11].Value = model.ST;
parameters[12].Value = model.Tc;
parameters[13].Value = model.saveCurve;
parameters[14].Value = model.ID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KPS.Model.BuHeGePinJiLuInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update PSI_BuHeGePinJiLu set ");
strSql.Append("y_date=@y_date,");
strSql.Append("y_pm=@y_pm,");
strSql.Append("y_ggxh=@y_ggxh,");
strSql.Append("y_dw=@y_dw,");
strSql.Append("y_sl=@y_sl,");
strSql.Append("y_sccj=@y_sccj,");
strSql.Append("y_cpdm=@y_cpdm,");
strSql.Append("y_ghdw=@y_ghdw,");
strSql.Append("y_cpzczh=@y_cpzczh,");
strSql.Append("y_scph=@y_scph,");
strSql.Append("y_mjph=@y_mjph,");
strSql.Append("y_yxq=@y_yxq,");
strSql.Append("y_isHGZ=@y_isHGZ,");
strSql.Append("y_zlqk=@y_zlqk,");
strSql.Append("y_zgy=@y_zgy,");
strSql.Append("y_fhrqz=@y_fhrqz,");
strSql.Append("DataType=@DataType");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@y_date", OleDbType.Date),
new OleDbParameter("@y_pm", OleDbType.VarChar, 255),
new OleDbParameter("@y_ggxh", OleDbType.VarChar, 255),
new OleDbParameter("@y_dw", OleDbType.VarChar, 255),
new OleDbParameter("@y_sl", OleDbType.Integer, 4),
new OleDbParameter("@y_sccj", OleDbType.VarChar, 255),
new OleDbParameter("@y_cpdm", OleDbType.VarChar, 255),
new OleDbParameter("@y_ghdw", OleDbType.VarChar, 255),
new OleDbParameter("@y_cpzczh", OleDbType.VarChar, 255),
new OleDbParameter("@y_scph", OleDbType.VarChar, 255),
new OleDbParameter("@y_mjph", OleDbType.VarChar, 255),
new OleDbParameter("@y_yxq", OleDbType.VarChar, 255),
new OleDbParameter("@y_isHGZ", OleDbType.Boolean, 1),
new OleDbParameter("@y_zlqk", OleDbType.VarChar, 255),
new OleDbParameter("@y_zgy", OleDbType.VarChar, 255),
new OleDbParameter("@y_fhrqz", OleDbType.VarChar, 255),
new OleDbParameter("@DataType", OleDbType.Integer, 4),
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = model.y_date;
parameters[1].Value = model.y_pm;
parameters[2].Value = model.y_ggxh;
parameters[3].Value = model.y_dw;
parameters[4].Value = model.y_sl;
parameters[5].Value = model.y_sccj;
parameters[6].Value = model.y_cpdm;
parameters[7].Value = model.y_ghdw;
parameters[8].Value = model.y_cpzczh;
parameters[9].Value = model.y_scph;
parameters[10].Value = model.y_mjph;
parameters[11].Value = model.y_yxq;
parameters[12].Value = model.y_isHGZ;
parameters[13].Value = model.y_zlqk;
parameters[14].Value = model.y_zgy;
parameters[15].Value = model.y_fhrqz;
parameters[16].Value = model.DataType;
parameters[17].Value = model.ID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ForKids.DB.Model.TEACHERBASE GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,JOBNUMBER,NAME,AGE,SEX,PHOTO,PHONE,EXPHONE,DESCRIPTION from TEACHERBASE ");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = ID;
ForKids.DB.Model.TEACHERBASE model = new ForKids.DB.Model.TEACHERBASE();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["JOBNUMBER"] != null && ds.Tables[0].Rows[0]["JOBNUMBER"].ToString() != "")
{
model.JOBNUMBER = ds.Tables[0].Rows[0]["JOBNUMBER"].ToString();
}
if (ds.Tables[0].Rows[0]["NAME"] != null && ds.Tables[0].Rows[0]["NAME"].ToString() != "")
{
model.NAME = ds.Tables[0].Rows[0]["NAME"].ToString();
}
if (ds.Tables[0].Rows[0]["AGE"] != null && ds.Tables[0].Rows[0]["AGE"].ToString() != "")
{
model.AGE = int.Parse(ds.Tables[0].Rows[0]["AGE"].ToString());
}
if (ds.Tables[0].Rows[0]["SEX"] != null && ds.Tables[0].Rows[0]["SEX"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["SEX"].ToString() == "1") || (ds.Tables[0].Rows[0]["SEX"].ToString().ToLower() == "true"))
{
model.SEX = true;
}
else
{
model.SEX = false;
}
}
if (ds.Tables[0].Rows[0]["PHOTO"] != null && ds.Tables[0].Rows[0]["PHOTO"].ToString() != "")
{
model.PHOTO = (byte[])ds.Tables[0].Rows[0]["PHOTO"];
}
if (ds.Tables[0].Rows[0]["PHONE"] != null && ds.Tables[0].Rows[0]["PHONE"].ToString() != "")
{
model.PHONE = ds.Tables[0].Rows[0]["PHONE"].ToString();
}
if (ds.Tables[0].Rows[0]["EXPHONE"] != null && ds.Tables[0].Rows[0]["EXPHONE"].ToString() != "")
{
model.EXPHONE = ds.Tables[0].Rows[0]["EXPHONE"].ToString();
}
if (ds.Tables[0].Rows[0]["DESCRIPTION"] != null && ds.Tables[0].Rows[0]["DESCRIPTION"].ToString() != "")
{
model.DESCRIPTION = ds.Tables[0].Rows[0]["DESCRIPTION"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperOleDb.GetMaxID("ID", "TEACHERBASE"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperOleDb.GetMaxID("ID", "dbo_Cycms"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperOleDb.GetMaxID("ID", "dbo_Speciality"));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(cycms.Model.Cycms model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dbo_Cycms set ");
strSql.Append("dbo_IsRunning=@dbo_IsRunning,");
strSql.Append("dbo_IsStatic=@dbo_IsStatic,");
strSql.Append("dbo_WebAddress=@dbo_WebAddress,");
strSql.Append("dbo_WebName=@dbo_WebName,");
strSql.Append("dbo_StaticListPages=@dbo_StaticListPages,");
strSql.Append("dbo_VisitedTimes=@dbo_VisitedTimes,");
strSql.Append("dbo_SmtpServer=@dbo_SmtpServer,");
strSql.Append("dbo_MailAddress=@dbo_MailAddress,");
strSql.Append("dbo_MailName=@dbo_MailName,");
strSql.Append("dbo_MailPwd=@dbo_MailPwd,");
strSql.Append("dbo_WorkPlace=@dbo_WorkPlace,");
strSql.Append("dbo_LianXiRen=@dbo_LianXiRen,");
strSql.Append("dbo_CellPhone=@dbo_CellPhone,");
strSql.Append("dbo_Flax=@dbo_Flax,");
strSql.Append("dbo_WorkPohne=@dbo_WorkPohne,");
strSql.Append("dbo_BeiAnHao=@dbo_BeiAnHao");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@dbo_IsRunning", OleDbType.Boolean, 1),
new OleDbParameter("@dbo_IsStatic", OleDbType.Boolean, 1),
new OleDbParameter("@dbo_WebAddress", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_WebName", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_StaticListPages", OleDbType.Integer, 4),
new OleDbParameter("@dbo_VisitedTimes", OleDbType.Integer, 4),
new OleDbParameter("@dbo_SmtpServer", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_MailAddress", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_MailName", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_MailPwd", OleDbType.VarChar, 200),
new OleDbParameter("@dbo_WorkPlace", OleDbType.VarChar, 255),
new OleDbParameter("@dbo_LianXiRen", OleDbType.VarChar, 10),
new OleDbParameter("@dbo_CellPhone", OleDbType.VarChar, 50),
new OleDbParameter("@dbo_Flax", OleDbType.VarChar, 50),
new OleDbParameter("@dbo_WorkPohne", OleDbType.VarChar, 50),
new OleDbParameter("@dbo_BeiAnHao", OleDbType.VarChar, 100),
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = model.dbo_IsRunning;
parameters[1].Value = model.dbo_IsStatic;
parameters[2].Value = model.dbo_WebAddress;
parameters[3].Value = model.dbo_WebName;
parameters[4].Value = model.dbo_StaticListPages;
parameters[5].Value = model.dbo_VisitedTimes;
parameters[6].Value = model.dbo_SmtpServer;
parameters[7].Value = model.dbo_MailAddress;
parameters[8].Value = model.dbo_MailName;
parameters[9].Value = model.dbo_MailPwd;
parameters[10].Value = model.dbo_WorkPlace;
parameters[11].Value = model.dbo_LianXiRen;
parameters[12].Value = model.dbo_CellPhone;
parameters[13].Value = model.dbo_Flax;
parameters[14].Value = model.dbo_WorkPohne;
parameters[15].Value = model.dbo_BeiAnHao;
parameters[16].Value = model.ID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperOleDb.GetMaxID("ID", "tb_GBT236152009_SelHeng"));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.link GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,title,user_name,user_tel,email,site_url,img_url,is_image,sort_id,is_red,is_lock,add_time from " + databaseprefix + "link ");
strSql.Append(" where id=@id");
OleDbParameter[] parameters =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters[0].Value = id;
Model.link model = new Model.link();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "")
{
model.title = ds.Tables[0].Rows[0]["title"].ToString();
}
if (ds.Tables[0].Rows[0]["user_name"] != null && ds.Tables[0].Rows[0]["user_name"].ToString() != "")
{
model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString();
}
if (ds.Tables[0].Rows[0]["user_tel"] != null && ds.Tables[0].Rows[0]["user_tel"].ToString() != "")
{
model.user_tel = ds.Tables[0].Rows[0]["user_tel"].ToString();
}
if (ds.Tables[0].Rows[0]["email"] != null && ds.Tables[0].Rows[0]["email"].ToString() != "")
{
model.email = ds.Tables[0].Rows[0]["email"].ToString();
}
if (ds.Tables[0].Rows[0]["site_url"] != null && ds.Tables[0].Rows[0]["site_url"].ToString() != "")
{
model.site_url = ds.Tables[0].Rows[0]["site_url"].ToString();
}
if (ds.Tables[0].Rows[0]["img_url"] != null && ds.Tables[0].Rows[0]["img_url"].ToString() != "")
{
model.img_url = ds.Tables[0].Rows[0]["img_url"].ToString();
}
if (ds.Tables[0].Rows[0]["is_image"] != null && ds.Tables[0].Rows[0]["is_image"].ToString() != "")
{
model.is_image = int.Parse(ds.Tables[0].Rows[0]["is_image"].ToString());
}
if (ds.Tables[0].Rows[0]["sort_id"] != null && ds.Tables[0].Rows[0]["sort_id"].ToString() != "")
{
model.sort_id = int.Parse(ds.Tables[0].Rows[0]["sort_id"].ToString());
}
if (ds.Tables[0].Rows[0]["is_red"] != null && ds.Tables[0].Rows[0]["is_red"].ToString() != "")
{
model.is_red = int.Parse(ds.Tables[0].Rows[0]["is_red"].ToString());
}
if (ds.Tables[0].Rows[0]["is_lock"] != null && ds.Tables[0].Rows[0]["is_lock"].ToString() != "")
{
model.is_lock = int.Parse(ds.Tables[0].Rows[0]["is_lock"].ToString());
}
if (ds.Tables[0].Rows[0]["add_time"] != null && ds.Tables[0].Rows[0]["add_time"].ToString() != "")
{
model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.article_attribute_field model)
{
int newId;
using (OleDbConnection conn = new OleDbConnection(DbHelperOleDb.connectionString))
{
conn.Open();
using (OleDbTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into " + databaseprefix + "article_attribute_field(");
strSql.Append("[name],title,control_type,data_type,data_length,data_place,item_option,default_value,is_required,is_password,is_html,editor_type,valid_tip_msg,valid_error_msg,valid_pattern,sort_id,is_sys)");
strSql.Append(" values (");
strSql.Append("@name,@title,@control_type,@data_type,@data_length,@data_place,@item_option,@default_value,@is_required,@is_password,@is_html,@editor_type,@valid_tip_msg,@valid_error_msg,@valid_pattern,@sort_id,@is_sys)");
OleDbParameter[] parameters =
{
new OleDbParameter("@name", OleDbType.VarChar, 100),
new OleDbParameter("@title", OleDbType.VarChar, 100),
new OleDbParameter("@control_type", OleDbType.VarChar, 50),
new OleDbParameter("@data_type", OleDbType.VarChar, 50),
new OleDbParameter("@data_length", OleDbType.Integer, 4),
new OleDbParameter("@data_place", OleDbType.Integer, 4),
new OleDbParameter("@item_option", OleDbType.VarChar),
new OleDbParameter("@default_value", OleDbType.VarChar),
new OleDbParameter("@is_required", OleDbType.Integer, 4),
new OleDbParameter("@is_password", OleDbType.Integer, 4),
new OleDbParameter("@is_html", OleDbType.Integer, 4),
new OleDbParameter("@editor_type", OleDbType.Integer, 4),
new OleDbParameter("@valid_tip_msg", OleDbType.VarChar, 255),
new OleDbParameter("@valid_error_msg", OleDbType.VarChar, 255),
new OleDbParameter("@valid_pattern", OleDbType.VarChar, 500),
new OleDbParameter("@sort_id", OleDbType.Integer, 4),
new OleDbParameter("@is_sys", OleDbType.Integer, 4)
};
parameters[0].Value = model.name;
parameters[1].Value = model.title;
parameters[2].Value = model.control_type;
parameters[3].Value = model.data_type;
parameters[4].Value = model.data_length;
parameters[5].Value = model.data_place;
parameters[6].Value = model.item_option;
parameters[7].Value = model.default_value;
parameters[8].Value = model.is_required;
parameters[9].Value = model.is_password;
parameters[10].Value = model.is_html;
parameters[11].Value = model.editor_type;
parameters[12].Value = model.valid_tip_msg;
parameters[13].Value = model.valid_error_msg;
parameters[14].Value = model.valid_pattern;
parameters[15].Value = model.sort_id;
parameters[16].Value = model.is_sys;
DbHelperOleDb.ExecuteSql(conn, trans, strSql.ToString(), parameters);
//取得新插入的ID
newId = GetMaxId(conn, trans);
//增加扩展字段表中一列
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("alter table " + databaseprefix + "article_attribute_value add " + model.name + " " + model.data_type);
OleDbParameter[] parameters2 = { };
DbHelperOleDb.ExecuteSql(conn, trans, strSql2.ToString(), parameters2);
trans.Commit();
}
catch
{
trans.Rollback();
return(-1);
}
}
}
return(newId);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(ERM.MDL.T_FileList model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.cjdag != null)
{
strSql1.Append("cjdag,");
strSql2.Append("'" + model.cjdag + "',");
}
if (model.datawindow_id != null)
{
strSql1.Append("datawindow_id,");
strSql2.Append("'" + model.datawindow_id + "',");
}
if (model.extension1 != null)
{
strSql1.Append("extension1,");
strSql2.Append("'" + model.extension1 + "',");
}
if (model.extension2 != null)
{
strSql1.Append("extension2,");
strSql2.Append("'" + model.extension2 + "',");
}
if (model.extension3 != null)
{
strSql1.Append("extension3,");
strSql2.Append("'" + model.extension3 + "',");
}
if (model.gclx != null)
{
strSql1.Append("gclx,");
strSql2.Append("'" + model.gclx + "',");
}
if (model.gdwj != null)
{
strSql1.Append("gdwj,");
strSql2.Append("'" + model.gdwj + "',");
}
if (model.id != null)
{
strSql1.Append("id,");
strSql2.Append("'" + model.id + "',");
}
if (model.isvisible != null)
{
strSql1.Append("isvisible,");
strSql2.Append("" + model.isvisible + ",");
}
if (model.jldw != null)
{
strSql1.Append("jldw,");
strSql2.Append("'" + model.jldw + "',");
}
if (model.jsdw != null)
{
strSql1.Append("jsdw,");
strSql2.Append("'" + model.jsdw + "',");
}
if (model.OrderIndex != null)
{
strSql1.Append("OrderIndex,");
strSql2.Append("" + model.OrderIndex + ",");
}
if (model.ProjectNO != null)
{
strSql1.Append("ProjectNO,");
strSql2.Append("'" + model.ProjectNO + "',");
}
if (model.pTreePath != null)
{
strSql1.Append("pTreePath,");
strSql2.Append("'" + model.pTreePath + "',");
}
if (model.selected != null)
{
strSql1.Append("selected,");
strSql2.Append("" + model.selected + ",");
}
if (model.sgdw != null)
{
strSql1.Append("sgdw,");
strSql2.Append("'" + model.sgdw + "',");
}
if (model.sjdw != null)
{
strSql1.Append("sjdw,");
strSql2.Append("'" + model.sjdw + "',");
}
if (model.table_name != null)
{
strSql1.Append("table_name,");
strSql2.Append("'" + model.table_name + "',");
}
if (model.table_standerd != null)
{
strSql1.Append("table_standerd,");
strSql2.Append("'" + model.table_standerd + "',");
}
if (model.TreePath != null)
{
strSql1.Append("TreePath,");
strSql2.Append("'" + model.TreePath + "',");
}
if (model.wjmj != null)
{
strSql1.Append("wjmj,");
strSql2.Append("'" + model.wjmj + "',");
}
if (model.zrr != null)
{
strSql1.Append("zrr,");
strSql2.Append("'" + model.zrr + "',");
}
strSql.Append("insert into FileRecording_Templet(");
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());
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperOleDb.GetMaxID("ID", "dbo_TeacherUpload"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperOleDb.GetMaxID("ID", "BloodGas"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperOleDb.GetMaxID("ID", "tb_GBT282892012_ShearSel"));
}
/// <summary>
/// 直接充值订单
/// </summary>
public bool Recharge(Model.user_recharge model)
{
using (OleDbConnection conn = new OleDbConnection(DbHelperOleDb.connectionString))
{
conn.Open();
using (OleDbTransaction trans = conn.BeginTransaction())
{
try
{
//增加一条账户余额记录
StringBuilder strSql3 = new StringBuilder();
strSql3.Append("insert into " + databaseprefix + "user_amount_log(");
strSql3.Append("user_id,user_name,[value],[remark],add_time)");
strSql3.Append(" values (");
strSql3.Append("@user_id,@user_name,@value,@remark,@add_time)");
OleDbParameter[] parameters3 =
{
new OleDbParameter("@user_id", OleDbType.Integer, 4),
new OleDbParameter("@user_name", OleDbType.VarChar, 100),
new OleDbParameter("@value", OleDbType.Decimal, 5),
new OleDbParameter("@remark", OleDbType.VarChar, 500),
new OleDbParameter("@add_time", OleDbType.Date)
};
parameters3[0].Value = model.user_id;
parameters3[1].Value = model.user_name;
parameters3[2].Value = model.amount;
parameters3[3].Value = "在线充值，单号：" + model.recharge_no;
parameters3[4].Value = DateTime.Now;
DbHelperOleDb.ExecuteSql(conn, trans, strSql3.ToString(), parameters3);
//修改用户表金额
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("update " + databaseprefix + "users set amount=amount+" + model.amount);
strSql2.Append(" where id=@id");
OleDbParameter[] parameters2 =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters2[0].Value = model.user_id;
DbHelperOleDb.ExecuteSql(conn, trans, strSql2.ToString(), parameters2);
//添加充值表
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into " + databaseprefix + "user_recharge(");
strSql.Append("user_id,user_name,recharge_no,payment_id,amount,status,add_time,complete_time)");
strSql.Append(" values (");
strSql.Append("@user_id,@user_name,@recharge_no,@payment_id,@amount,@status,@add_time,@complete_time)");
OleDbParameter[] parameters =
{
new OleDbParameter("@user_id", OleDbType.Integer, 4),
new OleDbParameter("@user_name", OleDbType.VarChar, 100),
new OleDbParameter("@recharge_no", OleDbType.VarChar, 100),
new OleDbParameter("@payment_id", OleDbType.Integer, 4),
new OleDbParameter("@amount", OleDbType.Decimal, 5),
new OleDbParameter("@status", OleDbType.Integer, 4),
new OleDbParameter("@add_time", OleDbType.Date),
new OleDbParameter("@complete_time", OleDbType.Date)
};
parameters[0].Value = model.user_id;
parameters[1].Value = model.user_name;
parameters[2].Value = model.recharge_no;
parameters[3].Value = model.payment_id;
parameters[4].Value = model.amount;
parameters[5].Value = model.status;
parameters[6].Value = model.add_time;
if (model.complete_time != null)
{
parameters[7].Value = model.complete_time;
}
else
{
parameters[7].Value = DBNull.Value;
}
DbHelperOleDb.ExecuteSql(conn, trans, strSql.ToString(), parameters);
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperOleDb.GetMaxID("ID", "PSI_BuHeGePinJiLu"));
}
/// <summary>
/// 确认充值订单
/// </summary>
public bool Confirm(string recharge_no)
{
Model.user_recharge model = GetModel(recharge_no); //根据充值单号得到实体
if (model == null)
{
return(false);
}
using (OleDbConnection conn = new OleDbConnection(DbHelperOleDb.connectionString))
{
conn.Open();
using (OleDbTransaction trans = conn.BeginTransaction())
{
try
{
//增加一条账户余额记录
StringBuilder strSql3 = new StringBuilder();
strSql3.Append("insert into " + databaseprefix + "user_amount_log(");
strSql3.Append("user_id,user_name,[value],[remark],add_time)");
strSql3.Append(" values (");
strSql3.Append("@user_id,@user_name,@value,@remark,@add_time)");
OleDbParameter[] parameters3 =
{
new OleDbParameter("@user_id", OleDbType.Integer, 4),
new OleDbParameter("@user_name", OleDbType.VarChar, 100),
new OleDbParameter("@value", OleDbType.Decimal, 5),
new OleDbParameter("@remark", OleDbType.VarChar, 500),
new OleDbParameter("@add_time", OleDbType.Date)
};
parameters3[0].Value = model.user_id;
parameters3[1].Value = model.user_name;
parameters3[2].Value = model.amount;
parameters3[3].Value = "在线充值，单号：" + recharge_no;
parameters3[4].Value = DateTime.Now;
DbHelperOleDb.ExecuteSql(conn, trans, strSql3.ToString(), parameters3);
//修改用户表金额
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("update " + databaseprefix + "users set amount=amount+" + model.amount);
strSql2.Append(" where id=@id");
OleDbParameter[] parameters2 =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters2[0].Value = model.user_id;
DbHelperOleDb.ExecuteSql(conn, trans, strSql2.ToString(), parameters2);
//更新充值表
StringBuilder strSql = new StringBuilder();
strSql.Append("update " + databaseprefix + "user_recharge set ");
strSql.Append("status=@status,");
strSql.Append("complete_time=@complete_time");
strSql.Append(" where recharge_no=@recharge_no");
OleDbParameter[] parameters =
{
new OleDbParameter("@status", OleDbType.Integer, 4),
new OleDbParameter("@complete_time", OleDbType.Date),
new OleDbParameter("@recharge_no", OleDbType.VarChar, 100)
};
parameters[0].Value = 1;
parameters[1].Value = DateTime.Now;
parameters[2].Value = recharge_no;
DbHelperOleDb.ExecuteSql(conn, trans, strSql.ToString(), parameters);
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}
/// <summary>
/// 绑定数据源
/// </summary>
/// <param name="dt">数据结果</param>
/// <param name="userNamek">人员名称</param>
/// <param name="timeLimit">时间范围</param>
public bool RegisterData(DataTable dt, string userNamek, string dateLimit)
{
try
{
#region 获取人员信息
string sql = "Select * from Personnel where enable='1' and name='" + DESJiaMi.Encrypt(userNamek) + "';";
DataTable userUpdate = DbHelperOleDb.Query(sql, new Dictionary <string, object>()).Tables[0];
if (userUpdate != null && userUpdate.Rows.Count > 0)
{
//姓名
string workerName = userUpdate.Rows[0]["name"].ToString();
if (!string.IsNullOrEmpty(workerName))
{
workerName = DESJiaMi.Decrypt(workerName);
report.SetParameterValue("workername", workerName);
}
else
{
report.SetParameterValue("workername", "");
}
//性别
string xingbie = userUpdate.Rows[0]["gender"].ToString();
if (!string.IsNullOrEmpty(xingbie))
{
xingbie = DESJiaMi.Decrypt(xingbie);
report.SetParameterValue("gender", xingbie);
}
else
{
report.SetParameterValue("gender", "");
}
//联系电话
string lxdh = userUpdate.Rows[0]["lxdh"].ToString();
if (!string.IsNullOrEmpty(lxdh))
{
lxdh = DESJiaMi.Decrypt(lxdh);
report.SetParameterValue("lxdh", lxdh);
}
else
{
report.SetParameterValue("lxdh", "");
}
//主要工作
string mainwork = userUpdate.Rows[0]["mainwork"].ToString();
if (!string.IsNullOrEmpty(mainwork))
{
report.SetParameterValue("mainwork", mainwork);
}
else
{
report.SetParameterValue("mainwork", "");
}
//统计时间
report.SetParameterValue("dateLimit", dateLimit);
TableObject TableOfDay = report.FindObject("TableOfDay") as TableObject; //每日统计表格
TableObject TableOfMonth = report.FindObject("TableOfMonth") as TableObject; //每月统计表格
TableObject TableOfYear = report.FindObject("TableOfYear") as TableObject; //每年统计表格
List <DataRow> drsDay = new List <DataRow>(); //每一天
List <DataRow> drsMonth = new List <DataRow>(); //每一月
List <DataRow> drsYear = new List <DataRow>(); //每一年
for (int i = 0; i < dt.Rows.Count; i++)
{
string workdate = dt.Rows[i]["workdate"].ToString();
#region 天
if (drsDay.Count != 0)
{
if (drsDay[0]["workdate"].ToString() == workdate)
{
drsDay.Add(dt.Rows[i]);
}
else
{
TableAddRows(TableOfDay, drsDay.Count);
SetValueInReportOfDayInfo(TableOfDay, drsDay, i + 1 - drsDay.Count);
drsDay = new List <DataRow>();
drsDay.Add(dt.Rows[i]);
}
}
else
{
drsDay.Add(dt.Rows[i]);
}
#endregion
#region 月份
if (drsMonth.Count != 0)
{
if (drsMonth[0]["workdate"].ToString().Substring(0, 7) == workdate.Substring(0, 7))
{
drsMonth.Add(dt.Rows[i]);
}
else
{
TableAddRows(TableOfMonth, 1);
SetValueInReportOfMonthYearInfo(TableOfMonth, drsMonth, "Month");
drsMonth = new List <DataRow>();
drsMonth.Add(dt.Rows[i]);
}
}
else
{
drsMonth.Add(dt.Rows[i]);
}
#endregion
#region 年份
if (drsYear.Count != 0)
{
if (drsYear[0]["workdate"].ToString().Substring(0, 4) == workdate.Substring(0, 4))
{
drsYear.Add(dt.Rows[i]);
}
else
{
TableAddRows(TableOfYear, 1);
SetValueInReportOfMonthYearInfo(TableOfYear, drsYear, "Year");
drsYear = new List <DataRow>();
drsYear.Add(dt.Rows[i]);
}
}
else
{
drsYear.Add(dt.Rows[i]);
}
#endregion
}
TableAddRows(TableOfDay, drsDay.Count);
SetValueInReportOfDayInfo(TableOfDay, drsDay, dt.Rows.Count + 1 - drsDay.Count);
TableAddRows(TableOfMonth, 1);
SetValueInReportOfMonthYearInfo(TableOfMonth, drsMonth, "Month");
TableAddRows(TableOfYear, 1);
SetValueInReportOfMonthYearInfo(TableOfYear, drsYear, "Year");
//累计时长
List <DataRow> drs = new List <DataRow>();
foreach (DataRow item in dt.Rows)
{
drs.Add(item);
}
double SumTimes = GetCumulativeTime(drs);
if (!string.IsNullOrEmpty(SumTimes.ToString()))
{
report.SetParameterValue("timesSums", SumTimes.ToString("0.000"));
}
else
{
report.SetParameterValue("timesSums", "");
}
}
else
{
return(false);
}
#endregion
DataSet FDataSet = new DataSet();
report.RegisterData(FDataSet);
return(true);
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.article_attribute_field model)
{
using (OleDbConnection conn = new OleDbConnection(DbHelperOleDb.connectionString))
{
conn.Open();
using (OleDbTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update " + databaseprefix + "article_attribute_field set ");
strSql.Append("[name]=@name,");
strSql.Append("title=@title,");
strSql.Append("control_type=@control_type,");
strSql.Append("data_type=@data_type,");
strSql.Append("data_length=@data_length,");
strSql.Append("data_place=@data_place,");
strSql.Append("item_option=@item_option,");
strSql.Append("default_value=@default_value,");
strSql.Append("is_required=@is_required,");
strSql.Append("is_password=@is_password,");
strSql.Append("is_html=@is_html,");
strSql.Append("editor_type=@editor_type,");
strSql.Append("valid_tip_msg=@valid_tip_msg,");
strSql.Append("valid_error_msg=@valid_error_msg,");
strSql.Append("valid_pattern=@valid_pattern,");
strSql.Append("sort_id=@sort_id,");
strSql.Append("is_sys=@is_sys");
strSql.Append(" where id=@id");
OleDbParameter[] parameters =
{
new OleDbParameter("@name", OleDbType.VarChar, 100),
new OleDbParameter("@title", OleDbType.VarChar, 100),
new OleDbParameter("@control_type", OleDbType.VarChar, 50),
new OleDbParameter("@data_type", OleDbType.VarChar, 50),
new OleDbParameter("@data_length", OleDbType.Integer, 4),
new OleDbParameter("@data_place", OleDbType.Integer, 4),
new OleDbParameter("@item_option", OleDbType.VarChar),
new OleDbParameter("@default_value", OleDbType.VarChar),
new OleDbParameter("@is_required", OleDbType.Integer, 4),
new OleDbParameter("@is_password", OleDbType.Integer, 4),
new OleDbParameter("@is_html", OleDbType.Integer, 4),
new OleDbParameter("@editor_type", OleDbType.Integer, 4),
new OleDbParameter("@valid_tip_msg", OleDbType.VarChar, 255),
new OleDbParameter("@valid_error_msg", OleDbType.VarChar, 255),
new OleDbParameter("@valid_pattern", OleDbType.VarChar, 500),
new OleDbParameter("@sort_id", OleDbType.Integer, 4),
new OleDbParameter("@is_sys", OleDbType.Integer, 4),
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters[0].Value = model.name;
parameters[1].Value = model.title;
parameters[2].Value = model.control_type;
parameters[3].Value = model.data_type;
parameters[4].Value = model.data_length;
parameters[5].Value = model.data_place;
parameters[6].Value = model.item_option;
parameters[7].Value = model.default_value;
parameters[8].Value = model.is_required;
parameters[9].Value = model.is_password;
parameters[10].Value = model.is_html;
parameters[11].Value = model.editor_type;
parameters[12].Value = model.valid_tip_msg;
parameters[13].Value = model.valid_error_msg;
parameters[14].Value = model.valid_pattern;
parameters[15].Value = model.sort_id;
parameters[16].Value = model.is_sys;
parameters[17].Value = model.id;
DbHelperOleDb.ExecuteSql(conn, trans, strSql.ToString(), parameters);
//修改扩展字段表中一列
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("alter table " + databaseprefix + "article_attribute_value alter column " + model.name + " " + model.data_type);
DbHelperOleDb.ExecuteSql(conn, trans, strSql2.ToString());
//没有错误确认事务
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}
/// <summary>
/// 快捷添加系统默认导航
/// </summary>
public int Add(string parent_name, string nav_name, string title, string link_url, int sort_id, int channel_id, string action_type)
{
//先根据名称查询该父ID
StringBuilder strSql1 = new StringBuilder();
strSql1.Append("select top 1 id from " + databaseprefix + "navigation");
strSql1.Append(" where name=@parent_name");
OleDbParameter[] parameters1 =
{
new OleDbParameter("@parent_name", OleDbType.VarChar, 50)
};
parameters1[0].Value = parent_name;
object obj1 = DbHelperOleDb.GetSingle(strSql1.ToString(), parameters1);
if (obj1 == null)
{
return(0);
}
int parent_id = Convert.ToInt32(obj1);
int newId;
using (OleDbConnection conn = new OleDbConnection(DbHelperOleDb.connectionString))
{
conn.Open();
using (OleDbTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into " + databaseprefix + "navigation(");
strSql.Append("parent_id,channel_id,nav_type,[name],title,link_url,sort_id,action_type,is_lock,is_sys)");
strSql.Append(" values (");
strSql.Append("@parent_id,@channel_id,@nav_type,@name,@title,@link_url,@sort_id,@action_type,@is_lock,@is_sys)");
OleDbParameter[] parameters =
{
new OleDbParameter("@parent_id", OleDbType.Integer, 4),
new OleDbParameter("@channel_id", OleDbType.Integer, 4),
new OleDbParameter("@nav_type", OleDbType.VarChar, 50),
new OleDbParameter("@name", OleDbType.VarChar, 50),
new OleDbParameter("@title", OleDbType.VarChar, 100),
new OleDbParameter("@link_url", OleDbType.VarChar, 255),
new OleDbParameter("@sort_id", OleDbType.Integer, 4),
new OleDbParameter("@action_type", OleDbType.VarChar, 500),
new OleDbParameter("@is_lock", OleDbType.Integer, 4),
new OleDbParameter("@is_sys", OleDbType.Integer, 4)
};
parameters[0].Value = parent_id;
parameters[1].Value = channel_id;
parameters[2].Value = DTEnums.NavigationEnum.System.ToString();
parameters[3].Value = nav_name;
parameters[4].Value = title;
parameters[5].Value = link_url;
parameters[6].Value = sort_id;
parameters[7].Value = action_type;
parameters[8].Value = 0;
parameters[9].Value = 1;
DbHelperOleDb.ExecuteSql(conn, trans, strSql.ToString(), parameters);
//取得新插入的ID
newId = GetMaxId(conn, trans);
trans.Commit();
}
catch
{
trans.Rollback();
return(-1);
}
}
}
return(newId);
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int id)
{
//取得Model信息
Model.article_attribute_field model = GetModel(id);
//开始删除
using (OleDbConnection conn = new OleDbConnection(DbHelperOleDb.connectionString))
{
conn.Open();
using (OleDbTransaction trans = conn.BeginTransaction())
{
try
{
//查找关联的频道ID，得到后以备使用
StringBuilder strSql1 = new StringBuilder();
strSql1.Append("select channel_id,field_id from " + databaseprefix + "channel_field ");
strSql1.Append(" where field_id=@field_id");
OleDbParameter[] parameters1 =
{
new OleDbParameter("@field_id", OleDbType.Integer, 4)
};
parameters1[0].Value = id;
DataTable dt = DbHelperOleDb.Query(conn, trans, strSql1.ToString(), parameters1).Tables[0];
//删除频道关联的字段表
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("delete from " + databaseprefix + "channel_field");
strSql2.Append(" where field_id=@field_id");
OleDbParameter[] parameters2 =
{
new OleDbParameter("@field_id", OleDbType.Integer, 4)
};
parameters2[0].Value = id;
DbHelperOleDb.ExecuteSql(conn, trans, strSql2.ToString(), parameters2);
//重建对应频道的视图
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
Model.channel modelt = new DAL.channel(databaseprefix).GetModel(conn, trans, int.Parse(dr["channel_id"].ToString()));
if (modelt != null)
{
new DAL.channel(databaseprefix).RehabChannelViews(conn, trans, modelt, modelt.name);
}
}
}
//删除主表
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from " + databaseprefix + "article_attribute_field ");
strSql.Append(" where id=@id");
OleDbParameter[] parameters =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters[0].Value = id;
DbHelperOleDb.ExecuteSql(conn, trans, strSql.ToString(), parameters);
//删除扩展字段表中一列
DbHelperOleDb.ExecuteSql(conn, trans, "alter table " + databaseprefix + "article_attribute_value drop column " + model.name);
//没有错误确认事务
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperOleDb.GetMaxID("ID", "ed_node"));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.article_attribute_field GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,[name],title,control_type,data_type,data_length,data_place,item_option,default_value,is_required,is_password,is_html,editor_type,valid_tip_msg,valid_error_msg,valid_pattern,sort_id,is_sys");
strSql.Append(" from " + databaseprefix + "article_attribute_field ");
strSql.Append(" where id=@id");
OleDbParameter[] parameters =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters[0].Value = id;
Model.article_attribute_field model = new Model.article_attribute_field();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
model.name = ds.Tables[0].Rows[0]["name"].ToString();
model.title = ds.Tables[0].Rows[0]["title"].ToString();
model.control_type = ds.Tables[0].Rows[0]["control_type"].ToString();
model.data_type = ds.Tables[0].Rows[0]["data_type"].ToString();
if (ds.Tables[0].Rows[0]["data_length"].ToString() != "")
{
model.data_length = int.Parse(ds.Tables[0].Rows[0]["data_length"].ToString());
}
if (ds.Tables[0].Rows[0]["data_place"].ToString() != "")
{
model.data_place = int.Parse(ds.Tables[0].Rows[0]["data_place"].ToString());
}
model.item_option = ds.Tables[0].Rows[0]["item_option"].ToString();
model.default_value = ds.Tables[0].Rows[0]["default_value"].ToString();
if (ds.Tables[0].Rows[0]["is_required"].ToString() != "")
{
model.is_required = int.Parse(ds.Tables[0].Rows[0]["is_required"].ToString());
}
if (ds.Tables[0].Rows[0]["is_password"].ToString() != "")
{
model.is_password = int.Parse(ds.Tables[0].Rows[0]["is_password"].ToString());
}
if (ds.Tables[0].Rows[0]["is_html"].ToString() != "")
{
model.is_html = int.Parse(ds.Tables[0].Rows[0]["is_html"].ToString());
}
if (ds.Tables[0].Rows[0]["editor_type"].ToString() != "")
{
model.editor_type = int.Parse(ds.Tables[0].Rows[0]["editor_type"].ToString());
}
model.valid_tip_msg = ds.Tables[0].Rows[0]["valid_tip_msg"].ToString();
model.valid_error_msg = ds.Tables[0].Rows[0]["valid_error_msg"].ToString();
model.valid_pattern = ds.Tables[0].Rows[0]["valid_pattern"].ToString();
if (ds.Tables[0].Rows[0]["sort_id"].ToString() != "")
{
model.sort_id = int.Parse(ds.Tables[0].Rows[0]["sort_id"].ToString());
}
if (ds.Tables[0].Rows[0]["is_sys"].ToString() != "")
{
model.is_sys = int.Parse(ds.Tables[0].Rows[0]["is_sys"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperOleDb.GetMaxID("ID", "dbo_Article"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperOleDb.GetMaxID("ID", "tb_GBT282892012_Tensile"));
}
