/// <summary>
/// 增加一条数据
/// </summary>
public long Add(Tgxx.Application.Model.Class model, string parentClassList)
{
int result = 0;
using (SqlConnection con = new SqlConnection(DbHelperSQL.connectionString))
{
con.Open();
using (SqlTransaction sqt = con.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Class(");
strSql.Append("title,rigestLevelID,singleTitle,code,parentID,classList,classLayer,sortID,linkUrl,linkType,imgUrl,details,isLock,remark,bakOne,bakTwo,bakThree,year,insertTime,updateTime)");
strSql.Append(" values (");
strSql.Append("@title,@rigestLevelID,@singleTitle,@code,@parentID,@classList,@classLayer,@sortID,@linkUrl,@linkType,@imgUrl,@details,@isLock,@remark,@bakOne,@bakTwo,@bakThree,@year,@insertTime,@updateTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@title", SqlDbType.NVarChar,100),
new SqlParameter("@rigestLevelID", SqlDbType.BigInt,8),
new SqlParameter("@singleTitle", SqlDbType.NVarChar,100),
new SqlParameter("@code", SqlDbType.NVarChar,50),
new SqlParameter("@parentID", SqlDbType.BigInt,8),
new SqlParameter("@classList", SqlDbType.NVarChar,500),
new SqlParameter("@classLayer", SqlDbType.Int,4),
new SqlParameter("@sortID", SqlDbType.Int,4),
new SqlParameter("@linkUrl", SqlDbType.NVarChar,255),
new SqlParameter("@linkType", SqlDbType.NVarChar,50),
new SqlParameter("@imgUrl", SqlDbType.NVarChar,255),
new SqlParameter("@details", SqlDbType.NText),
new SqlParameter("@isLock", SqlDbType.Int,4),
new SqlParameter("@remark", SqlDbType.NVarChar,150),
new SqlParameter("@bakOne", SqlDbType.NVarChar,50),
new SqlParameter("@bakTwo", SqlDbType.NVarChar,50),
new SqlParameter("@bakThree", SqlDbType.NVarChar,50),
new SqlParameter("@year", SqlDbType.NVarChar,50),
new SqlParameter("@insertTime", SqlDbType.NVarChar,50),
new SqlParameter("@updateTime", SqlDbType.NVarChar,50)};
parameters[0].Value = model.title;
parameters[1].Value = model.rigestLevelID;
parameters[2].Value = model.singleTitle;
parameters[3].Value = model.code;
parameters[4].Value = model.parentID;
parameters[5].Value = model.classList;
parameters[6].Value = model.classLayer;
parameters[7].Value = model.sortID;
parameters[8].Value = model.linkUrl;
parameters[9].Value = model.linkType;
parameters[10].Value = model.imgUrl;
parameters[11].Value = model.details;
parameters[12].Value = model.isLock;
parameters[13].Value = model.remark;
parameters[14].Value = model.bakOne;
parameters[15].Value = model.bakTwo;
parameters[16].Value = model.bakThree;
parameters[17].Value = model.year;
parameters[18].Value = model.insertTime;
parameters[19].Value = model.updateTime;
object obj = DbHelperSQL.GetSingle(con, sqt, strSql.ToString(), parameters);
if (obj == null)
{
throw new Exception("faild");
}
StringBuilder strSqlUpdate = new StringBuilder();
strSqlUpdate.Append("update Class set classList = @classList where ID =@ID");
SqlParameter[] sp = {
new SqlParameter("@classList", SqlDbType.NVarChar, 50),
new SqlParameter("@ID", SqlDbType.Int, 5)
};
sp[0].Value = parentClassList + obj + ",";
sp[1].Value = Convert.ToInt32(obj);
int res = DbHelperSQL.ExecuteSql(con, sqt, strSqlUpdate.ToString(), sp);
if (res < 1)
{
throw new Exception("faild");
}
result = 1;
sqt.Commit();
}
catch
{
result = 0;
sqt.Rollback();
}
}
con.Close();
}
return result;
}