/// <summary>
/// 得到一个对象实体
/// </summary>
public AMS.Model.AMS_IssureList GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,CommandType,CommandID,SchoolID,SubmitTime,GetTime,CompleteTime,OperatorID,Flag from AMS_IssureList ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
AMS.Model.AMS_IssureList model = new AMS.Model.AMS_IssureList();
DataSet ds = DbHelperSQL.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]["CommandType"] != null && ds.Tables[0].Rows[0]["CommandType"].ToString() != "")
{
model.CommandType = (AMS.Model.Enum.IsureCommandType) int.Parse(ds.Tables[0].Rows[0]["CommandType"].ToString());
}
if (ds.Tables[0].Rows[0]["CommandID"] != null && ds.Tables[0].Rows[0]["CommandID"].ToString() != "")
{
model.CommandID = int.Parse(ds.Tables[0].Rows[0]["CommandID"].ToString());
}
if (ds.Tables[0].Rows[0]["SchoolID"] != null && ds.Tables[0].Rows[0]["SchoolID"].ToString() != "")
{
model.SchoolID = int.Parse(ds.Tables[0].Rows[0]["SchoolID"].ToString());
}
if (ds.Tables[0].Rows[0]["SubmitTime"] != null && ds.Tables[0].Rows[0]["SubmitTime"].ToString() != "")
{
model.SubmitTime = DateTime.Parse(ds.Tables[0].Rows[0]["SubmitTime"].ToString());
}
if (ds.Tables[0].Rows[0]["GetTime"] != null && ds.Tables[0].Rows[0]["GetTime"].ToString() != "")
{
model.GetTime = DateTime.Parse(ds.Tables[0].Rows[0]["GetTime"].ToString());
}
if (ds.Tables[0].Rows[0]["CompleteTime"] != null && ds.Tables[0].Rows[0]["CompleteTime"].ToString() != "")
{
model.CompleteTime = DateTime.Parse(ds.Tables[0].Rows[0]["CompleteTime"].ToString());
}
if (ds.Tables[0].Rows[0]["OperatorID"] != null && ds.Tables[0].Rows[0]["OperatorID"].ToString() != "")
{
model.OperatorID = int.Parse(ds.Tables[0].Rows[0]["OperatorID"].ToString());
}
if (ds.Tables[0].Rows[0]["Flag"] != null && ds.Tables[0].Rows[0]["Flag"].ToString() != "")
{
model.Flag = int.Parse(ds.Tables[0].Rows[0]["Flag"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(AMS.Model.AMS_IssureList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update AMS_IssureList set ");
strSql.Append("CommandType=@CommandType,");
strSql.Append("CommandID=@CommandID,");
strSql.Append("SchoolID=@SchoolID,");
strSql.Append("SubmitTime=@SubmitTime,");
strSql.Append("GetTime=@GetTime,");
strSql.Append("CompleteTime=@CompleteTime,");
strSql.Append("OperatorID=@OperatorID,");
strSql.Append("Flag=@Flag");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@CommandType", SqlDbType.Int, 4),
new SqlParameter("@CommandID", SqlDbType.Int, 4),
new SqlParameter("@SchoolID", SqlDbType.Int, 4),
new SqlParameter("@SubmitTime", SqlDbType.DateTime),
new SqlParameter("@GetTime", SqlDbType.DateTime),
new SqlParameter("@CompleteTime", SqlDbType.DateTime),
new SqlParameter("@OperatorID", SqlDbType.Int, 4),
new SqlParameter("@Flag", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.CommandType;
parameters[1].Value = model.CommandID;
parameters[2].Value = model.SchoolID;
parameters[3].Value = model.SubmitTime;
parameters[4].Value = model.GetTime;
parameters[5].Value = model.CompleteTime;
parameters[6].Value = model.OperatorID;
parameters[7].Value = model.Flag;
parameters[8].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(AMS.Model.AMS_IssureList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into AMS_IssureList(");
strSql.Append("CommandType,CommandID,SchoolID,SubmitTime,GetTime,CompleteTime,OperatorID,Flag)");
strSql.Append(" values (");
strSql.Append("@CommandType,@CommandID,@SchoolID,@SubmitTime,@GetTime,@CompleteTime,@OperatorID,@Flag)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CommandType", SqlDbType.Int, 4),
new SqlParameter("@CommandID", SqlDbType.Int, 4),
new SqlParameter("@SchoolID", SqlDbType.Int, 4),
new SqlParameter("@SubmitTime", SqlDbType.DateTime),
new SqlParameter("@GetTime", SqlDbType.DateTime),
new SqlParameter("@CompleteTime", SqlDbType.DateTime),
new SqlParameter("@OperatorID", SqlDbType.Int, 4),
new SqlParameter("@Flag", SqlDbType.Int, 4)
};
parameters[0].Value = (int)model.CommandType;
parameters[1].Value = model.CommandID;
parameters[2].Value = model.SchoolID;
parameters[3].Value = model.SubmitTime;
parameters[4].Value = model.GetTime;
parameters[5].Value = model.CompleteTime;
parameters[6].Value = model.OperatorID;
parameters[7].Value = model.Flag;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public AMS.Model.AMS_IssureList GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 from AMS_IssureList ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
AMS.Model.AMS_IssureList model = new AMS.Model.AMS_IssureList();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 添加命令
/// </summary>
/// <param name="command"></param>
/// <param name="schoolIDList"></param>
/// <returns></returns>
public bool AddCommand(AMS.Model.AMS_IssureList command, List <int> schoolIDList)
{
try
{
command.SubmitTime = DateTime.Now;
if (command.CommandType == Model.Enum.IsureCommandType.Advertisement)
{
AMS.Model.AMS_Advertisement adModel = GetSingleAdvertisement(command.CommandID);
{
if (adModel != null)
{
foreach (int school in schoolIDList)
{
AMS.Model.AMS_AdvertisementSchoolCopy copy = new Model.AMS_AdvertisementSchoolCopy();
copy.AdContent = adModel.AdContent;
copy.CustomerID = adModel.CustomerID;
copy.EffectDate = adModel.EffectDate;
copy.EndDate = adModel.EndDate;
copy.Name = adModel.Name;
copy.Num = adModel.Num;
copy.OperatorID = adModel.OperatorID;
copy.OriginalID = adModel.ID;
copy.SchoolID = school;
copy.Type = adModel.Type;
AMS.Model.AMS_AdvertisementSchoolCopy sameCopy = GetSameSchoolAdvert(school, adModel.ID);
int copyID = 0;
if (sameCopy != null)
{
copy.ID = sameCopy.ID;
copyID = sameCopy.ID;
if (!dal_advertisementcopy.Update(copy))
{
return(false);
}
}
else
{
copyID = dal_advertisementcopy.Add(copy);
}
if (copyID < 1)
{
return(false);
}
else
{
command.SchoolID = school;
command.CommandID = copyID;
if (dal_issurelist.Add(command) < 1)
{
return(false);
}
}
}
}
}
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
