public int Delete(int Code, SqlTransaction Transaction)
{
TY_OA_MgrTaskDAL kdal = new TY_OA_MgrTaskDAL(Transaction);
TY_OA_MgrTaskDtlDAL ldal = new TY_OA_MgrTaskDtlDAL(Transaction);
TY_OA_MgrTaskDtlQueryModel qmObj = new TY_OA_MgrTaskDtlQueryModel();
qmObj.MgrCodeIDEqual = Code;
foreach (TY_OA_MgrTaskDtlModel model2 in ldal.Select(qmObj))
{
ldal.Delete(model2.MgrDtlCode);
}
return(kdal.Delete(Code));
}
public List <TY_OA_MgrTaskDtlModel> GetTY_OA_MgrTaskDtlList(int MgrCodeID)
{
List <TY_OA_MgrTaskDtlModel> list;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
try
{
list = new TY_OA_MgrTaskDtlDAL(connection).GetTY_OA_MgrTaskDtlListByMgrCodeID(MgrCodeID);
}
catch (Exception exception)
{
throw exception;
}
finally
{
connection.Close();
}
}
return(list);
}
public int Insert(TY_OA_MgrTaskDtlModel ObjModel, SqlTransaction Transaction)
{
TY_OA_MgrTaskDtlDAL ldal = new TY_OA_MgrTaskDtlDAL(Transaction);
return(ldal.Insert(ObjModel));
}
public List <TY_OA_MgrTaskDtlModel> GetModels(TY_OA_MgrTaskDtlQueryModel ObjQueryModel, SqlTransaction Transaction)
{
TY_OA_MgrTaskDtlDAL ldal = new TY_OA_MgrTaskDtlDAL(Transaction);
return(ldal.Select(ObjQueryModel));
}
public List <TY_OA_MgrTaskDtlModel> GetModels(SqlTransaction Transaction)
{
TY_OA_MgrTaskDtlDAL ldal = new TY_OA_MgrTaskDtlDAL(Transaction);
return(ldal.Select());
}
public List <TY_OA_MgrTaskDtlModel> GetModels(SqlConnection Connection)
{
TY_OA_MgrTaskDtlDAL ldal = new TY_OA_MgrTaskDtlDAL(Connection);
return(ldal.Select());
}
public TY_OA_MgrTaskDtlModel GetModel(int Code, SqlTransaction Transaction)
{
TY_OA_MgrTaskDtlDAL ldal = new TY_OA_MgrTaskDtlDAL(Transaction);
return(ldal.GetModel(Code));
}
public TY_OA_MgrTaskDtlModel GetModel(int Code, SqlConnection Connection)
{
TY_OA_MgrTaskDtlDAL ldal = new TY_OA_MgrTaskDtlDAL(Connection);
return(ldal.GetModel(Code));
}
public int UpdateTY_OA_MgrTaskDtlList(SqlTransaction Transaction, List <TY_OA_MgrTaskDtlModel> mObjs, int MgrCodeID)
{
try
{
TY_OA_MgrTaskDAL kdal;
TY_OA_MgrTaskModel mObj;
TY_OA_MgrTaskDtlDAL ldal = new TY_OA_MgrTaskDtlDAL(Transaction);
bool flag = false;
bool flag2 = false;
List <TY_OA_MgrTaskDtlModel> list = ldal.GetTY_OA_MgrTaskDtlListByMgrCodeID(MgrCodeID);
foreach (TY_OA_MgrTaskDtlModel model in list)
{
if (FindModel(mObjs, model.MgrDtlCode.ToString()) == null)
{
flag2 = true;
ldal.Delete(model.MgrDtlCode);
}
}
foreach (TY_OA_MgrTaskDtlModel model in mObjs)
{
if (model.MgrDtlCode <= 0)
{
model.MgrDtlCode = int.Parse(SystemManageDAO.GetNewSysCode("MgrDtlCode"));
flag = true;
model.MgrCodeID = MgrCodeID;
ldal.Insert(model);
}
else
{
ldal.Update(model);
}
}
if (flag2)
{
bool flag3 = true;
List <TY_OA_MgrTaskDtlModel> list2 = ldal.GetTY_OA_MgrTaskDtlListByMgrCodeID(MgrCodeID);
foreach (TY_OA_MgrTaskDtlModel model in list2)
{
if (model.State != "3")
{
flag3 = false;
break;
}
}
if (flag3)
{
kdal = new TY_OA_MgrTaskDAL(Transaction);
mObj = kdal.GetModel(MgrCodeID);
mObj.State = "3";
kdal.Update(mObj);
}
}
if (flag)
{
kdal = new TY_OA_MgrTaskDAL(Transaction);
mObj = kdal.GetModel(MgrCodeID);
mObj.State = "1";
kdal.Update(mObj);
}
}
catch (Exception exception)
{
throw exception;
}
return(1);
}
public int Update(TY_OA_MgrTaskDtlModel ObjModel, SqlTransaction Transaction)
{
TY_OA_MgrTaskDtlDAL ldal = new TY_OA_MgrTaskDtlDAL(Transaction);
return(ldal.Update(ObjModel));
}
public int Delete(int Code, SqlTransaction Transaction)
{
TY_OA_MgrTaskDtlDAL ldal = new TY_OA_MgrTaskDtlDAL(Transaction);
return(ldal.Delete(Code));
}