//新增一条记录
protected string AddNewRecord(string running_no, string po_no, string warehouse_code, string barcode_no, string scan_time, string run_no_for_modify, string modify_flag)
{
string _returnString = string.Empty;
_returnString = DataModelUtility.addNewRecord(running_no, po_no, warehouse_code, barcode_no, scan_time, run_no_for_modify, modify_flag);
return(_returnString);
}
public static string ShowAllOrder(Hashtable ht)
{
string json = string.Empty;
DataTable funcDs = DataModelUtility.getAllOrder();
json = getJsonFromDataTable(funcDs, ht);
return(json);
}
public static string GetOrderNull(Hashtable ht)
{
string json = string.Empty;
string _Onum = string.Empty;
DataTable funcDs = DataModelUtility.getOrderNull();
json = getJsonFromDataTable(funcDs, ht);
return(json);
}
internal static string DeleteOrder(Dictionary <string, object> param)
{
string _returnString = string.Empty;
string running_no = string.Empty;
running_no = param["Onum"].ToString();
_returnString = DataModelUtility.deleteRecord(running_no);
return(_returnString);
}
public static string GetOrderByCompose(Hashtable ht)
{
string _Onum = ht["Onum"].ToString().Trim();
string _GN = ht["GN"].ToString().Trim();
string _PO = ht["PO"].ToString().Trim();
string _SN = ht["SN"].ToString().Trim();
string _FromDateTime = ht["FromDateTime"].ToString().Trim();
string _ToDateTime = ht["ToDateTime"].ToString().Trim();
DataTable funcDs = DataModelUtility.getOrderByCompose(_Onum, _GN, _PO, _SN, _FromDateTime, _ToDateTime);
string json = getJsonFromDataTable(funcDs, ht);
return(json);
}
internal static string AddNewOrder(Dictionary <string, object> param)
{
string _returnString = string.Empty;
string running_no = string.Empty, po_no = string.Empty, warehouse_code = string.Empty, barcode_no = string.Empty, scan_time = string.Empty, run_no_for_modify = string.Empty, modify_flag = string.Empty;
running_no = param["Onum"].ToString();
warehouse_code = param["GN"].ToString();
po_no = param["PO"].ToString();
barcode_no = param["SN"].ToString();
scan_time = param["ST"].ToString();
run_no_for_modify = param["OW"].ToString();
modify_flag = param["Flag"].ToString();
_returnString = DataModelUtility.addNewRecord(running_no, po_no, warehouse_code, barcode_no, scan_time, run_no_for_modify, modify_flag);
_returnString = "ok";
return(_returnString);
}
internal static string DeleteOrders(Dictionary <string, object> param)
{
string _returnString = string.Empty;
string running_nos = string.Empty;
running_nos = param["Onum"].ToString();
string[] _strings = running_nos.Split(',');
var tmp = "(";
for (int i = 0; i < _strings.Length; i++)
{
tmp += "'" + _strings[i] + "',";
}
tmp = tmp.Substring(0, tmp.Length - 1);
tmp += ")";
_returnString = DataModelUtility.deleteRecords(tmp);
_returnString = AddNewOrder(param);
return(_returnString);
}
public static bool FillExportOrderExcel(string filePath, string _Onum, string _GN, string _PO, string _SN, string _FromDateTime, string _ToDateTime)
{
bool b = false;
try
{
DataTable funcDs = DataModelUtility.getOrderByComposeForExport(_Onum, _GN, _PO, _SN, _FromDateTime, _ToDateTime);
//for循环
if (!System.IO.File.Exists(filePath))
{
return(b);
}
ExcelHelper _excelHelper = new ExcelHelper(filePath);
_excelHelper.DataTableToExcel(funcDs, 1, 1);
_excelHelper.SaveFile();
b = true;
}
catch (Exception)
{
throw;
}
return(b);
}
//对于get方式，服务器端用Request.QueryString获取变量的值，
//对于post方式，服务器端用Request.Form获取提交的数据。
protected void Page_Load(object sender, EventArgs e)
{
string _returnString = string.Empty;
//第一部分，接收手持端参数
string running_no = ""; //流水号
string po_no = ""; //发运单号
string warehouse_code = ""; //仓库码
string barcode_no = ""; //条码号
string scan_time = ""; //扫描时间
string run_no_for_modify = ""; //待修改流水号Z
string modify_flag = "0"; //修改标识
running_no = Request.Form["running_no"].Trim();
warehouse_code = Request.Form["warehouse_code"].Trim();
po_no = Request.Form["po_no"].Trim();
barcode_no = Request.Form["barcode_no"].Trim();
scan_time = Request.Form["scan_time"].Trim();
modify_flag = Request.Form["modify_flag"].Trim();
run_no_for_modify = Request.Form["run_no_for_modify"].Trim();
//第二部分，数据检核
//1.主键不为空
string primary_key_field = running_no;
if (primary_key_field.Trim().Length == 0)
{
_returnString = DataModelUtility.getResponseString(RETURN_NULL_PRIMARY_KEY, running_no, po_no, warehouse_code, barcode_no, scan_time, run_no_for_modify, modify_flag);
Response.Write(_returnString);
return;
}
//2.按照修改操作符区分
int i_flag = Convert.ToInt16(modify_flag);
//普通新增
if (i_flag == 0)
{
_returnString = AddNewRecord(running_no, po_no, warehouse_code, barcode_no, scan_time, run_no_for_modify, modify_flag);
Response.Write(_returnString);
return;
}
else if (i_flag == 1) //删除操作
{
if (new GarbageBLL().IsContainOW(run_no_for_modify)) //包含run_no_for_modify
{
new GarbageBLL().deleteGarbageInfo(run_no_for_modify);
_returnString = DataModelUtility.getResponseString(RETURN_NORMAL, running_no, po_no, warehouse_code, barcode_no, scan_time, run_no_for_modify, modify_flag);
Response.Write(_returnString);
return;
}
else
{
_returnString = DataModelUtility.getResponseString(RETURN_DELETE_INVALID_RECORD, running_no, po_no, warehouse_code, barcode_no, scan_time, run_no_for_modify,
modify_flag);
Response.Write(_returnString);
return;
}
}
else if (i_flag == 2)//修改替换
{
if (new GarbageBLL().IsContainOW(run_no_for_modify))
{
new GarbageBLL().deleteGarbageInfo(run_no_for_modify);
Garbage gb = new Garbage();
if (new GarbageBLL().IsContainOnum(running_no))
{
_returnString = DataModelUtility.getResponseString(RETURN_DUPLICATE_PRIMARY_KEY, running_no, po_no, warehouse_code, barcode_no, scan_time, run_no_for_modify,
modify_flag);
Response.Write(_returnString);
return;
}
else
{
_returnString = AddNewRecord(running_no, po_no, warehouse_code, barcode_no, scan_time, run_no_for_modify, modify_flag);
Response.Write(_returnString);
return;
}
}
}
else
{
_returnString = DataModelUtility.getResponseString(RETURN_INVALID_MODIFY_FLAG, running_no, po_no, warehouse_code, barcode_no, scan_time, run_no_for_modify, modify_flag);
Response.Write(_returnString);
return;
}
}
