/// <summary>
/// 得到一个对象实体
/// </summary>
public MxWeiXinPF.Model.wx_qp_base GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,wid,bName,actBegin,actEnd,yyRemark,qpRemark,maxPersonNum,cyPersonNum,isSnSendsms,yyQPBeginDate,yyQPEndDate,yyGouPiaoBeginDate,yyGouPiaoEndDate,remark,createDate,sort_id,beginPic,haibaoPic from wx_qp_base ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
MxWeiXinPF.Model.wx_qp_base model = new MxWeiXinPF.Model.wx_qp_base();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model = DataRowToModel(ds.Tables[0].Rows[0]);
DAL.wx_qp_img imgDal = new wx_qp_img();
IList <Model.wx_qp_img> imglist = imgDal.GetModelList("bId=" + id + " and itype=2");
if (imglist != null)
{
model.yingyuanlist = (from a in imglist where a.iType == 2 select a).ToArray <Model.wx_qp_img>();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MxWeiXinPF.Model.wx_qp_base DataRowToModel(DataRow row)
{
MxWeiXinPF.Model.wx_qp_base model = new MxWeiXinPF.Model.wx_qp_base();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["wid"] != null && row["wid"].ToString() != "")
{
model.wid = int.Parse(row["wid"].ToString());
}
if (row["bName"] != null)
{
model.bName = row["bName"].ToString();
}
if (row["actBegin"] != null && row["actBegin"].ToString() != "")
{
model.actBegin = DateTime.Parse(row["actBegin"].ToString());
}
if (row["actEnd"] != null && row["actEnd"].ToString() != "")
{
model.actEnd = DateTime.Parse(row["actEnd"].ToString());
}
if (row["yyRemark"] != null)
{
model.yyRemark = row["yyRemark"].ToString();
}
if (row["qpRemark"] != null)
{
model.qpRemark = row["qpRemark"].ToString();
}
if (row["maxPersonNum"] != null && row["maxPersonNum"].ToString() != "")
{
model.maxPersonNum = int.Parse(row["maxPersonNum"].ToString());
}
if (row["cyPersonNum"] != null && row["cyPersonNum"].ToString() != "")
{
model.cyPersonNum = int.Parse(row["cyPersonNum"].ToString());
}
if (row["isSnSendsms"] != null && row["isSnSendsms"].ToString() != "")
{
if ((row["isSnSendsms"].ToString() == "1") || (row["isSnSendsms"].ToString().ToLower() == "true"))
{
model.isSnSendsms = true;
}
else
{
model.isSnSendsms = false;
}
}
if (row["yyQPBeginDate"] != null && row["yyQPBeginDate"].ToString() != "")
{
model.yyQPBeginDate = DateTime.Parse(row["yyQPBeginDate"].ToString());
}
if (row["yyQPEndDate"] != null && row["yyQPEndDate"].ToString() != "")
{
model.yyQPEndDate = DateTime.Parse(row["yyQPEndDate"].ToString());
}
if (row["yyGouPiaoBeginDate"] != null && row["yyGouPiaoBeginDate"].ToString() != "")
{
model.yyGouPiaoBeginDate = DateTime.Parse(row["yyGouPiaoBeginDate"].ToString());
}
if (row["yyGouPiaoEndDate"] != null && row["yyGouPiaoEndDate"].ToString() != "")
{
model.yyGouPiaoEndDate = DateTime.Parse(row["yyGouPiaoEndDate"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
if (row["createDate"] != null && row["createDate"].ToString() != "")
{
model.createDate = DateTime.Parse(row["createDate"].ToString());
}
if (row["sort_id"] != null && row["sort_id"].ToString() != "")
{
model.sort_id = int.Parse(row["sort_id"].ToString());
}
if (row["beginPic"] != null)
{
model.beginPic = row["beginPic"].ToString();
}
if (row["haibaoPic"] != null)
{
model.haibaoPic = row["haibaoPic"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MxWeiXinPF.Model.wx_qp_base model)
{
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update wx_qp_base set ");
strSql.Append("wid=@wid,");
strSql.Append("bName=@bName,");
strSql.Append("actBegin=@actBegin,");
strSql.Append("actEnd=@actEnd,");
strSql.Append("yyRemark=@yyRemark,");
strSql.Append("qpRemark=@qpRemark,");
strSql.Append("maxPersonNum=@maxPersonNum,");
strSql.Append("cyPersonNum=@cyPersonNum,");
strSql.Append("isSnSendsms=@isSnSendsms,");
strSql.Append("yyQPBeginDate=@yyQPBeginDate,");
strSql.Append("yyQPEndDate=@yyQPEndDate,");
strSql.Append("yyGouPiaoBeginDate=@yyGouPiaoBeginDate,");
strSql.Append("yyGouPiaoEndDate=@yyGouPiaoEndDate,");
strSql.Append("remark=@remark,");
strSql.Append("createDate=@createDate,");
strSql.Append("sort_id=@sort_id,");
strSql.Append("beginPic=@beginPic,");
strSql.Append("haibaoPic=@haibaoPic");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@wid", SqlDbType.Int, 4),
new SqlParameter("@bName", SqlDbType.VarChar, 300),
new SqlParameter("@actBegin", SqlDbType.DateTime),
new SqlParameter("@actEnd", SqlDbType.DateTime),
new SqlParameter("@yyRemark", SqlDbType.VarChar, 2000),
new SqlParameter("@qpRemark", SqlDbType.VarChar, 2000),
new SqlParameter("@maxPersonNum", SqlDbType.Int, 4),
new SqlParameter("@cyPersonNum", SqlDbType.Int, 4),
new SqlParameter("@isSnSendsms", SqlDbType.Bit, 1),
new SqlParameter("@yyQPBeginDate", SqlDbType.DateTime),
new SqlParameter("@yyQPEndDate", SqlDbType.DateTime),
new SqlParameter("@yyGouPiaoBeginDate", SqlDbType.DateTime),
new SqlParameter("@yyGouPiaoEndDate", SqlDbType.DateTime),
new SqlParameter("@remark", SqlDbType.VarChar, 2000),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@sort_id", SqlDbType.Int, 4),
new SqlParameter("@beginPic", SqlDbType.VarChar, 800),
new SqlParameter("@haibaoPic", SqlDbType.VarChar, 800),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.wid;
parameters[1].Value = model.bName;
parameters[2].Value = model.actBegin;
parameters[3].Value = model.actEnd;
parameters[4].Value = model.yyRemark;
parameters[5].Value = model.qpRemark;
parameters[6].Value = model.maxPersonNum;
parameters[7].Value = model.cyPersonNum;
parameters[8].Value = model.isSnSendsms;
parameters[9].Value = model.yyQPBeginDate;
parameters[10].Value = model.yyQPEndDate;
parameters[11].Value = model.yyGouPiaoBeginDate;
parameters[12].Value = model.yyGouPiaoEndDate;
parameters[13].Value = model.remark;
parameters[14].Value = model.createDate;
parameters[15].Value = model.sort_id;
parameters[16].Value = model.beginPic;
parameters[17].Value = model.haibaoPic;
parameters[18].Value = model.id;
DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters);
//添加/修改相册
if (model.yingyuanlist != null)
{
StringBuilder strSql3;
foreach (Model.wx_qp_img modelt in model.yingyuanlist)
{
strSql3 = new StringBuilder();
strSql3.Append("insert into wx_qp_img(");
strSql3.Append("bId,iName,iType,imgPic,createDate)");
strSql3.Append(" values (");
strSql3.Append("@bId,@iName,2,@imgPic,getdate())");
SqlParameter[] parameters3 =
{
new SqlParameter("@bId", SqlDbType.Int, 4),
new SqlParameter("@iName", SqlDbType.NVarChar, 300),
new SqlParameter("@imgPic", SqlDbType.NVarChar, 800)
};
parameters3[0].Value = model.id;
parameters3[1].Value = modelt.iName;
parameters3[2].Value = modelt.imgPic;
DbHelperSQL.ExecuteSql(conn, trans, strSql3.ToString(), parameters3);
}
}
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MxWeiXinPF.Model.wx_qp_base model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into wx_qp_base(");
strSql.Append("wid,bName,actBegin,actEnd,yyRemark,qpRemark,maxPersonNum,cyPersonNum,isSnSendsms,yyQPBeginDate,yyQPEndDate,yyGouPiaoBeginDate,yyGouPiaoEndDate,remark,createDate,sort_id,beginPic,haibaoPic)");
strSql.Append(" values (");
strSql.Append("@wid,@bName,@actBegin,@actEnd,@yyRemark,@qpRemark,@maxPersonNum,@cyPersonNum,@isSnSendsms,@yyQPBeginDate,@yyQPEndDate,@yyGouPiaoBeginDate,@yyGouPiaoEndDate,@remark,@createDate,@sort_id,@beginPic,@haibaoPic)");
strSql.Append(";set @ReturnValue= @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@wid", SqlDbType.Int, 4),
new SqlParameter("@bName", SqlDbType.VarChar, 300),
new SqlParameter("@actBegin", SqlDbType.DateTime),
new SqlParameter("@actEnd", SqlDbType.DateTime),
new SqlParameter("@yyRemark", SqlDbType.VarChar, 2000),
new SqlParameter("@qpRemark", SqlDbType.VarChar, 2000),
new SqlParameter("@maxPersonNum", SqlDbType.Int, 4),
new SqlParameter("@cyPersonNum", SqlDbType.Int, 4),
new SqlParameter("@isSnSendsms", SqlDbType.Bit, 1),
new SqlParameter("@yyQPBeginDate", SqlDbType.DateTime),
new SqlParameter("@yyQPEndDate", SqlDbType.DateTime),
new SqlParameter("@yyGouPiaoBeginDate", SqlDbType.DateTime),
new SqlParameter("@yyGouPiaoEndDate", SqlDbType.DateTime),
new SqlParameter("@remark", SqlDbType.VarChar, 2000),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@sort_id", SqlDbType.Int, 4),
new SqlParameter("@beginPic", SqlDbType.VarChar, 800),
new SqlParameter("@haibaoPic", SqlDbType.VarChar, 800),
new SqlParameter("@ReturnValue", SqlDbType.Int)
};
parameters[0].Value = model.wid;
parameters[1].Value = model.bName;
parameters[2].Value = model.actBegin;
parameters[3].Value = model.actEnd;
parameters[4].Value = model.yyRemark;
parameters[5].Value = model.qpRemark;
parameters[6].Value = model.maxPersonNum;
parameters[7].Value = model.cyPersonNum;
parameters[8].Value = model.isSnSendsms;
parameters[9].Value = model.yyQPBeginDate;
parameters[10].Value = model.yyQPEndDate;
parameters[11].Value = model.yyGouPiaoBeginDate;
parameters[12].Value = model.yyGouPiaoEndDate;
parameters[13].Value = model.remark;
parameters[14].Value = model.createDate;
parameters[15].Value = model.sort_id;
parameters[16].Value = model.beginPic;
parameters[17].Value = model.haibaoPic;
parameters[18].Direction = ParameterDirection.Output;
List <CommandInfo> sqllist = new List <CommandInfo>();
CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters);
sqllist.Add(cmd);
//图片相册
if (model.yingyuanlist != null)
{
StringBuilder strSql3;
foreach (Model.wx_qp_img modelt in model.yingyuanlist)
{
strSql3 = new StringBuilder();
strSql3.Append("insert into wx_qp_img(");
strSql3.Append("bId,iName,iType,imgPic,createDate)");
strSql3.Append(" values (");
strSql3.Append("@bId,@iName,2,@imgPic,getdate())");
SqlParameter[] parameters3 =
{
new SqlParameter("@bId", SqlDbType.Int, 4),
new SqlParameter("@iName", SqlDbType.NVarChar, 300),
new SqlParameter("@imgPic", SqlDbType.NVarChar, 800)
};
parameters3[0].Direction = ParameterDirection.InputOutput;
parameters3[1].Value = modelt.iName;
parameters3[2].Value = modelt.imgPic;
cmd = new CommandInfo(strSql3.ToString(), parameters3);
sqllist.Add(cmd);
}
}
DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist);
return((int)parameters[18].Value);
}
