/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.PaperManage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update PaperManage set ");
strSql.Append("PaperID=@PaperID,");
strSql.Append("CompanyID=@CompanyID,");
strSql.Append("StartTime=@StartTime,");
strSql.Append("EndTime=@EndTime,");
strSql.Append("AuthorUser=@AuthorUser,");
strSql.Append("IsLongTime=@IsLongTime,");
strSql.Append("Num=@Num,");
strSql.Append("CreateDateTime=@CreateDateTime,");
strSql.Append("Title=@Title,");
strSql.Append("Used=@Used,");
strSql.Append("Assigned=@Assigned");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@PaperID", SqlDbType.Int, 4),
new SqlParameter("@CompanyID", SqlDbType.Int, 4),
new SqlParameter("@StartTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@AuthorUser", SqlDbType.VarChar, 20),
new SqlParameter("@IsLongTime", SqlDbType.Bit, 1),
new SqlParameter("@Num", SqlDbType.Int, 4),
new SqlParameter("@CreateDateTime", SqlDbType.DateTime),
new SqlParameter("@Title", SqlDbType.VarChar, 50),
new SqlParameter("@Used", SqlDbType.Int, 4),
new SqlParameter("@Assigned", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.PaperID;
parameters[1].Value = model.CompanyID;
parameters[2].Value = model.StartTime;
parameters[3].Value = model.EndTime;
parameters[4].Value = model.AuthorUser;
parameters[5].Value = model.IsLongTime;
parameters[6].Value = model.Num;
parameters[7].Value = model.CreateDateTime;
parameters[8].Value = model.Title;
parameters[9].Value = model.Used;
parameters[10].Value = model.Assigned;
parameters[11].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.PaperManage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PaperManage(");
strSql.Append("PaperID,CompanyID,StartTime,EndTime,AuthorUser,IsLongTime,Num,CreateDateTime,Title,Used,Assigned)");
strSql.Append(" values (");
strSql.Append("@PaperID,@CompanyID,@StartTime,@EndTime,@AuthorUser,@IsLongTime,@Num,@CreateDateTime,@Title,@Used,@Assigned)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@PaperID", SqlDbType.Int, 4),
new SqlParameter("@CompanyID", SqlDbType.Int, 4),
new SqlParameter("@StartTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@AuthorUser", SqlDbType.VarChar, 20),
new SqlParameter("@IsLongTime", SqlDbType.Bit, 1),
new SqlParameter("@Num", SqlDbType.Int, 4),
new SqlParameter("@CreateDateTime", SqlDbType.DateTime),
new SqlParameter("@Title", SqlDbType.VarChar, 100),
new SqlParameter("@Used", SqlDbType.Int, 4),
new SqlParameter("@Assigned", SqlDbType.Int, 4),
};
parameters[0].Value = model.PaperID;
parameters[1].Value = model.CompanyID;
parameters[2].Value = model.StartTime;
parameters[3].Value = model.EndTime;
parameters[4].Value = model.AuthorUser;
parameters[5].Value = model.IsLongTime;
parameters[6].Value = model.Num;
parameters[7].Value = model.CreateDateTime;
parameters[8].Value = model.Title;
parameters[9].Value = model.Used;
parameters[10].Value = model.Assigned;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.PaperManage GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,PaperID,CompanyID,StartTime,EndTime,AuthorUser,IsLongTime,Num,CreateDateTime,Title,Used,Assigned from PaperManage ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Maticsoft.Model.PaperManage model = new Maticsoft.Model.PaperManage();
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 Maticsoft.Model.PaperManage DataRowToModel(DataRow row)
{
Maticsoft.Model.PaperManage model = new Maticsoft.Model.PaperManage();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["PaperID"] != null && row["PaperID"].ToString() != "")
{
model.PaperID = int.Parse(row["PaperID"].ToString());
}
if (row["CompanyID"] != null && row["CompanyID"].ToString() != "")
{
model.CompanyID = int.Parse(row["CompanyID"].ToString());
}
if (row["StartTime"] != null && row["StartTime"].ToString() != "")
{
model.StartTime = DateTime.Parse(row["StartTime"].ToString());
}
if (row["EndTime"] != null && row["EndTime"].ToString() != "")
{
model.EndTime = DateTime.Parse(row["EndTime"].ToString());
}
if (row["AuthorUser"] != null)
{
model.AuthorUser = row["AuthorUser"].ToString();
}
if (row["IsLongTime"] != null && row["IsLongTime"].ToString() != "")
{
if ((row["IsLongTime"].ToString() == "1") || (row["IsLongTime"].ToString().ToLower() == "true"))
{
model.IsLongTime = true;
}
else
{
model.IsLongTime = false;
}
}
if (row["Num"] != null && row["Num"].ToString() != "")
{
model.Num = int.Parse(row["Num"].ToString());
}
if (row["CreateDateTime"] != null && row["CreateDateTime"].ToString() != "")
{
model.CreateDateTime = DateTime.Parse(row["CreateDateTime"].ToString());
}
if (row["Title"] != null)
{
model.Title = row["Title"].ToString();
}
if (row["Used"] != null && row["Used"].ToString() != "")
{
model.Used = int.Parse(row["Used"].ToString());
}
if (row["Assigned"] != null && row["Assigned"].ToString() != "")
{
model.Assigned = int.Parse(row["Assigned"].ToString());
}
}
return(model);
}
/// <summary>
/// 根据公司id和名称查找指定公司是否存在(不存在则添加并返回id)
/// 判断是否存在试卷权限，不存在添加
/// </summary>
/// <param name="str_ID"></param>
/// <param name="str_companyName"></param>
/// <returns></returns>
private bool GetCompany(string str_ID, string str_companyName)
{
string[] arr_paperID = { "122", "123", "125" }; //试卷id
Maticsoft.BLL.Company BCompany = new Maticsoft.BLL.Company(); //公司
Maticsoft.BLL.PaperManage BPaperManage = new Maticsoft.BLL.PaperManage(); //试卷授权
try
{
List <Maticsoft.Model.Company> listCompany = BCompany.GetModelList(" obj_ID=" + int.Parse(str_ID) + " AND Name='" + str_companyName + "' ");
if (listCompany != null && listCompany.Count > 0)//该公司存在
{
//判断有没有试卷授权
List <Maticsoft.Model.PaperManage> listPaperManage = BPaperManage.GetModelList(" CompanyID=" + listCompany[0].ID + " AND PaperID in(122,123,125)");
if (listPaperManage != null && listPaperManage.Count > 0)//该公司有试卷授权（）
{
List <string> paperID = new List <string>();
for (int i = 0; i < listPaperManage.Count; i++)
{
paperID.Add(listPaperManage[i].PaperID.ToString());//将授权试卷id拿出来
}
List <string> list_paperID = new List <string>(); //保存没有授权试卷id
//判断是否存在122,123,125这三份试卷
for (int i = 0; i < arr_paperID.Length; i++)
{
if (!paperID.Contains(arr_paperID[i]))//判断授权试卷中有没有122,123,125这三份试卷
{
list_paperID.Add(arr_paperID[i]);
}
}
if (list_paperID != null && list_paperID.Count > 0)//如果存在没有授权的则添加
{
for (int j = 0; j < list_paperID.Count; j++)
{
Maticsoft.Model.PaperManage MPaperManage = new Maticsoft.Model.PaperManage();
MPaperManage.PaperID = int.Parse(list_paperID[j].ToString());
MPaperManage.CompanyID = listCompany[0].ID;
MPaperManage.IsLongTime = true;
MPaperManage.CreateDateTime = DateTime.Now;
MPaperManage.Title = listCompany[0].Name + "授权";
MPaperManage.Num = 100;
if (BPaperManage.Add(MPaperManage) <= 0)
{
return(false);
}
}
}
}
else//改公司没有试卷授权
{
for (int j = 0; j < arr_paperID.Length; j++)
{
Maticsoft.Model.PaperManage MPaperManage = new Maticsoft.Model.PaperManage();
MPaperManage.PaperID = int.Parse(arr_paperID[j].ToString());
MPaperManage.CompanyID = listCompany[0].ID;
MPaperManage.IsLongTime = true;
MPaperManage.CreateDateTime = DateTime.Now;
MPaperManage.Title = listCompany[0].Name + "授权";
MPaperManage.Num = 100;
if (BPaperManage.Add(MPaperManage) <= 0)
{
return(false);
}
}
}
}
else//公司不存在(添加)
{
Maticsoft.Model.Company MCompany = new Maticsoft.Model.Company();
MCompany.obj_ID = int.Parse(str_ID);
MCompany.Name = str_companyName;
MCompany.CreateTime = DateTime.Now;
int int_companyid = BCompany.Add(MCompany);
if (int_companyid > 0)//添加成功
{
//添加试卷授权
for (int j = 0; j < arr_paperID.Length; j++)
{
Maticsoft.Model.PaperManage MPaperManage = new Maticsoft.Model.PaperManage();
MPaperManage.PaperID = int.Parse(arr_paperID[j].ToString());
MPaperManage.CompanyID = int_companyid;
MPaperManage.IsLongTime = true;
MPaperManage.CreateDateTime = DateTime.Now;
MPaperManage.Title = str_companyName + "授权";
MPaperManage.Num = 100;
if (BPaperManage.Add(MPaperManage) <= 0)
{
return(false);
}
}
}
else
{
return(false);
}
}
}
catch (Exception)
{
throw;
//return false;
}
return(true);
}
