/// <summary>
/// 增加一条数据
/// </summary>
public int Add(KSOA.Model.Bank_CommercialOpus model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Bank_CommercialOpus(");
strSql.Append("OpusID,CompanyName,CpAddress,ChannelAddres,AddTime,IsDelete)");
strSql.Append(" values (");
strSql.Append("@OpusID,@CompanyName,@CpAddress,@ChannelAddres,@AddTime,@IsDelete)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@OpusID", SqlDbType.Int,4),
new SqlParameter("@CompanyName", SqlDbType.NVarChar,100),
new SqlParameter("@CpAddress", SqlDbType.NVarChar,100),
new SqlParameter("@ChannelAddres", SqlDbType.NVarChar,100),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@IsDelete", SqlDbType.Bit,1)};
parameters[0].Value = model.OpusID;
parameters[1].Value = model.CompanyName;
parameters[2].Value = model.CpAddress;
parameters[3].Value = model.ChannelAddres;
parameters[4].Value = model.AddTime;
parameters[5].Value = model.IsDelete;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(KSOA.Model.Admin_Platform model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Admin_Platform(");
strSql.Append("PType,PName,IsDelete,AddTime)");
strSql.Append(" values (");
strSql.Append("@PType,@PName,@IsDelete,@AddTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@PType", SqlDbType.NVarChar,50),
new SqlParameter("@PName", SqlDbType.NVarChar,50),
new SqlParameter("@IsDelete", SqlDbType.Bit,1),
new SqlParameter("@AddTime", SqlDbType.DateTime)};
parameters[0].Value = model.PType;
parameters[1].Value = model.PName;
parameters[2].Value = model.IsDelete;
parameters[3].Value = model.AddTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(KSOA.Model.Admin_OperatLog model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Admin_OperatLog(");
strSql.Append("OperatorID,OperatorName,Module,OperationContent,OpIp,AddTime)");
strSql.Append(" values (");
strSql.Append("@OperatorID,@OperatorName,@Module,@OperationContent,@OpIp,@AddTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@OperatorID", SqlDbType.Int,4),
new SqlParameter("@OperatorName", SqlDbType.NVarChar,50),
new SqlParameter("@Module", SqlDbType.NVarChar,50),
new SqlParameter("@OperationContent", SqlDbType.NVarChar,-1),
new SqlParameter("@OpIp", SqlDbType.VarChar,50),
new SqlParameter("@AddTime", SqlDbType.DateTime)};
parameters[0].Value = model.OperatorID;
parameters[1].Value = model.OperatorName;
parameters[2].Value = model.Module;
parameters[3].Value = model.OperationContent;
parameters[4].Value = model.OpIp;
parameters[5].Value = model.AddTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(KSOA.Model.Bank_Opus model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Bank_Opus(");
strSql.Append("OpType,OpTitle,OpAuthor,OpBeginTime,AddTime,IsDelete)");
strSql.Append(" values (");
strSql.Append("@OpType,@OpTitle,@OpAuthor,@OpBeginTime,@AddTime,@IsDelete)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@OpType", SqlDbType.Char,1),
new SqlParameter("@OpTitle", SqlDbType.NVarChar,50),
new SqlParameter("@OpAuthor", SqlDbType.NVarChar,50),
new SqlParameter("@OpBeginTime", SqlDbType.DateTime),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@IsDelete", SqlDbType.Bit,1)};
parameters[0].Value = model.OpType;
parameters[1].Value = model.OpTitle;
parameters[2].Value = model.OpAuthor;
parameters[3].Value = model.OpBeginTime;
parameters[4].Value = model.AddTime;
parameters[5].Value = model.IsDelete;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(KSOA.Model.Admin_SysErrorLog model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Admin_SysErrorLog(");
strSql.Append("PageUrl,ErrorMsg,AddTime)");
strSql.Append(" values (");
strSql.Append("@PageUrl,@ErrorMsg,@AddTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@PageUrl", SqlDbType.NVarChar,200),
new SqlParameter("@ErrorMsg", SqlDbType.NVarChar,-1),
new SqlParameter("@AddTime", SqlDbType.DateTime)};
parameters[0].Value = model.PageUrl;
parameters[1].Value = model.ErrorMsg;
parameters[2].Value = model.AddTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(KSOA.Model.Bank_OriginalGroup model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Bank_OriginalGroup(");
strSql.Append("OpusCopyright,CreationInfo,OpusName,OpusAuthor,SalePrice,AccreditPlatform,AccreditCompany,AccreditTime,AccreditType,Awards,OpusMascot,AddTime,IsDelete)");
strSql.Append(" values (");
strSql.Append("@OpusCopyright,@CreationInfo,@OpusName,@OpusAuthor,@SalePrice,@AccreditPlatform,@AccreditCompany,@AccreditTime,@AccreditType,@Awards,@OpusMascot,@AddTime,@IsDelete)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@OpusCopyright", SqlDbType.NVarChar,300),
new SqlParameter("@CreationInfo", SqlDbType.NVarChar,50),
new SqlParameter("@OpusName", SqlDbType.NVarChar,300),
new SqlParameter("@OpusAuthor", SqlDbType.NVarChar,50),
new SqlParameter("@SalePrice", SqlDbType.Decimal,9),
new SqlParameter("@AccreditPlatform", SqlDbType.NVarChar,50),
new SqlParameter("@AccreditCompany", SqlDbType.NVarChar,50),
new SqlParameter("@AccreditTime", SqlDbType.DateTime),
new SqlParameter("@AccreditType", SqlDbType.NVarChar,50),
new SqlParameter("@Awards", SqlDbType.NVarChar,-1),
new SqlParameter("@OpusMascot", SqlDbType.NVarChar,50),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@IsDelete", SqlDbType.Bit,1)};
parameters[0].Value = model.OpusCopyright;
parameters[1].Value = model.CreationInfo;
parameters[2].Value = model.OpusName;
parameters[3].Value = model.OpusAuthor;
parameters[4].Value = model.SalePrice;
parameters[5].Value = model.AccreditPlatform;
parameters[6].Value = model.AccreditCompany;
parameters[7].Value = model.AccreditTime;
parameters[8].Value = model.AccreditType;
parameters[9].Value = model.Awards;
parameters[10].Value = model.OpusMascot;
parameters[11].Value = model.AddTime;
parameters[12].Value = model.IsDelete;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(KSOA.Model.UI_ExcelImportByPlatform model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into UI_ExcelImportByPlatform(");
strSql.Append("CustomerID,ExType,ExTime,ExCpName,ExOpusName,ExCooperation,ExCollectNum,ExSingleCollectNum,ExOpusUnitPrice,ExAccountPrice,AddTime,IsDelete)");
strSql.Append(" values (");
strSql.Append("@CustomerID,@ExType,@ExTime,@ExCpName,@ExOpusName,@ExCooperation,@ExCollectNum,@ExSingleCollectNum,@ExOpusUnitPrice,@ExAccountPrice,@AddTime,@IsDelete)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@CustomerID", SqlDbType.Int,4),
new SqlParameter("@ExType", SqlDbType.Char,1),
new SqlParameter("@ExTime", SqlDbType.DateTime),
new SqlParameter("@ExCpName", SqlDbType.NVarChar,50),
new SqlParameter("@ExOpusName", SqlDbType.NVarChar,200),
new SqlParameter("@ExCooperation", SqlDbType.NVarChar,100),
new SqlParameter("@ExCollectNum", SqlDbType.Int,4),
new SqlParameter("@ExSingleCollectNum", SqlDbType.Int,4),
new SqlParameter("@ExOpusUnitPrice", SqlDbType.Decimal,9),
new SqlParameter("@ExAccountPrice", SqlDbType.Decimal,9),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@IsDelete", SqlDbType.Bit,1)};
parameters[0].Value = model.CustomerID;
parameters[1].Value = model.ExType;
parameters[2].Value = model.ExTime;
parameters[3].Value = model.ExCpName;
parameters[4].Value = model.ExOpusName;
parameters[5].Value = model.ExCooperation;
parameters[6].Value = model.ExCollectNum;
parameters[7].Value = model.ExSingleCollectNum;
parameters[8].Value = model.ExOpusUnitPrice;
parameters[9].Value = model.ExAccountPrice;
parameters[10].Value = model.AddTime;
parameters[11].Value = model.IsDelete;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(KSOA.Model.Admin_KSCustomer model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Admin_KSCustomer(");
strSql.Append("RoleID,RealName,CusName,Gender,Age,CusPwd,CusEmail,CusPhoneNum,QQ,IsDelete,AddTime)");
strSql.Append(" values (");
strSql.Append("@RoleID,@RealName,@CusName,@Gender,@Age,@CusPwd,@CusEmail,@CusPhoneNum,@QQ,@IsDelete,@AddTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@RoleID", SqlDbType.NVarChar,50),
new SqlParameter("@RealName", SqlDbType.NVarChar,50),
new SqlParameter("@CusName", SqlDbType.NVarChar,50),
new SqlParameter("@Gender", SqlDbType.Char,1),
new SqlParameter("@Age", SqlDbType.Int,4),
new SqlParameter("@CusPwd", SqlDbType.NVarChar,50),
new SqlParameter("@CusEmail", SqlDbType.NVarChar,50),
new SqlParameter("@CusPhoneNum", SqlDbType.NVarChar,50),
new SqlParameter("@QQ", SqlDbType.VarChar,50),
new SqlParameter("@IsDelete", SqlDbType.Bit,1),
new SqlParameter("@AddTime", SqlDbType.DateTime)};
parameters[0].Value = model.RoleID;
parameters[1].Value = model.RealName;
parameters[2].Value = model.CusName;
parameters[3].Value = model.Gender;
parameters[4].Value = model.Age;
parameters[5].Value = model.CusPwd;
parameters[6].Value = model.CusEmail;
parameters[7].Value = model.CusPhoneNum;
parameters[8].Value = model.QQ;
parameters[9].Value = model.IsDelete;
parameters[10].Value = model.AddTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(KSOA.Model.Work_Note model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Work_Note(");
strSql.Append("WType,WriterID,WriterName,WTitle,WConetent,WTaster,IsDelete,AddTime,WIP)");
strSql.Append(" values (");
strSql.Append("@WType,@WriterID,@WriterName,@WTitle,@WConetent,@WTaster,@IsDelete,@AddTime,@WIP)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@WType", SqlDbType.Char,1),
new SqlParameter("@WriterID", SqlDbType.Int,4),
new SqlParameter("@WriterName", SqlDbType.NVarChar,50),
new SqlParameter("@WTitle", SqlDbType.NVarChar,50),
new SqlParameter("@WConetent", SqlDbType.NVarChar,-1),
new SqlParameter("@WTaster", SqlDbType.Int,4),
new SqlParameter("@IsDelete", SqlDbType.Bit,1),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@WIP", SqlDbType.VarChar,50)};
parameters[0].Value = model.WType;
parameters[1].Value = model.WriterID;
parameters[2].Value = model.WriterName;
parameters[3].Value = model.WTitle;
parameters[4].Value = model.WConetent;
parameters[5].Value = model.WTaster;
parameters[6].Value = model.IsDelete;
parameters[7].Value = model.AddTime;
parameters[8].Value = model.WIP;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(KSOA.Model.Admin_SysMenu model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Admin_SysMenu(");
strSql.Append("ParentID,MenuName,MenuUrl,OrderIndex,AdminRoleID,IsEnable,IsDelete,AddTime)");
strSql.Append(" values (");
strSql.Append("@ParentID,@MenuName,@MenuUrl,@OrderIndex,@AdminRoleID,@IsEnable,@IsDelete,@AddTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ParentID", SqlDbType.Int,4),
new SqlParameter("@MenuName", SqlDbType.NVarChar,50),
new SqlParameter("@MenuUrl", SqlDbType.NVarChar,200),
new SqlParameter("@OrderIndex", SqlDbType.Int,4),
new SqlParameter("@AdminRoleID", SqlDbType.Int,4),
new SqlParameter("@IsEnable", SqlDbType.Bit,1),
new SqlParameter("@IsDelete", SqlDbType.Bit,1),
new SqlParameter("@AddTime", SqlDbType.DateTime)};
parameters[0].Value = model.ParentID;
parameters[1].Value = model.MenuName;
parameters[2].Value = model.MenuUrl;
parameters[3].Value = model.OrderIndex;
parameters[4].Value = model.AdminRoleID;
parameters[5].Value = model.IsEnable;
parameters[6].Value = model.IsDelete;
parameters[7].Value = model.AddTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(KSOA.Model.Work_Notice model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Work_Notice(");
strSql.Append("NTitle,NContent,NCustomerID,NCustomerName,Nlevel,AddTime,IsDelete,NIP)");
strSql.Append(" values (");
strSql.Append("@NTitle,@NContent,@NCustomerID,@NCustomerName,@Nlevel,@AddTime,@IsDelete,@NIP)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@NTitle", SqlDbType.NVarChar,50),
new SqlParameter("@NContent", SqlDbType.NVarChar,-1),
new SqlParameter("@NCustomerID", SqlDbType.Int,4),
new SqlParameter("@NCustomerName", SqlDbType.NVarChar,50),
new SqlParameter("@Nlevel", SqlDbType.Int,4),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@IsDelete", SqlDbType.Bit,1),
new SqlParameter("@NIP", SqlDbType.VarChar,50)};
parameters[0].Value = model.NTitle;
parameters[1].Value = model.NContent;
parameters[2].Value = model.NCustomerID;
parameters[3].Value = model.NCustomerName;
parameters[4].Value = model.Nlevel;
parameters[5].Value = model.AddTime;
parameters[6].Value = model.IsDelete;
parameters[7].Value = model.NIP;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(KSOA.Model.Admin_Role model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Admin_Role(");
strSql.Append("RoleName,Input,See,Import,Export,RoleNote,IsDelete,AddTime)");
strSql.Append(" values (");
strSql.Append("@RoleName,@Input,@See,@Import,@Export,@RoleNote,@IsDelete,@AddTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@RoleName", SqlDbType.NVarChar,50),
new SqlParameter("@Input", SqlDbType.Bit,1),
new SqlParameter("@See", SqlDbType.Bit,1),
new SqlParameter("@Import", SqlDbType.Bit,1),
new SqlParameter("@Export", SqlDbType.Bit,1),
new SqlParameter("@RoleNote", SqlDbType.NVarChar,-1),
new SqlParameter("@IsDelete", SqlDbType.Bit,1),
new SqlParameter("@AddTime", SqlDbType.DateTime)};
parameters[0].Value = model.RoleName;
parameters[1].Value = model.Input;
parameters[2].Value = model.See;
parameters[3].Value = model.Import;
parameters[4].Value = model.Export;
parameters[5].Value = model.RoleNote;
parameters[6].Value = model.IsDelete;
parameters[7].Value = model.AddTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KSOA.Model.UI_ExcelImportByPlatform model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update UI_ExcelImportByPlatform set ");
strSql.Append("CustomerID=@CustomerID,");
strSql.Append("ExType=@ExType,");
strSql.Append("ExTime=@ExTime,");
strSql.Append("ExCpName=@ExCpName,");
strSql.Append("ExOpusName=@ExOpusName,");
strSql.Append("ExCooperation=@ExCooperation,");
strSql.Append("ExCollectNum=@ExCollectNum,");
strSql.Append("ExSingleCollectNum=@ExSingleCollectNum,");
strSql.Append("ExOpusUnitPrice=@ExOpusUnitPrice,");
strSql.Append("ExAccountPrice=@ExAccountPrice,");
strSql.Append("AddTime=@AddTime,");
strSql.Append("IsDelete=@IsDelete");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@CustomerID", SqlDbType.Int,4),
new SqlParameter("@ExType", SqlDbType.Char,1),
new SqlParameter("@ExTime", SqlDbType.DateTime),
new SqlParameter("@ExCpName", SqlDbType.NVarChar,50),
new SqlParameter("@ExOpusName", SqlDbType.NVarChar,200),
new SqlParameter("@ExCooperation", SqlDbType.NVarChar,100),
new SqlParameter("@ExCollectNum", SqlDbType.Int,4),
new SqlParameter("@ExSingleCollectNum", SqlDbType.Int,4),
new SqlParameter("@ExOpusUnitPrice", SqlDbType.Decimal,9),
new SqlParameter("@ExAccountPrice", SqlDbType.Decimal,9),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@IsDelete", SqlDbType.Bit,1),
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = model.CustomerID;
parameters[1].Value = model.ExType;
parameters[2].Value = model.ExTime;
parameters[3].Value = model.ExCpName;
parameters[4].Value = model.ExOpusName;
parameters[5].Value = model.ExCooperation;
parameters[6].Value = model.ExCollectNum;
parameters[7].Value = model.ExSingleCollectNum;
parameters[8].Value = model.ExOpusUnitPrice;
parameters[9].Value = model.ExAccountPrice;
parameters[10].Value = model.AddTime;
parameters[11].Value = model.IsDelete;
parameters[12].Value = model.ID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KSOA.Model.Admin_SysMenu model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Admin_SysMenu set ");
strSql.Append("ParentID=@ParentID,");
strSql.Append("MenuName=@MenuName,");
strSql.Append("MenuUrl=@MenuUrl,");
strSql.Append("OrderIndex=@OrderIndex,");
strSql.Append("AdminRoleID=@AdminRoleID,");
strSql.Append("IsEnable=@IsEnable,");
strSql.Append("IsDelete=@IsDelete,");
strSql.Append("AddTime=@AddTime");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@ParentID", SqlDbType.Int,4),
new SqlParameter("@MenuName", SqlDbType.NVarChar,50),
new SqlParameter("@MenuUrl", SqlDbType.NVarChar,200),
new SqlParameter("@OrderIndex", SqlDbType.Int,4),
new SqlParameter("@AdminRoleID", SqlDbType.Int,4),
new SqlParameter("@IsEnable", SqlDbType.Bit,1),
new SqlParameter("@IsDelete", SqlDbType.Bit,1),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = model.ParentID;
parameters[1].Value = model.MenuName;
parameters[2].Value = model.MenuUrl;
parameters[3].Value = model.OrderIndex;
parameters[4].Value = model.AdminRoleID;
parameters[5].Value = model.IsEnable;
parameters[6].Value = model.IsDelete;
parameters[7].Value = model.AddTime;
parameters[8].Value = model.ID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KSOA.Model.Work_Notice model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Work_Notice set ");
strSql.Append("NTitle=@NTitle,");
strSql.Append("NContent=@NContent,");
strSql.Append("NCustomerID=@NCustomerID,");
strSql.Append("NCustomerName=@NCustomerName,");
strSql.Append("Nlevel=@Nlevel,");
strSql.Append("AddTime=@AddTime,");
strSql.Append("IsDelete=@IsDelete,");
strSql.Append("NIP=@NIP");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@NTitle", SqlDbType.NVarChar,50),
new SqlParameter("@NContent", SqlDbType.NVarChar,-1),
new SqlParameter("@NCustomerID", SqlDbType.Int,4),
new SqlParameter("@NCustomerName", SqlDbType.NVarChar,50),
new SqlParameter("@Nlevel", SqlDbType.Int,4),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@IsDelete", SqlDbType.Bit,1),
new SqlParameter("@NIP", SqlDbType.VarChar,50),
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = model.NTitle;
parameters[1].Value = model.NContent;
parameters[2].Value = model.NCustomerID;
parameters[3].Value = model.NCustomerName;
parameters[4].Value = model.Nlevel;
parameters[5].Value = model.AddTime;
parameters[6].Value = model.IsDelete;
parameters[7].Value = model.NIP;
parameters[8].Value = model.ID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KSOA.Model.Bank_Opus model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Bank_Opus set ");
strSql.Append("OpType=@OpType,");
strSql.Append("OpTitle=@OpTitle,");
strSql.Append("OpAuthor=@OpAuthor,");
strSql.Append("OpBeginTime=@OpBeginTime,");
strSql.Append("AddTime=@AddTime,");
strSql.Append("IsDelete=@IsDelete");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@OpType", SqlDbType.Char,1),
new SqlParameter("@OpTitle", SqlDbType.NVarChar,50),
new SqlParameter("@OpAuthor", SqlDbType.NVarChar,50),
new SqlParameter("@OpBeginTime", SqlDbType.DateTime),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@IsDelete", SqlDbType.Bit,1),
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = model.OpType;
parameters[1].Value = model.OpTitle;
parameters[2].Value = model.OpAuthor;
parameters[3].Value = model.OpBeginTime;
parameters[4].Value = model.AddTime;
parameters[5].Value = model.IsDelete;
parameters[6].Value = model.ID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KSOA.Model.Admin_Role model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Admin_Role set ");
strSql.Append("RoleName=@RoleName,");
strSql.Append("Input=@Input,");
strSql.Append("See=@See,");
strSql.Append("Import=@Import,");
strSql.Append("Export=@Export,");
strSql.Append("RoleNote=@RoleNote,");
strSql.Append("IsDelete=@IsDelete,");
strSql.Append("AddTime=@AddTime");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@RoleName", SqlDbType.NVarChar,50),
new SqlParameter("@Input", SqlDbType.Bit,1),
new SqlParameter("@See", SqlDbType.Bit,1),
new SqlParameter("@Import", SqlDbType.Bit,1),
new SqlParameter("@Export", SqlDbType.Bit,1),
new SqlParameter("@RoleNote", SqlDbType.NVarChar,-1),
new SqlParameter("@IsDelete", SqlDbType.Bit,1),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = model.RoleName;
parameters[1].Value = model.Input;
parameters[2].Value = model.See;
parameters[3].Value = model.Import;
parameters[4].Value = model.Export;
parameters[5].Value = model.RoleNote;
parameters[6].Value = model.IsDelete;
parameters[7].Value = model.AddTime;
parameters[8].Value = model.ID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KSOA.Model.Admin_Platform model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Admin_Platform set ");
strSql.Append("PType=@PType,");
strSql.Append("PName=@PName,");
strSql.Append("IsDelete=@IsDelete,");
strSql.Append("AddTime=@AddTime");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@PType", SqlDbType.NVarChar,50),
new SqlParameter("@PName", SqlDbType.NVarChar,50),
new SqlParameter("@IsDelete", SqlDbType.Bit,1),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = model.PType;
parameters[1].Value = model.PName;
parameters[2].Value = model.IsDelete;
parameters[3].Value = model.AddTime;
parameters[4].Value = model.ID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KSOA.Model.Admin_OperatLog model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Admin_OperatLog set ");
strSql.Append("OperatorID=@OperatorID,");
strSql.Append("OperatorName=@OperatorName,");
strSql.Append("Module=@Module,");
strSql.Append("OperationContent=@OperationContent,");
strSql.Append("OpIp=@OpIp,");
strSql.Append("AddTime=@AddTime");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@OperatorID", SqlDbType.Int,4),
new SqlParameter("@OperatorName", SqlDbType.NVarChar,50),
new SqlParameter("@Module", SqlDbType.NVarChar,50),
new SqlParameter("@OperationContent", SqlDbType.NVarChar,-1),
new SqlParameter("@OpIp", SqlDbType.VarChar,50),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = model.OperatorID;
parameters[1].Value = model.OperatorName;
parameters[2].Value = model.Module;
parameters[3].Value = model.OperationContent;
parameters[4].Value = model.OpIp;
parameters[5].Value = model.AddTime;
parameters[6].Value = model.ID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KSOA.Model.Work_Note model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Work_Note set ");
strSql.Append("WType=@WType,");
strSql.Append("WriterID=@WriterID,");
strSql.Append("WriterName=@WriterName,");
strSql.Append("WTitle=@WTitle,");
strSql.Append("WConetent=@WConetent,");
strSql.Append("WTaster=@WTaster,");
strSql.Append("IsDelete=@IsDelete,");
strSql.Append("AddTime=@AddTime,");
strSql.Append("WIP=@WIP");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@WType", SqlDbType.Char,1),
new SqlParameter("@WriterID", SqlDbType.Int,4),
new SqlParameter("@WriterName", SqlDbType.NVarChar,50),
new SqlParameter("@WTitle", SqlDbType.NVarChar,50),
new SqlParameter("@WConetent", SqlDbType.NVarChar,-1),
new SqlParameter("@WTaster", SqlDbType.Int,4),
new SqlParameter("@IsDelete", SqlDbType.Bit,1),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@WIP", SqlDbType.VarChar,50),
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = model.WType;
parameters[1].Value = model.WriterID;
parameters[2].Value = model.WriterName;
parameters[3].Value = model.WTitle;
parameters[4].Value = model.WConetent;
parameters[5].Value = model.WTaster;
parameters[6].Value = model.IsDelete;
parameters[7].Value = model.AddTime;
parameters[8].Value = model.WIP;
parameters[9].Value = model.ID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KSOA.Model.Admin_KSCustomer model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Admin_KSCustomer set ");
strSql.Append("RoleID=@RoleID,");
strSql.Append("RealName=@RealName,");
strSql.Append("CusName=@CusName,");
strSql.Append("Gender=@Gender,");
strSql.Append("Age=@Age,");
strSql.Append("CusPwd=@CusPwd,");
strSql.Append("QQ=@QQ,");
strSql.Append("IsDelete=@IsDelete,");
strSql.Append("AddTime=@AddTime");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@RoleID", SqlDbType.NVarChar,50),
new SqlParameter("@RealName", SqlDbType.NVarChar,50),
new SqlParameter("@CusName", SqlDbType.NVarChar,50),
new SqlParameter("@Gender", SqlDbType.Char,1),
new SqlParameter("@Age", SqlDbType.Int,4),
new SqlParameter("@CusPwd", SqlDbType.NVarChar,50),
new SqlParameter("@QQ", SqlDbType.VarChar,50),
new SqlParameter("@IsDelete", SqlDbType.Bit,1),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@ID", SqlDbType.Int,4),
new SqlParameter("@CusEmail", SqlDbType.NVarChar,50),
new SqlParameter("@CusPhoneNum", SqlDbType.NVarChar,50)};
parameters[0].Value = model.RoleID;
parameters[1].Value = model.RealName;
parameters[2].Value = model.CusName;
parameters[3].Value = model.Gender;
parameters[4].Value = model.Age;
parameters[5].Value = model.CusPwd;
parameters[6].Value = model.QQ;
parameters[7].Value = model.IsDelete;
parameters[8].Value = model.AddTime;
parameters[9].Value = model.ID;
parameters[10].Value = model.CusEmail;
parameters[11].Value = model.CusPhoneNum;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KSOA.Model.Bank_CommercialOpus model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Bank_CommercialOpus set ");
strSql.Append("OpusID=@OpusID,");
strSql.Append("CompanyName=@CompanyName,");
strSql.Append("CpAddress=@CpAddress,");
strSql.Append("ChannelAddres=@ChannelAddres,");
strSql.Append("AddTime=@AddTime,");
strSql.Append("IsDelete=@IsDelete");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@OpusID", SqlDbType.Int,4),
new SqlParameter("@CompanyName", SqlDbType.NVarChar,100),
new SqlParameter("@CpAddress", SqlDbType.NVarChar,100),
new SqlParameter("@ChannelAddres", SqlDbType.NVarChar,100),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@IsDelete", SqlDbType.Bit,1),
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = model.OpusID;
parameters[1].Value = model.CompanyName;
parameters[2].Value = model.CpAddress;
parameters[3].Value = model.ChannelAddres;
parameters[4].Value = model.AddTime;
parameters[5].Value = model.IsDelete;
parameters[6].Value = model.ID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
public bool ConvertEcelToTable(HSSFWorkbook hss, int CP, KSOA.Common.KSOAEnum.ImportExcelType type)
{
#region 投诉源数据
if ((int)type == (int)KSOAEnum.ImportExcelType.投诉源数据)
{
ISheet sheet = null;
List<Admin_ExcelResourceForComplain> listModel = new List<Admin_ExcelResourceForComplain>();
for (int i = 0; i < hss.Workbook.NumSheets; i++)//循环sheet
{
sheet = hss.GetSheetAt(i);
System.Collections.IEnumerator rows = sheet.GetRowEnumerator();
rows.MoveNext();//跳过首行标题
while (rows.MoveNext())
{
IRow row = (HSSFRow)rows.Current;
Admin_ExcelResourceForComplain dr = new Admin_ExcelResourceForComplain();
#region FileDateTime投诉归档日期
ICell FileDateTime = row.GetCell(0);
if (FileDateTime == null)
{
dr.FileDateTime = new DateTime(1900, 1, 1);
}
else
{
dr.FileDateTime = Utils.ConvertStrToDate(FileDateTime.ToString());
}
#endregion
#region UserNumber用户号码
ICell UserNumber = row.GetCell(1);
if (UserNumber == null)
{
dr.UserNumber = "00000000000";
}
else
{
dr.UserNumber = UserNumber.ToString();
}
#endregion
#region Province省份
ICell Province = row.GetCell(2);
if (Province == null)
{
dr.Province = "";
}
else
{
dr.Province = Province.ToString();
}
#endregion
#region OrderTime订购日期
ICell OrderTime = row.GetCell(3);
if (OrderTime == null)
{
dr.OrderTime = new DateTime(1900, 1, 1);
}
else
{
dr.OrderTime = Utils.ConvertStrToDate(OrderTime.ToString());
}
#endregion
#region BusinessName订购业务名称
ICell BusinessName = row.GetCell(4);
if (BusinessName == null)
{
dr.BusinessName = "";
}
else
{
dr.BusinessName = BusinessName.ToString();
}
#endregion
#region PayAmount支付费用
ICell PayAmount = row.GetCell(5);
if (BusinessName == null)
{
dr.PayAmount = 0.0M;
}
else
{
dr.PayAmount = Convert.ToDecimal(PayAmount.ToString());
}
#endregion
dr.CPid = CP;
dr.SourceLevel = hss.Workbook.GetSheetName(i).Trim();//sheetname
listModel.Add(dr);
}
}
return new Admin_ExcelResourceForComplainLogic().SaveImportDatas(listModel); ;
}
#endregion
#region 包月源数据
if ((int)type == (int)KSOAEnum.ImportExcelType.包月源数据)
{
ISheet sheet = null;
List<Admin_ExcelResourceForMonth> listModel = new List<Admin_ExcelResourceForMonth>();
for (int i = 0; i < hss.Workbook.NumSheets; i++)//循环sheet
{
sheet = hss.GetSheetAt(i);
System.Collections.IEnumerator rows = sheet.GetRowEnumerator();
rows.MoveNext();//跳过首行标题
while (rows.MoveNext())
{
IRow row = (HSSFRow)rows.Current;
Admin_ExcelResourceForMonth dr = new Admin_ExcelResourceForMonth();
#region RowNumber行号
ICell RowNumber = row.GetCell(0);
if (RowNumber == null)
{
dr.RowNumber = -1;//未标示行号
}
else
{
dr.RowNumber = Convert.ToInt32(RowNumber.ToString());
}
#endregion
#region StatisticsTime统计日期
ICell StatisticsTime = row.GetCell(1);
if (StatisticsTime == null)
{
dr.StatisticsTime = new DateTime(1900, 1, 1);
}
else
{
dr.StatisticsTime = Utils.ConvertStrToDate(StatisticsTime.ToString());
}
#endregion
#region SingleOpusName单部名称
ICell SingleOpusName = row.GetCell(2);
if (SingleOpusName == null)
{
dr.SingleOpusName = "";
}
else
{
dr.SingleOpusName = SingleOpusName.ToString();
}
#endregion
#region NotBaoyuePlayNum非包月点播次数
ICell NotBaoyuePlayNum = row.GetCell(3);
if (NotBaoyuePlayNum == null)
{
dr.NotBaoyuePlayNum = 0;
}
else
{
dr.NotBaoyuePlayNum = Convert.ToInt32(NotBaoyuePlayNum.ToString());
}
#endregion
#region BaoyuePlayNum包月点播次数
ICell BaoyuePlayNum = row.GetCell(4);
if (BaoyuePlayNum == null)
{
dr.BaoyuePlayNum = 0;
}
else
{
dr.BaoyuePlayNum = Convert.ToInt32(BaoyuePlayNum.ToString());
}
#endregion
#region PayBillPlayNum付费点播次数
ICell PayBillPlayNum = row.GetCell(5);
if (PayBillPlayNum == null)
{
dr.PayBillPlayNum = 0;
}
else
{
dr.PayBillPlayNum = Convert.ToInt32(PayBillPlayNum.ToString());
}
#endregion
#region FreePlayNum免费点播次数
ICell FreePlayNum = row.GetCell(5);
if (FreePlayNum == null)
{
dr.FreePlayNum = 0;
}
else
{
dr.FreePlayNum = Convert.ToInt32(FreePlayNum.ToString());
}
#endregion
#region NotBaoyuePayBillPlayNum非包月付费点播次数
ICell NotBaoyuePayBillPlayNum = row.GetCell(5);
if (FreePlayNum == null)
{
dr.NotBaoyuePayBillPlayNum = 0;
}
else
{
dr.NotBaoyuePayBillPlayNum = Convert.ToInt32(NotBaoyuePayBillPlayNum.ToString());
}
#endregion
dr.CPid = CP;
dr.SourceLevel = hss.Workbook.GetSheetName(i).Trim();
listModel.Add(dr);
}
}
return new Admin_ExcelResourceForMonthLogic().SaveImportDatas(listModel); ;
}
#endregion
#region 非包月付费源数据
if ((int)type == (int)KSOAEnum.ImportExcelType.非包月付费源数据)
{
ISheet sheet = null;
List<Admin_NBPAccumulative> listModel = new List<Admin_NBPAccumulative>();
for (int i = 0; i < hss.Workbook.NumSheets; i++)//循环sheet
{
sheet = hss.GetSheetAt(i);
System.Collections.IEnumerator rows = sheet.GetRowEnumerator();
rows.MoveNext();//跳过首行标题
while (rows.MoveNext())
{
IRow row = (HSSFRow)rows.Current;
Admin_NBPAccumulative dr = new Admin_NBPAccumulative();
#region CountTime统计日期
ICell CountTime = row.GetCell(0);
if (CountTime == null)
{
dr.CountTime = new DateTime(1900, 1, 1);
}
else
{
dr.CountTime = Utils.ConvertStrToDate(CountTime.ToString());
}
#endregion
#region Province省份
ICell Province = row.GetCell(1);
if (Province == null)
{
dr.Province = "";
}
else
{
dr.Province = Province.ToString();
}
#endregion
#region CpNameCP名称
ICell CpName = row.GetCell(2);
if (CpName == null)
{
dr.CpName = "";
}
else
{
dr.CpName = CpName.ToString();
}
#endregion
#region NBPCount非包月付费用户数
ICell NBPCount = row.GetCell(3);
if (NBPCount == null)
{
dr.NBPCount = 0;
}
else
{
dr.NBPCount = Convert.ToInt32(NBPCount.ToString());
}
#endregion
listModel.Add(dr);
}
}
return new Admin_NBPAccumulativeLogic().SaveImportDatas(listModel); ;
}
#endregion
return false;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KSOA.Model.Bank_OriginalGroup model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Bank_OriginalGroup set ");
strSql.Append("OpusCopyright=@OpusCopyright,");
strSql.Append("CreationInfo=@CreationInfo,");
strSql.Append("OpusName=@OpusName,");
strSql.Append("OpusAuthor=@OpusAuthor,");
strSql.Append("SalePrice=@SalePrice,");
strSql.Append("AccreditPlatform=@AccreditPlatform,");
strSql.Append("AccreditCompany=@AccreditCompany,");
strSql.Append("AccreditTime=@AccreditTime,");
strSql.Append("AccreditType=@AccreditType,");
strSql.Append("Awards=@Awards,");
strSql.Append("OpusMascot=@OpusMascot,");
strSql.Append("AddTime=@AddTime,");
strSql.Append("IsDelete=@IsDelete");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@OpusCopyright", SqlDbType.NVarChar,300),
new SqlParameter("@CreationInfo", SqlDbType.NVarChar,50),
new SqlParameter("@OpusName", SqlDbType.NVarChar,300),
new SqlParameter("@OpusAuthor", SqlDbType.NVarChar,50),
new SqlParameter("@SalePrice", SqlDbType.Decimal,9),
new SqlParameter("@AccreditPlatform", SqlDbType.NVarChar,50),
new SqlParameter("@AccreditCompany", SqlDbType.NVarChar,50),
new SqlParameter("@AccreditTime", SqlDbType.DateTime),
new SqlParameter("@AccreditType", SqlDbType.NVarChar,50),
new SqlParameter("@Awards", SqlDbType.NVarChar,-1),
new SqlParameter("@OpusMascot", SqlDbType.NVarChar,50),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@IsDelete", SqlDbType.Bit,1),
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = model.OpusCopyright;
parameters[1].Value = model.CreationInfo;
parameters[2].Value = model.OpusName;
parameters[3].Value = model.OpusAuthor;
parameters[4].Value = model.SalePrice;
parameters[5].Value = model.AccreditPlatform;
parameters[6].Value = model.AccreditCompany;
parameters[7].Value = model.AccreditTime;
parameters[8].Value = model.AccreditType;
parameters[9].Value = model.Awards;
parameters[10].Value = model.OpusMascot;
parameters[11].Value = model.AddTime;
parameters[12].Value = model.IsDelete;
parameters[13].Value = model.ID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KSOA.Model.Admin_SysErrorLog model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Admin_SysErrorLog set ");
strSql.Append("PageUrl=@PageUrl,");
strSql.Append("ErrorMsg=@ErrorMsg,");
strSql.Append("AddTime=@AddTime");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@PageUrl", SqlDbType.NVarChar,200),
new SqlParameter("@ErrorMsg", SqlDbType.NVarChar,-1),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = model.PageUrl;
parameters[1].Value = model.ErrorMsg;
parameters[2].Value = model.AddTime;
parameters[3].Value = model.ID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
