public JsonResult CreateDataInfo(DataInfoViewModel item)
{
try
{
data_info dinfo = new data_info
{
Data_Info_Describe = item.Data_Info_Describe,
Data_Info_Image = item.Data_Info_Image,
Data_Info_Name = item.Data_Info_Name,
data_detail_info = item.data_detail_info,
ID = item.ID,
CreateDateTime = DateTime.Now,
UpdateDateTime = DateTime.Now,
Data_Type_ID = item.Data_Type_ID,
data_type_info = item.data_type_info
};
if (dinfo.ID > 0)
{
datainfoService.UpdateEntity(dinfo);
}
else
{
datainfoService.AddEntity(dinfo);
}
var result = new { State = "Success" };
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var result = new { State = "Exception", Message = ex.Message };
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public void getQuestionData(QuestionDataList questionDataList)
{
NaireWebDataContext db = new NaireWebDataContext();
List <QuestionDataItem> question_data_items = questionDataList.list;
for (int i = 0; i < question_data_items.Count; i++)
{
data_info data = new data_info();
data.question_id = question_data_items[i].id;
if (question_data_items[i].items.Count > 1)
{
data.data = JsonConvert.SerializeObject(question_data_items[i].items);
}
else if (question_data_items[i].items.Count == 1)
{
data.data = question_data_items[i].items[0];
}
// 提交存入数据库
db.data_info.InsertOnSubmit(data);
db.SubmitChanges();
}
// 获得问题id->获得问卷id->问卷收到数据数+1
int question_id = question_data_items[0].id;
question_info question_result = (from r in db.question_info
where r.id == question_id
select r).FirstOrDefault();
naire_info naire = (from r in db.naire_info
where r.id == question_result.naire_id
select r).FirstOrDefault();
naire.data += 1;
db.SubmitChanges();
}
[Route("SendOrderSeed/accept")] /*ส่งเมล็ดให้หน่วยงานอื่น*/
public HttpResponseMessage LoadSendSeed()
{
object SendOrgOid;
try
{
SendOrgOid = HttpContext.Current.Request.Form["SendOrgOid"].ToString();
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(SendOrderSeed));
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
List <SendOrderSeed_Model> list_detail = new List <SendOrderSeed_Model>();
List <sendSeed_info> list = new List <sendSeed_info>();
data_info Temp_data = new data_info();
IList <SendOrderSeed> collection = ObjectSpace.GetObjects <SendOrderSeed>(CriteriaOperator.Parse(" GCRecord is null and SendStatus = 5 and SendOrgOid=? ", SendOrgOid));
double Amount = 0;
if (collection.Count > 0)
{
foreach (SendOrderSeed row in collection)
{
double sum = 0;
string WeightUnit;
sendSeed_info Approve = new sendSeed_info();
Approve.Send_No = row.SendNo;
Approve.SendDate = row.SendDate.ToString("dd-MM-yyyy", new CultureInfo("us-US")); /* convet เวลา*/
Approve.FinanceYear = row.FinanceYearOid.YearName;
Approve.SendOrgOid = row.SendOrgOid.Oid;
Approve.SendOrgName = row.SendOrgOid.SubOrganizeName;
Approve.ReceiveOrgoid = row.ReceiveOrgOid.Oid;
Approve.ReceiveOrgName = row.ReceiveOrgOid.SubOrganizeName;
foreach (SendOrderSeedDetail row2 in row.SendOrderSeedDetails)
{
sum = sum + row2.Weight;
WeightUnit = row2.WeightUnitOid.ToString();
}
Approve.Weight_All = sum.ToString() + " " + "กิโลกรัม";
list.Add(Approve);
}
Temp_data.sendSS = list;
return(Request.CreateResponse(HttpStatusCode.OK, list));
}
else
{
UserError err = new UserError();
err.code = "5"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = "No data";
//// Return resual
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
catch (Exception ex)
{ //Error case เกิดข้อผิดพลาด
UserError err = new UserError();
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = ex.Message;
//// Return resual
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
