/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BrnMall.Core.Model.YX_video model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into YX_video(");
strSql.Append("EventId,videoTitle,videoDescription,videoMediaId,EventCate,remark1,remark2,remark3,flat1,flat2,remark4,remark5,remark6,flat7,flat8,RegTim1,RegTim2)");
strSql.Append(" values (");
strSql.Append("@EventId,@videoTitle,@videoDescription,@videoMediaId,@EventCate,@remark1,@remark2,@remark3,@flat1,@flat2,@remark4,@remark5,@remark6,@flat7,@flat8,@RegTim1,@RegTim2)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@EventId", SqlDbType.Int, 4),
new SqlParameter("@videoTitle", SqlDbType.NVarChar, 50),
new SqlParameter("@videoDescription", SqlDbType.NVarChar, 1000),
new SqlParameter("@videoMediaId", SqlDbType.VarChar, 500),
new SqlParameter("@EventCate", SqlDbType.VarChar, 50),
new SqlParameter("@remark1", SqlDbType.NVarChar, 500),
new SqlParameter("@remark2", SqlDbType.NVarChar, 500),
new SqlParameter("@remark3", SqlDbType.NText),
new SqlParameter("@flat1", SqlDbType.Int, 4),
new SqlParameter("@flat2", SqlDbType.Int, 4),
new SqlParameter("@remark4", SqlDbType.NVarChar, 50),
new SqlParameter("@remark5", SqlDbType.NVarChar, 50),
new SqlParameter("@remark6", SqlDbType.NText),
new SqlParameter("@flat7", SqlDbType.Int, 4),
new SqlParameter("@flat8", SqlDbType.Int, 4),
new SqlParameter("@RegTim1", SqlDbType.DateTime),
new SqlParameter("@RegTim2", SqlDbType.DateTime)
};
parameters[0].Value = model.EventId;
parameters[1].Value = model.videoTitle;
parameters[2].Value = model.videoDescription;
parameters[3].Value = model.videoMediaId;
parameters[4].Value = model.EventCate;
parameters[5].Value = model.remark1;
parameters[6].Value = model.remark2;
parameters[7].Value = model.remark3;
parameters[8].Value = model.flat1;
parameters[9].Value = model.flat2;
parameters[10].Value = model.remark4;
parameters[11].Value = model.remark5;
parameters[12].Value = model.remark6;
parameters[13].Value = model.flat7;
parameters[14].Value = model.flat8;
parameters[15].Value = model.RegTim1;
parameters[16].Value = model.RegTim2;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public BrnMall.Core.Model.YX_video GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,EventId,videoTitle,videoDescription,videoMediaId,EventCate,remark1,remark2,remark3,flat1,flat2,remark4,remark5,remark6,flat7,flat8,RegTim1,RegTim2 from YX_video ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
BrnMall.Core.Model.YX_video model = new BrnMall.Core.Model.YX_video();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public BrnMall.Core.Model.YX_video DataRowToModel(DataRow row)
{
BrnMall.Core.Model.YX_video model = new BrnMall.Core.Model.YX_video();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["EventId"] != null && row["EventId"].ToString() != "")
{
model.EventId = int.Parse(row["EventId"].ToString());
}
if (row["videoTitle"] != null)
{
model.videoTitle = row["videoTitle"].ToString();
}
if (row["videoDescription"] != null)
{
model.videoDescription = row["videoDescription"].ToString();
}
if (row["videoMediaId"] != null)
{
model.videoMediaId = row["videoMediaId"].ToString();
}
if (row["EventCate"] != null)
{
model.EventCate = row["EventCate"].ToString();
}
if (row["remark1"] != null)
{
model.remark1 = row["remark1"].ToString();
}
if (row["remark2"] != null)
{
model.remark2 = row["remark2"].ToString();
}
if (row["remark3"] != null)
{
model.remark3 = row["remark3"].ToString();
}
if (row["flat1"] != null && row["flat1"].ToString() != "")
{
model.flat1 = int.Parse(row["flat1"].ToString());
}
if (row["flat2"] != null && row["flat2"].ToString() != "")
{
model.flat2 = int.Parse(row["flat2"].ToString());
}
if (row["remark4"] != null)
{
model.remark4 = row["remark4"].ToString();
}
if (row["remark5"] != null)
{
model.remark5 = row["remark5"].ToString();
}
if (row["remark6"] != null)
{
model.remark6 = row["remark6"].ToString();
}
if (row["flat7"] != null && row["flat7"].ToString() != "")
{
model.flat7 = int.Parse(row["flat7"].ToString());
}
if (row["flat8"] != null && row["flat8"].ToString() != "")
{
model.flat8 = int.Parse(row["flat8"].ToString());
}
if (row["RegTim1"] != null && row["RegTim1"].ToString() != "")
{
model.RegTim1 = DateTime.Parse(row["RegTim1"].ToString());
}
if (row["RegTim2"] != null && row["RegTim2"].ToString() != "")
{
model.RegTim2 = DateTime.Parse(row["RegTim2"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BrnMall.Core.Model.YX_video model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update YX_video set ");
strSql.Append("EventId=@EventId,");
strSql.Append("videoTitle=@videoTitle,");
strSql.Append("videoDescription=@videoDescription,");
strSql.Append("videoMediaId=@videoMediaId,");
strSql.Append("EventCate=@EventCate,");
strSql.Append("remark1=@remark1,");
strSql.Append("remark2=@remark2,");
strSql.Append("remark3=@remark3,");
strSql.Append("flat1=@flat1,");
strSql.Append("flat2=@flat2,");
strSql.Append("remark4=@remark4,");
strSql.Append("remark5=@remark5,");
strSql.Append("remark6=@remark6,");
strSql.Append("flat7=@flat7,");
strSql.Append("flat8=@flat8,");
strSql.Append("RegTim1=@RegTim1,");
strSql.Append("RegTim2=@RegTim2");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@EventId", SqlDbType.Int, 4),
new SqlParameter("@videoTitle", SqlDbType.NVarChar, 50),
new SqlParameter("@videoDescription", SqlDbType.NVarChar, 1000),
new SqlParameter("@videoMediaId", SqlDbType.VarChar, 500),
new SqlParameter("@EventCate", SqlDbType.VarChar, 50),
new SqlParameter("@remark1", SqlDbType.NVarChar, 500),
new SqlParameter("@remark2", SqlDbType.NVarChar, 500),
new SqlParameter("@remark3", SqlDbType.NText),
new SqlParameter("@flat1", SqlDbType.Int, 4),
new SqlParameter("@flat2", SqlDbType.Int, 4),
new SqlParameter("@remark4", SqlDbType.NVarChar, 50),
new SqlParameter("@remark5", SqlDbType.NVarChar, 50),
new SqlParameter("@remark6", SqlDbType.NText),
new SqlParameter("@flat7", SqlDbType.Int, 4),
new SqlParameter("@flat8", SqlDbType.Int, 4),
new SqlParameter("@RegTim1", SqlDbType.DateTime),
new SqlParameter("@RegTim2", SqlDbType.DateTime),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = model.EventId;
parameters[1].Value = model.videoTitle;
parameters[2].Value = model.videoDescription;
parameters[3].Value = model.videoMediaId;
parameters[4].Value = model.EventCate;
parameters[5].Value = model.remark1;
parameters[6].Value = model.remark2;
parameters[7].Value = model.remark3;
parameters[8].Value = model.flat1;
parameters[9].Value = model.flat2;
parameters[10].Value = model.remark4;
parameters[11].Value = model.remark5;
parameters[12].Value = model.remark6;
parameters[13].Value = model.flat7;
parameters[14].Value = model.flat8;
parameters[15].Value = model.RegTim1;
parameters[16].Value = model.RegTim2;
parameters[17].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}