/// <summary>
/// 設定標單品項查詢條件
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult ManageProjectItem(string id)
{
//傳入專案編號，
InquiryFormService service = new InquiryFormService();
logger.Info("start project id=" + id);
//取得專案基本資料fc
TND_PROJECT p = service.getProjectById(id);
ViewBag.id = p.PROJECT_ID;
ViewBag.projectName = p.PROJECT_NAME;
SelectListItem empty = new SelectListItem();
empty.Value = "";
empty.Text = "";
List <SelectListItem> selectMain = UtilService.getMainSystem(id, service);
// selectMain.Add(empty);
ViewBag.SystemMain = selectMain;
List <SelectListItem> selectSub = UtilService.getSubSystem(id, service);
//selectSub.Add(empty);
ViewBag.SystemSub = selectSub;
//設定查詢條件
return(View());
}
/// <summary>
/// Project_item 註記刪除
/// </summary>
/// <param name="itemid"></param>
/// <returns></returns>
public String delProjectItem(string itemid)
{
InquiryFormService service = new InquiryFormService();
string msg = "更新成功!!";
logger.Info("del project item by id=" + itemid);
int i = service.changeProjectItem(itemid, "Y");
return(msg + "(" + i + ")");
}
/// <summary>
/// 取得標單品項詳細資料
/// </summary>
/// <param name="itemid"></param>
/// <returns></returns>
public string getProjectItem(string itemid)
{
InquiryFormService service = new InquiryFormService();
logger.Info("get project item by id=" + itemid);
//TND_PROJECT_ITEM item = service.getProjectItem.getUser(userid);
System.Web.Script.Serialization.JavaScriptSerializer objSerializer = new System.Web.Script.Serialization.JavaScriptSerializer();
string itemJson = objSerializer.Serialize(service.getProjectItem(itemid));
logger.Info("project item info=" + itemJson);
return(itemJson);
}
/// <summary>
/// 取得標單明細資料
/// </summary>
/// <param name="form"></param>
/// <returns></returns>
public ActionResult ShowProejctItems(FormCollection form)
{
InquiryFormService service = new InquiryFormService();
logger.Info("start project id=" + Request["id"] + ",TypeCode1=" + Request["typeCode1"] + ",typecode2=" + Request["typeCode2"] + ",SystemMain=" + Request["SystemMain"] + ",Sytem Sub=" + Request["SystemSub"]);
logger.Debug("Exception check=" + Request["chkEx"]);
List <TND_PROJECT_ITEM> lstItems = service.getProjectItem(Request["chkEx"], Request["id"], Request["typeCode1"], Request["typeCode2"], Request["SystemMain"], Request["SystemSub"], Request["selDelFlag"]);
//logger.Debug("TEST:使用壓力:≥7kg/c㎡G");
//foreach (var p in lstItems)
//{
// logger.Debug("PK=" + p.PROJECT_ITEM_ID + ",ITEM_DESC=" + p.ITEM_DESC + ",excel row=" + p.EXCEL_ROW_ID);
//}
ViewBag.Result = "共幾" + lstItems.Count + "筆資料";
return(PartialView(lstItems));
}
public static List <SelectListItem> getMainSystem(string id, InquiryFormService service)
{
//取得主系統資料
List <SelectListItem> selectMain = new List <SelectListItem>();
foreach (string itm in service.getSystemMain(id))
{
log.Debug("Main System=" + itm);
SelectListItem selectI = new SelectListItem();
selectI.Value = itm;
selectI.Text = itm;
if (null != itm && "" != itm)
{
selectMain.Add(selectI);
}
}
return(selectMain);
}
public static List <SelectListItem> getSubSystem(string id, InquiryFormService service)
{
//取得次系統資料
List <SelectListItem> selectSub = new List <SelectListItem>();
foreach (string itm in service.getSystemSub(id))
{
logger.Debug("Sub System=" + itm);
SelectListItem selectI = new SelectListItem();
selectI.Value = itm;
selectI.Text = itm;
if (null != itm && "" != itm)
{
selectSub.Add(selectI);
}
}
return(selectSub);
}
/// <summary>
/// 新增或更新Project_item 資料
/// </summary>
/// <param name="form"></param>
/// <returns></returns>
public String addProjectItem(FormCollection form)
{
logger.Info("form:" + form.Count);
string msg = "更新成功!!";
TND_PROJECT_ITEM item = new TND_PROJECT_ITEM();
item.PROJECT_ID = form["project_id"];
item.PROJECT_ITEM_ID = form["project_item_id"];
item.ITEM_ID = form["item_id"];
item.ITEM_DESC = form["item_desc"];
item.ITEM_UNIT = form["item_unit"];
try
{
item.ITEM_QUANTITY = decimal.Parse(form["item_quantity"]);
}
catch (Exception ex)
{
logger.Error(item.PROJECT_ITEM_ID + " not quattity:" + ex.Message);
}
try
{
item.ITEM_UNIT_PRICE = decimal.Parse(form["item_unit_price"]);
}
catch (Exception ex)
{
logger.Error(item.PROJECT_ITEM_ID + " not unit price:" + ex.Message);
}
item.ITEM_REMARK = form["item_remark"];
if (form["type_code_1"].Trim() != "")
{
item.TYPE_CODE_1 = form["type_code_1"];
}
else
{
item.TYPE_CODE_1 = null;
}
if (form["type_code_2"].Trim() != "")
{
item.TYPE_CODE_2 = form["type_code_2"];
}
else
{
item.TYPE_CODE_2 = null;
}
item.SYSTEM_MAIN = form["system_main"];
item.SYSTEM_SUB = form["system_sub"];
item.DEL_FLAG = form["selDelFlag"];
try
{
item.EXCEL_ROW_ID = long.Parse(form["excel_row_id"]);
}
catch (Exception ex)
{
logger.Error(item.PROJECT_ITEM_ID + " not exce row id:" + ex.Message);
}
SYS_USER loginUser = (SYS_USER)Session["user"];
item.MODIFY_USER_ID = loginUser.USER_ID;
item.MODIFY_DATE = DateTime.Now;
InquiryFormService service = new InquiryFormService();
int i = 0;
string strFlag = form["flag"].Trim();
if (strFlag.Equals("addAfter"))
{
i = service.addProjectItemAfter(item);
}
else
{
i = service.updateProjectItem(item);
}
if (i == 0)
{
msg = service.message;
}
return(msg);
}
