/// <summary>
/// 自评更新（事务） 核准更新
/// </summary>
/// <returns></returns>
public bool Update(string BillID)
{
bool result = false;
int index = 0;
try
{
FrameReviewEntity1.GenerateObjectFromRequest("");
List <EntityBase> listUpdate = new List <EntityBase>();
listUpdate.Add(FrameReviewEntity1);
FrameReviewSaveEntity FrameReviewScoreEntity1 = null;
foreach (var key in HttpContext.Current.Request.Form.AllKeys)
{
if (key.StartsWith("atxt") && key.EndsWith("rowNo"))
{
index = int.Parse(key.Replace("atxt", "").Replace("rowNo", ""));
FrameReviewScoreEntity1 = new FrameReviewSaveEntity();
FrameReviewScoreEntity1.GenerateObjectFromRequest("self" + index);
FrameReviewScoreEntity1.FrameReviewID = BillID;
FrameReviewScoreEntity1.CreateDate = DateTime.Now;
FrameReviewScoreEntity1.IsSelf = 1;
FrameReviewScoreEntity1.ReviewerID = FrameReviewEntity1.CreateMan;
if (FrameReviewScoreEntity1.ReviewResult != 0)
{
FrameReviewScoreEntity1.ReviewResult = 1;
}
else
{
}
if (FrameReviewScoreEntity1.ID > 0)
{
FrameReviewScoreEntity1.IsGenerateObject = true;//这是更新,指定主键存在的意义之二，根据主键来更新与保存数据（）唯一确定一条记录
}
else
{
FrameReviewScoreEntity1.IsGenerateObject = false;//这是插入
}
listUpdate.Add(FrameReviewScoreEntity1);
}
}
result = FrameReviewEntity1.db.CommitTran(listUpdate.ToArray());
}
catch (Exception e)
{
result = false;
}
return(result);
}
/// <summary>
/// 他评更新（事务）
/// </summary>
/// <returns></returns>
public bool UpdateReview(string Reviewer)
{
bool result = false;
int index = 0;
decimal?i = 0;
FrameReviewScoreEntity = new V_FrameReviewScoreShowEntity();
FrameReviewScoreEntity.PageSize = 0;//设置返回数据，即集合变量的大小，为0则放回全部数据
FrameReviewScoreEntity.ResetForSearch();
FrameReviewScoreEntity.FrameReviewID = FrameReviewEntity1.FrameReviewID;
FrameReviewScoreList = FrameReviewScoreEntity.ToList <V_FrameReviewScoreShowEntity>();
foreach (var s in FrameReviewScoreList)
{
if (string.IsNullOrEmpty(s.Reviewer))
{
Isexist = 0;
break;
}
else if (s.Reviewer == Reviewer)
{
Isexist = 1;
break;
}
else
{
Isexist = 2;//这里要改
}
}
try
{
List <EntityBase> listUpdate = new List <EntityBase>();
//分数明细表更新
FrameReviewSaveEntity FrameReviewScoreEntity1 = null;
foreach (var key in HttpContext.Current.Request.Form.AllKeys)
{
if (key.StartsWith("atxt") && key.EndsWith("rowNo"))
{
index = int.Parse(key.Replace("atxt", "").Replace("rowNo", ""));
FrameReviewScoreEntity1 = new FrameReviewSaveEntity();
FrameReviewScoreEntity1.ResetForSearch();
FrameReviewScoreEntity1.GenerateObjectFromRequest("other" + index);
FrameReviewScoreEntity1.FrameReviewID = FrameReviewEntity1.FrameReviewID;
FrameReviewScoreEntity1.CreateDate = DateTime.Now;
FrameReviewScoreEntity1.IsSelf = 0;
FrameReviewScoreEntity1.ReviewerID = Reviewer;
if (FrameReviewScoreEntity1.ReviewResult != 0)
{
FrameReviewScoreEntity1.ReviewResult = 1;
}
i = i + Convert.ToInt16(FrameReviewScoreEntity1.ReviewResult); //统计出了总分数
if (Isexist == 1)
{
FrameReviewScoreEntity1.IsGenerateObject = true; //更新
}
else
{
FrameReviewScoreEntity1.ID = null;//标识列不为空导致更新失败，还不报错
FrameReviewScoreEntity1.IsGenerateObject = false;
}
listUpdate.Add(FrameReviewScoreEntity1);
}
}
decimal?passrate = i / listUpdate.Count;
//主表更新
FrameReviewEntity1.GenerateObjectFromRequest("");
listUpdate.Add(FrameReviewEntity1);
//计算通过率，更新评分人评分表
FrameReviewerShowEntity = new FrameReviewerEntity();
FrameReviewerShowEntity.ResetForSearch();
FrameReviewerShowEntity.GenerateObjectFromRequest("Review");
FrameReviewerShowEntity.FrameReviewID = FrameReviewEntity1.FrameReviewID;
FrameReviewerShowEntity.PassingRate = passrate;
FrameReviewerShowEntity.Reviewer = Reviewer;
FrameReviewerShowEntity.ReviewDate = DateTime.Now;
if (Isexist == 1)
{
FrameReviewerShowEntity.IsGenerateObject = true;
}
else
{
FrameReviewerShowEntity.IsGenerateObject = false;
}
listUpdate.Add(FrameReviewerShowEntity);
result = FrameReviewEntity1.db.CommitTran(listUpdate.ToArray());
}
catch (Exception e)
{
result = false;
}
return(result);
}
