/// <summary>
/// 改变操作状态
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool ChangeState(OfficeDocItem model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update OA_OfficeDocItem set ");
strSql.Append("Opinion=@Opinion,");
strSql.Append("state=@state,");
strSql.Append("OperateTime=@OperateTime");
strSql.Append(" where OfficeDocItemID=@OfficeDocItemID ");
SqlParameter[] parameters =
{
new SqlParameter("@Opinion", SqlDbType.NVarChar, 500),
new SqlParameter("@state", SqlDbType.Char, 1),
new SqlParameter("@OperateTime", SqlDbType.DateTime),
new SqlParameter("@OfficeDocItemID", SqlDbType.VarChar, 36)
};
parameters[0].Value = model.Opinion;
parameters[1].Value = model.state;
parameters[2].Value = model.OperateTime;
parameters[3].Value = model.OfficeDocItemID;
int rows = DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 新增公文
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddOfficeDoc(OfficeDoc model, IList <OfficeDocItem> list)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OA_OfficeDoc(");
strSql.Append("OfficeDocID,Title,Contents,WriterID,WriteTime)");
strSql.Append(" values (");
strSql.Append("@OfficeDocID,@Title,@Contents,@WriterID,@WriteTime)");
SqlParameter[] parameters =
{
new SqlParameter("@OfficeDocID", SqlDbType.VarChar, 36),
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@Contents", SqlDbType.Text),
new SqlParameter("@WriterID", SqlDbType.VarChar, 36),
new SqlParameter("@WriteTime", SqlDbType.DateTime)
};
parameters[0].Value = model.OfficeDocID;
parameters[1].Value = model.Title;
parameters[2].Value = model.Contents;
parameters[3].Value = model.WriterID;
parameters[4].Value = model.WriteTime;
IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString);
try
{
DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
OfficeDocItemDAL itemBll = new OfficeDocItemDAL();
for (int i = 0; i < list.Count; i++)
{
OfficeDocItem item = list[i] as OfficeDocItem;
itemBll.AddOfficeDocItem(item);
}
transaction.Commit();
}
catch
{
transaction.Rollback();
}
return(1);
}
/// <summary>
/// 新增公文行
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddOfficeDocItem(OfficeDocItem model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OA_OfficeDocItem(");
strSql.Append("OfficeDocItemID,OfficeDocID,ReceiverID,OperateType,state)");
strSql.Append(" values (");
strSql.Append("@OfficeDocItemID,@OfficeDocID,@ReceiverID,@OperateType,@state)");
SqlParameter[] parameters =
{
new SqlParameter("@OfficeDocItemID", SqlDbType.VarChar, 36),
new SqlParameter("@OfficeDocID", SqlDbType.VarChar, 36),
new SqlParameter("@ReceiverID", SqlDbType.VarChar, 36),
new SqlParameter("@OperateType", SqlDbType.Char, 1),
new SqlParameter("@state", SqlDbType.Char, 1)
};
parameters[0].Value = model.OfficeDocItemID;
parameters[1].Value = model.OfficeDocID;
parameters[2].Value = model.ReceiverID;
parameters[3].Value = model.OperateType;
parameters[4].Value = model.state;
return(DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters));
}
/// <summary>
/// 获取办理公文模型
/// </summary>
/// <param name="OfficeDocItemID"></param>
/// <returns></returns>
public OfficeDocItem GetModel(string OfficeDocItemID)
{
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat("select top 1 B.*,A.Title,A.Contents,A.WriterID,A.WriteTime,U.UserName from OA_OfficeDoc A ");
strSql.AppendFormat(" inner join OA_OfficeDocItem B on A.OfficeDocID=B.OfficeDocID ");
strSql.AppendFormat(" left join OA_User U on U.UserID=A.WriterID where OfficeDocItemID = '{0}' ", OfficeDocItemID);
SqlParameter[] parameters =
{
new SqlParameter("@OfficeDocItemID", SqlDbType.VarChar, 36)
};
parameters[0].Value = OfficeDocItemID;
OfficeDocItem model = new OfficeDocItem();
DataSet ds = DBAccess.ExecuteDataset(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["OfficeDocItemID"] != null && ds.Tables[0].Rows[0]["OfficeDocItemID"].ToString() != "")
{
model.OfficeDocItemID = ds.Tables[0].Rows[0]["OfficeDocItemID"].ToString();
}
if (ds.Tables[0].Rows[0]["OfficeDocID"] != null && ds.Tables[0].Rows[0]["OfficeDocID"].ToString() != "")
{
model.OfficeDocID = ds.Tables[0].Rows[0]["OfficeDocID"].ToString();
}
if (ds.Tables[0].Rows[0]["ReceiverID"] != null && ds.Tables[0].Rows[0]["ReceiverID"].ToString() != "")
{
model.ReceiverID = ds.Tables[0].Rows[0]["ReceiverID"].ToString();
}
if (ds.Tables[0].Rows[0]["Opinion"] != null && ds.Tables[0].Rows[0]["Opinion"].ToString() != "")
{
model.Opinion = ds.Tables[0].Rows[0]["Opinion"].ToString();
}
if (ds.Tables[0].Rows[0]["OperateType"] != null && ds.Tables[0].Rows[0]["OperateType"].ToString() != "")
{
model.OperateType = ds.Tables[0].Rows[0]["OperateType"].ToString();
}
if (ds.Tables[0].Rows[0]["state"] != null && ds.Tables[0].Rows[0]["state"].ToString() != "")
{
model.state = ds.Tables[0].Rows[0]["state"].ToString();
}
if (ds.Tables[0].Rows[0]["OperateTime"] != null && ds.Tables[0].Rows[0]["OperateTime"].ToString() != "")
{
model.OperateTime = DateTime.Parse(ds.Tables[0].Rows[0]["OperateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["Title"] != null && ds.Tables[0].Rows[0]["Title"].ToString() != "")
{
model.Title = ds.Tables[0].Rows[0]["Title"].ToString();
}
if (ds.Tables[0].Rows[0]["Contents"] != null && ds.Tables[0].Rows[0]["Contents"].ToString() != "")
{
model.Contents = ds.Tables[0].Rows[0]["Contents"].ToString();
}
if (ds.Tables[0].Rows[0]["WriterID"] != null && ds.Tables[0].Rows[0]["WriterID"].ToString() != "")
{
model.WriterID = ds.Tables[0].Rows[0]["WriterID"].ToString();
}
if (ds.Tables[0].Rows[0]["WriteTime"] != null && ds.Tables[0].Rows[0]["WriteTime"].ToString() != "")
{
model.WriteTime = DateTime.Parse(ds.Tables[0].Rows[0]["WriteTime"].ToString());
}
if (ds.Tables[0].Rows[0]["UserName"] != null && ds.Tables[0].Rows[0]["UserName"].ToString() != "")
{
model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 改变操作状态
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool ChangeState(OfficeDocItem model)
{
return(iOfficeDocItemDAL.ChangeState(model));
}