public int Update(TY_OA_MgrTaskDtlModel ObjModel)
{
int num = 0;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
try
{
num = new TY_OA_MgrTaskDtlBLL().Update(ObjModel, transaction);
transaction.Commit();
}
catch (SqlException exception)
{
transaction.Rollback();
connection.Close();
throw exception;
}
return(num);
}
finally
{
connection.Close();
}
}
return(num);
}
private TY_OA_MgrTaskDtlModel _DataBind(int Code)
{
TY_OA_MgrTaskDtlModel model = new TY_OA_MgrTaskDtlModel();
StringBuilder builder = new StringBuilder();
builder.Append("select * from TY_OA_MgrTaskDtl ");
builder.Append(" where MgrDtlCode=@MgrDtlCode");
this._DataProcess.CommandText = builder.ToString();
this._DataProcess.ProcessParametersAdd("@MgrDtlCode", SqlDbType.Int, 4, Code);
SqlDataReader sqlDataReader = null;
try
{
try
{
sqlDataReader = this._DataProcess.GetSqlDataReader();
while (sqlDataReader.Read())
{
this.Initialize(sqlDataReader, model);
}
}
catch (SqlException exception)
{
throw exception;
}
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
}
return(model);
}
public int ModifyAlreadyAuditing(int Code, SqlTransaction Transaction)
{
TY_OA_MgrTaskDtlModel objModel = this.GetModel(Code, Transaction);
objModel.State = "2";
return(this.Update(objModel, Transaction));
}
/// <summary>
/// 取屏幕明细的List
/// </summary>
/// <returns></returns>
private List <TY_OA_MgrTaskDtlModel> GetScreenDtl()
{
GridView gvDtl = (GridView)this.FormView1.Row.FindControl("GridView1");
DataGrid dgDtl = (DataGrid)this.FormView1.Row.FindControl("dgDtl");
List <TY_OA_MgrTaskDtlModel> Models = (List <TY_OA_MgrTaskDtlModel>)ViewState["Models"];
int i = -1;
if (dgDtl != null)
{
foreach (DataGridItem item in dgDtl.Items)
{
i++;
string DtlCode = dgDtl.DataKeys[i].ToString();
TY_OA_MgrTaskDtlModel mgrObj = Models[i];
mgrObj.MgrDtlInfo = ((HtmlTextArea)item.FindControl("TxtTaskDetail")).Value.ToString();
mgrObj.DeadLine = DateTime.Parse(((AspWebControl.Calendar)item.FindControl("CalendarInDate")).Value);
mgrObj.ResponsePerson = ((RmsPM.Web.UserControls.InputUser)item.FindControl("ResponsePerson")).Value;
mgrObj.Assistpersons = ((InputUsers)item.FindControl("txtteamer")).Value;
}
}
return(Models);
}
private void UpdateMgrTaskDeadLine(DateTime dt)
{
TY_OA_MgrTaskBFL TaskBFL = new TY_OA_MgrTaskBFL();
TY_OA_MgrTaskDtlBFL TaskDtlBFL = new TY_OA_MgrTaskDtlBFL();
TY_OA_MgrTaskDtlModel TaskDtlMdl = TaskDtlBFL.GetTY_OA_MgrTaskDtl(RmsPM.BLL.ConvertRule.ToInt(Request.QueryString["MgrDtlCode"]));
TY_OA_MgrTaskModel TaskMdl = TaskBFL.GetTY_OA_MgrTask(TaskDtlMdl.MgrCodeID);
TaskMdl.DeadLine = dt;
TaskBFL.Update(TaskMdl);
}
/// <summary>
/// 新增明细
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAddDtl_ServerClick(object sender, EventArgs e)
{
List <TY_OA_MgrTaskDtlModel> Models = GetScreenDtl();
TY_OA_MgrTaskDtlModel mgrObj = new TY_OA_MgrTaskDtlModel();
mgrObj.DeadLine = System.DateTime.Now.Date;
Models.Add(mgrObj);
BindDtl(Models);
}
private List <TY_OA_MgrTaskDtlModel> _Select(TY_OA_MgrTaskDtlQueryModel qmObj)
{
List <TY_OA_MgrTaskDtlModel> list = new List <TY_OA_MgrTaskDtlModel>();
StringBuilder builder = new StringBuilder();
builder.Append("select * from TY_OA_MgrTaskDtl ");
builder.Append(qmObj.QueryConditionStr);
if (qmObj.SortColumns.Length == 0)
{
builder.Append(" ORDER BY MgrDtlCode desc");
}
else
{
builder.Append(" ORDER BY " + qmObj.SortColumns);
}
this._DataProcess.CommandText = builder.ToString();
this._DataProcess.SqlParameters = qmObj.Parameters;
SqlDataReader sqlDataReader = null;
int num = 0;
try
{
try
{
sqlDataReader = this._DataProcess.GetSqlDataReader();
while (sqlDataReader.Read())
{
if ((num >= qmObj.StartRecord) && ((list.Count < qmObj.MaxRecords) || (qmObj.MaxRecords == -1)))
{
TY_OA_MgrTaskDtlModel model = new TY_OA_MgrTaskDtlModel();
this.Initialize(sqlDataReader, model);
list.Add(model);
}
num++;
}
}
catch (SqlException exception)
{
throw exception;
}
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
}
return(list);
}
private void Initialize(SqlDataReader reader, TY_OA_MgrTaskDtlModel obj)
{
if (reader.GetValue(0) != DBNull.Value)
{
obj.MgrDtlCode = reader.GetInt32(0);
}
if (reader.GetValue(1) != DBNull.Value)
{
obj.MgrDtlInfo = reader.GetString(1);
}
if (reader.GetValue(2) != DBNull.Value)
{
obj.DeadLine = reader.GetDateTime(2);
}
if (reader.GetValue(3) != DBNull.Value)
{
obj.ResponsePerson = reader.GetString(3);
}
if (reader.GetValue(4) != DBNull.Value)
{
obj.MgrCodeID = reader.GetInt32(4);
}
if (reader.GetValue(5) != DBNull.Value)
{
obj.Assistpersons = reader.GetString(5);
}
if (reader.GetValue(6) != DBNull.Value)
{
obj.TrancRevert = reader.GetString(6);
}
if (reader.GetValue(7) != DBNull.Value)
{
obj.ManagerRevert = reader.GetString(7);
}
if (reader.GetValue(8) != DBNull.Value)
{
obj.Isfinish = reader.GetString(8);
}
if (reader.GetValue(9) != DBNull.Value)
{
obj.State = reader.GetString(9);
}
if (reader.GetValue(10) != DBNull.Value)
{
obj.Bak = reader.GetString(10);
}
}
public TY_OA_MgrTaskDtlModel GetTY_OA_MgrTaskDtl(int Code)
{
TY_OA_MgrTaskDtlModel model = new TY_OA_MgrTaskDtlModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
model = new TY_OA_MgrTaskDtlBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
private int _Insert(TY_OA_MgrTaskDtlModel mObj)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into TY_OA_MgrTaskDtl(");
builder.Append("MgrDtlCode,MgrDtlInfo,DeadLine,ResponsePerson,MgrCodeID,Assistpersons,TrancRevert,ManagerRevert,Isfinish,State,Bak)");
builder.Append(" values (");
builder.Append("@MgrDtlCode,@MgrDtlInfo,@DeadLine,@ResponsePerson,@MgrCodeID,@Assistpersons,@TrancRevert,@ManagerRevert,@Isfinish,@State,@Bak) ");
this._DataProcess.CommandText = builder.ToString();
this._DataProcess.ProcessParametersAdd("@MgrDtlCode", SqlDbType.Int, 4, mObj.MgrDtlCode);
this._DataProcess.ProcessParametersAdd("@MgrDtlInfo", SqlDbType.VarChar, 800, mObj.MgrDtlInfo);
this._DataProcess.ProcessParametersAdd("@DeadLine", SqlDbType.DateTime, 8, mObj.DeadLine);
this._DataProcess.ProcessParametersAdd("@ResponsePerson", SqlDbType.VarChar, 50, mObj.ResponsePerson);
this._DataProcess.ProcessParametersAdd("@MgrCodeID", SqlDbType.Int, 4, mObj.MgrCodeID);
this._DataProcess.ProcessParametersAdd("@Assistpersons", SqlDbType.VarChar, 500, mObj.Assistpersons);
this._DataProcess.ProcessParametersAdd("@TrancRevert", SqlDbType.VarChar, 0x3e8, (mObj.TrancRevert == null) ? "" : mObj.TrancRevert);
this._DataProcess.ProcessParametersAdd("@ManagerRevert", SqlDbType.VarChar, 0x3e8, (mObj.ManagerRevert == null) ? "" : mObj.ManagerRevert);
this._DataProcess.ProcessParametersAdd("@Isfinish", SqlDbType.VarChar, 50, (mObj.Isfinish == null) ? "0" : mObj.Isfinish);
this._DataProcess.ProcessParametersAdd("@State", SqlDbType.VarChar, 50, (mObj.State == null) ? "1" : mObj.State);
this._DataProcess.ProcessParametersAdd("@Bak", SqlDbType.VarChar, 50, (mObj.Bak == null) ? "" : mObj.Bak);
this._DataProcess.RunSql();
return(mObj.MgrDtlCode);
}
private DateTime GetTaskDeadLine()
{
//主表要求完成时间为明细中最晚的那个
DateTime LastDate = new DateTime();
TY_OA_MgrTaskBFL TaskBFL = new TY_OA_MgrTaskBFL();
TY_OA_MgrTaskDtlBFL TaskDtlBFL = new TY_OA_MgrTaskDtlBFL();
TY_OA_MgrTaskDtlModel TaskDtlMdl = TaskDtlBFL.GetTY_OA_MgrTaskDtl(RmsPM.BLL.ConvertRule.ToInt(Request.QueryString["MgrDtlCode"]));
List <TY_OA_MgrTaskDtlModel> TaskDtlMdls = TaskDtlBFL.GetTY_OA_MgrTaskDtlList(TaskDtlMdl.MgrCodeID);
TY_OA_MgrTaskModel TaskMdl = TaskBFL.GetTY_OA_MgrTask(TaskDtlMdl.MgrCodeID);
int i = 0;
foreach (TY_OA_MgrTaskDtlModel SingleTaskMdl in TaskDtlMdls)
{
if (0 == i)
{
LastDate = SingleTaskMdl.DeadLine;
}
else
{
System.TimeSpan ts = LastDate.Subtract(SingleTaskMdl.DeadLine);
if (ts.Days < 0)
{
LastDate = SingleTaskMdl.DeadLine;
}
}
i++;
}
if (TaskMdl.DeadLine == LastDate)
{
LastDate = DateTime.MinValue;
}
return(LastDate);
}
public int Insert(TY_OA_MgrTaskDtlModel ObjModel, SqlTransaction Transaction)
{
TY_OA_MgrTaskDtlDAL ldal = new TY_OA_MgrTaskDtlDAL(Transaction);
return(ldal.Insert(ObjModel));
}
public int Update(TY_OA_MgrTaskDtlModel ObjModel, SqlTransaction Transaction)
{
TY_OA_MgrTaskDtlDAL ldal = new TY_OA_MgrTaskDtlDAL(Transaction);
return(ldal.Update(ObjModel));
}
public int Update(TY_OA_MgrTaskDtlModel mObj)
{
return(this._Update(mObj));
}
public int Insert(TY_OA_MgrTaskDtlModel mObj)
{
return(this._Insert(mObj));
}
public int Delete(TY_OA_MgrTaskDtlModel mObj)
{
return(this._Delete(mObj.MgrDtlCode));
}
private int _Update(TY_OA_MgrTaskDtlModel mObj)
{
StringBuilder builder = new StringBuilder();
builder.Append("update TY_OA_MgrTaskDtl set ");
if (mObj.MgrDtlInfo != null)
{
builder.Append("MgrDtlInfo=@MgrDtlInfo,");
this._DataProcess.ProcessParametersAdd("@MgrDtlInfo", SqlDbType.VarChar, 800, mObj.MgrDtlInfo);
}
if (mObj.DeadLine != DateTime.MinValue)
{
builder.Append("DeadLine=@DeadLine,");
this._DataProcess.ProcessParametersAdd("@DeadLine", SqlDbType.DateTime, 8, mObj.DeadLine);
}
if (mObj.ResponsePerson != null)
{
builder.Append("ResponsePerson=@ResponsePerson,");
this._DataProcess.ProcessParametersAdd("@ResponsePerson", SqlDbType.VarChar, 50, mObj.ResponsePerson);
}
if (mObj.MgrCodeID != 0)
{
builder.Append("MgrCodeID=@MgrCodeID,");
this._DataProcess.ProcessParametersAdd("@MgrCodeID", SqlDbType.Int, 4, mObj.MgrCodeID);
}
if (mObj.Assistpersons != null)
{
builder.Append("Assistpersons=@Assistpersons,");
this._DataProcess.ProcessParametersAdd("@Assistpersons", SqlDbType.VarChar, 500, mObj.Assistpersons);
}
if (mObj.TrancRevert != null)
{
builder.Append("TrancRevert=@TrancRevert,");
this._DataProcess.ProcessParametersAdd("@TrancRevert", SqlDbType.VarChar, 0x3e8, mObj.TrancRevert);
}
if (mObj.ManagerRevert != null)
{
builder.Append("ManagerRevert=@ManagerRevert,");
this._DataProcess.ProcessParametersAdd("@ManagerRevert", SqlDbType.VarChar, 0x3e8, mObj.ManagerRevert);
}
if (mObj.Isfinish != null)
{
builder.Append("Isfinish=@Isfinish,");
this._DataProcess.ProcessParametersAdd("@Isfinish", SqlDbType.VarChar, 50, mObj.Isfinish);
}
if (mObj.State != null)
{
builder.Append("State=@State,");
this._DataProcess.ProcessParametersAdd("@State", SqlDbType.VarChar, 50, mObj.State);
}
if (mObj.Bak != null)
{
builder.Append("Bak=@Bak,");
this._DataProcess.ProcessParametersAdd("@Bak", SqlDbType.VarChar, 50, mObj.Bak);
}
builder.Remove(builder.Length - 1, 1);
builder.Append(" where MgrDtlCode=@MgrDtlCode");
this._DataProcess.ProcessParametersAdd("@MgrDtlCode", SqlDbType.Int, 4, mObj.MgrDtlCode);
this._DataProcess.CommandText = builder.ToString();
return(this._DataProcess.RunSql());
}
