public static int ADD(CriterionModel CM)
{
object obj2 = string.Concat(new object[] { " insert EPM_Datum_Criterion values ('", CM.CriterionCode, "','", CM.CriterionName, "', " });
string str2 = string.Concat(new object[] { obj2, " '", CM.PublishYhdm, "','", CM.PublishDate, "','", CM.Publisher, "', " });
return(publicDbOpClass.ExecSqlString(str2 + " '" + CM.Remark + "','" + CM.Flage + "')"));
}
public int Add(CriterionModel CM)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into EPM_Datum_Criterion(");
stringBuilder.Append("CriterionCode,CriterionName,PublishYhdm,PublishDate,Publisher,Remark,DatumClass)");
stringBuilder.Append(" values (");
stringBuilder.Append("@CriterionCode,@CriterionName,@PublishYhdm,@PublishDate,@Publisher,@Remark,@DatumClass)");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@CriterionCode", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@CriterionName", SqlDbType.VarChar, 100),
new SqlParameter("@PublishYhdm", SqlDbType.Char, 10),
new SqlParameter("@PublishDate", SqlDbType.DateTime),
new SqlParameter("@Publisher", SqlDbType.VarChar, 100),
new SqlParameter("@Remark", SqlDbType.Text),
new SqlParameter("@DatumClass", SqlDbType.Int, 4)
};
array[0].Value = CM.CriterionCode;
array[1].Value = CM.CriterionName;
array[2].Value = CM.PublishYhdm;
array[3].Value = CM.PublishDate;
array[4].Value = CM.Publisher;
array[5].Value = CM.Remark;
array[6].Value = CM.Flage;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, stringBuilder.ToString(), array));
}
public static int Update(CriterionModel CM)
{
string str2 = " update EPM_Datum_Criterion set CriterionName = '" + CM.CriterionName + "',";
object obj2 = (str2 + " Publisher = '" + CM.Publisher + "',Remark = '" + CM.Remark + "',") + "DatumClass = " + CM.Flage;
return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj2, " where CriterionCode = '", CM.CriterionCode, "'" })));
}
/// <summary>
///
/// </summary>
/// <param name="issueId">issue id</param>
/// <param name="userId">user who is performing operation</param>
/// <returns>list of criteria</returns>
public List <CriterionModel> GetIssueCrtieria(int issueId, int userId)
{
CriterionModel cm = new CriterionModel();
List <CriterionModel> list = cm.ToModelList(CriterionOp.GetIssueCriterions(issueId, userId), cm);
return(list);
}
public async Task <ActionResult> CreateCriterion(CriterionMvcModel model)
{
if (ModelState.IsValid)
{
ICriterionModel _criterion = new CriterionModel {
ChoiceID = (Guid)Session["ChoiceID"], CriteriaName = model.CriteriaName
};
var status = await _criterionService.AddAsync(_criterion);
var caltcomps = await _alternativeComparisonService.GetUnfilledAsync((Guid)Session["ChoiceID"]);
if (caltcomps.Any())
{
Session["AnyUnfilledAlt"] = true;
}
else
{
Session["AnyUnfilledAlt"] = false;
}
var critcomps = await _criteriaComparisonService.GetUnfilledAsync((Guid)Session["ChoiceID"]);
if (critcomps.Any())
{
Session["AnyUnfilledCrit"] = true;
}
else
{
Session["AnyUnfilledCrit"] = false;
}
return(RedirectToAction("ListCriteria", "Criterion", new { page = Session["Page"] }));
}
return(View());
}
/// <summary>
/// insert or update
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void InsertOrUpdate(object sender, DirectEventArgs e)
{
try
{
// init entity
var model = new CriterionModel();
// check id
if (!string.IsNullOrEmpty(hdfId.Text) && Convert.ToInt32(hdfId.Text) > 0)
{
var result = CriterionController.GetById(Convert.ToInt32(hdfId.Text));;
if (result != null)
{
model = result;
}
}
// set new props for entity
model.Code = txtName.Text.ToUpperString();
model.ValueType = (KpiValueType)Enum.Parse(typeof(KpiValueType), hdfValueType.Text);
model.Name = txtName.Text;
model.Description = txtDescription.Text;
model.Formula = txtFormula.Text;
model.Order = !string.IsNullOrEmpty(txtOrder.Text) ? Convert.ToInt32(txtOrder.Text) : 0;
model.Status = chkIsActive.Checked ? KpiStatus.Active : KpiStatus.Locked;
model.FormulaRange = hdfFormulaRange.Text;
// check entity id
if (model.Id > 0)
{
model.EditedDate = DateTime.Now;
model.EditedBy = CurrentUser.User.UserName;
// update
CriterionController.Update(model);
}
else
{
model.CreatedBy = CurrentUser.User.UserName;
model.CreatedDate = DateTime.Now;
model.EditedDate = DateTime.Now;
model.EditedBy = "";
// insert
CriterionController.Create(model);
}
// hide window
wdSetting.Hide();
//reset form
ResetForm();
// reload data
gpCriterion.Reload();
}
catch (Exception exception)
{
Dialog.ShowError(exception);
}
}
/// <summary>
/// updates criteria of an issue
/// </summary>
/// <param name="updatedCriteria">new and old criteria who is updated</param>
/// <param name="deletedCriteria">deleted criteria</param>
/// <param name="userId">user who is performing this operation</param>
public void UpdateCriteria(List <CriterionModel> updatedCriteria, List <int> deletedCriteria, int userId)
{
CriterionModel cm = new CriterionModel();
List <Criterion> updateList = cm.ToEntityList(updatedCriteria.Where(x => x.Id > 0).ToList());
List <Criterion> addedList = cm.ToEntityList(updatedCriteria.Where(x => x.Id == -1).ToList());
CriterionOp.DeleteCriterions(deletedCriteria, userId);
CriterionOp.UpdateCriterions(updateList, userId);
CriterionOp.AddCriterions(addedList, userId);
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <param name="criterion"></param>
/// <param name="groupId"></param>
private static void GetValueCriterionWorkbook(EvaluationModel model, CriterionModel criterion, int?groupId)
{
var empArgument =
EmployeeArgumentController.GetAll(null, null, groupId, model.RecordId, model.Month, model.Year, null, null);
var workbook = new WorkBook {
AutoCalc = false
};
foreach (var argument in empArgument)
{
switch (argument.ValueType)
{
case KpiValueType.String:
workbook.setText($"{argument.ArgumentCalculateCode}1", argument.Value);
break;
case KpiValueType.Number:
workbook.setNumber($"{argument.ArgumentCalculateCode}1",
double.TryParse(argument.Value, out var parseResultNumber) ? parseResultNumber : 0);
break;
case KpiValueType.Percent:
workbook.setFormula($"{argument.ArgumentCalculateCode}1",
double.TryParse(argument.Value, out var parseResultPercent) ? $"{parseResultPercent} * 0.01" : "0");
break;
case KpiValueType.Formula:
workbook.setFormula($"{argument.ArgumentCalculateCode}1", argument.Value.TrimStart('='));
break;
}
}
workbook.setFormula("A1", criterion.Formula.TrimStart('='));
workbook.recalc();
switch (criterion.ValueType)
{
case KpiValueType.Number:
model.Value = workbook.getNumber("A1").ToString("#,##0.##");
break;
case KpiValueType.Percent:
model.Value = (workbook.getNumber("A1") * 100).ToString("0.00");
break;
default:
model.Value = workbook.getText("A1");
break;
}
}
/// <summary>
/// returns all criteria of an issue
/// </summary>
/// <param name="issueId"></param>
/// <param name="userId">user who is performing this operation</param>
/// <returns></returns>
public List <CriterionModel> GetIssueCriteria(int issueId, int userId)
{
CriterionModel cm = new CriterionModel();
List <CriterionModel> cmList = cm.ToModelList(CriterionOp.GetIssueCriterions(issueId, userId), cm);
List <CommentModel> comments = GetComments(issueId, userId);
foreach (CriterionModel model in cmList)
{
model.Comments = comments.Where(x => x.Type == "Criterion" + model.Id).ToList();
}
return(cmList);
}
public Criterion(string name, object value, CriterionType type, CriterionModel model)
{
ThrowExceptionUtil.ArgumentNotNullOrEmpty("name", name);
// 若是Enum， 转换成数字匹配
if (value is Enum)
{
value = (int)value;
}
this.leftExpression = name;
this.value = value;
this.criterionType = type;
this.criterionModel = model;
}
protected void Btn_Save_Click(object sender, EventArgs e)
{
if (this.TxtPublisher.Text == "")
{
base.RegisterScript("top.ui.alert('发布单位不能为空');");
return;
}
if (this.txtClass.Text == "")
{
base.RegisterScript("top.ui.alert('记录类型不能为空');");
return;
}
if (this.TxtCriterionName.Text == "")
{
base.RegisterScript("top.ui.alert('规范名称不能为空');");
return;
}
CriterionModel cM = new CriterionModel();
cM = this.GetValueFromPage();
if (base.Request.QueryString["Type"] == "Add")
{
int num = this.Add(cM);
if (num != 1)
{
base.RegisterScript("top.ui.alert('增加失败');");
return;
}
base.RegisterScript("top.ui.tabSuccess({parentName: '_criterionlist'});");
return;
}
else
{
if (CriterionAction.Update(cM) != 1)
{
base.RegisterScript("top.ui.alert('修改失败');");
return;
}
base.RegisterScript("top.ui.tabSuccess({parentName: '_criterionlist'});");
return;
}
}
private void SetValueFromTable()
{
CriterionModel criterionModel = new CriterionModel();
criterionModel = CriterionAction.GetSingle(new Guid(this.Session["CriterionCODE"].ToString()));
DataTable type = DatumClass.GetType(criterionModel.Flage.ToString());
if (type != null && type.Rows.Count > 0)
{
foreach (DataRow dataRow in type.Rows)
{
object obj = dataRow["TypeName"];
if (obj != null)
{
this.txtClass.Text = dataRow["TypeName"].ToString();
}
}
}
this.PublisherYhmc.Text = com.jwsoft.pm.entpm.PageHelper.QueryUser(this, criterionModel.PublishYhdm.Trim());
this.TxtCriterionName.Text = criterionModel.CriterionName;
if (CriterionEdit.IsNumber(criterionModel.Publisher))
{
this.TxtPublisher.Text = com.jwsoft.pm.entpm.PageHelper.QueryDept(this, Convert.ToInt32(criterionModel.Publisher));
}
this.Textbox1.Text = criterionModel.Remark;
this.hdnClass.Value = KnowledgeTypeAction.GetSingleType(criterionModel.Flage).TypeName;
this.hdnDept.Value = criterionModel.Publisher.ToString();
CriterionLogic criterionLogic = new CriterionLogic();
DataTable dtModelByID = criterionLogic.getDtModelByID(criterionModel.CriterionCode.ToString());
foreach (DataRow dataRow2 in dtModelByID.Rows)
{
if (dataRow2["mark"].ToString() == "3")
{
this.HiddenField1.Value = "3";
}
string value = dataRow2["mark"].ToString();
this.hdnmark.Value = value;
}
}
/// <summary>
/// notifie clients to update criteria
/// </summary>
/// <param name="criteria">list of criteria </param>
/// <param name="user">user who is perform</param>
public void UpdateCriteria(CriterionModel criteria, UserShortModel user, int issueId)
{
Clients.All.updateCriteria(criteria, user, issueId);
}
