public static decimal GetSerialNo(SqlConnection conn)
{
SerialNo serialNo = new SerialNo();
serialNo.cnvcFill = "0";
return(Convert.ToDecimal(EntityMapping.Create(serialNo, conn)));
}
/// <summary>
/// 生成序列号
/// </summary>
/// <param name="trans"></param>
/// <returns></returns>
public static decimal GetSerialNo(SqlTransaction trans)
{
SerialNo serialNo = new SerialNo();
serialNo.cnvcFill = "0";
return(Convert.ToDecimal(EntityMapping.Create(serialNo, trans)));
}
public override void Encode()
{
encodeBuf.Clear();
encodeBuf.AddRange(AddString(TxnType, 2));
encodeBuf.AddRange(AddString(StationId, 4));
encodeBuf.AddRange(AddString(DeviceId, 8));
encodeBuf.AddRange(AddString(ReportDate, 8));
encodeBuf.AddRange(AddString(TestFlag, 1));
encodeBuf.AddRange(AddString(SerialNo.PadLeft(3, '0'), 3));
encodeBuf.AddRange(AddString(PutInOperatorId, 6));
encodeBuf.AddRange(AddString(GetOutOperatorId, 6));
encodeBuf.AddRange(AddString(PutInTime, 14));
encodeBuf.AddRange(AddString(GetOutTime, 14));
encodeBuf.AddRange(AddString(CashBoxId.PadLeft(10, '0'), 10));
encodeBuf.AddRange(AddString(CashBoxType, 1));
encodeBuf.AddRange(AddString(Coin1Qty.PadLeft(5, '0'), 5));
encodeBuf.AddRange(AddString(Coin2Qty.PadLeft(5, '0'), 5));
encodeBuf.AddRange(AddString(Coin3Qty.PadLeft(5, '0'), 5));
encodeBuf.AddRange(AddString(Note1Qty.PadLeft(5, '0'), 5));
encodeBuf.AddRange(AddString(Note2Qty.PadLeft(5, '0'), 5));
encodeBuf.AddRange(AddString(Note3Qty.PadLeft(5, '0'), 5));
encodeBuf.AddRange(AddString(Note4Qty.PadLeft(5, '0'), 5));
encodeBuf.AddRange(AddString(Note5Qty.PadLeft(5, '0'), 5));
encodeBuf.AddRange(AddString(Note6Qty.PadLeft(5, '0'), 5));
encodeBuf.AddRange(AddString(Note7Qty.PadLeft(5, '0'), 5));
encodeBuf.AddRange(AddString(Note8Qty.PadLeft(5, '0'), 5));
encodeBuf.AddRange(AddString(Spare.PadLeft(8, '0'), 8));
}
public CStatHubFixture(int slotMax)
{
for (int i = 0; i < slotMax; i++)
{
SerialNo.Add("");
ResultName.Add("");
ResultId.Add(0);
Result.Add(0);
}
}
public void AddProductLostSerial(ArrayList alLostSerial, OperLog operLog) //,BusiLog busiLog)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
string strSysTime = SqlHelper.ExecuteScalar(trans, CommandType.Text, "select getdate()").ToString();
DateTime dtSysTime = DateTime.Parse(strSysTime);
SerialNo serialNo = new SerialNo();
serialNo.cnvcFill = "0";
serialNo.cnnSerialNo = Convert.ToInt32(EntityMapping.Create(serialNo, trans));
for (int i = 0; i < alLostSerial.Count; i++)
{
LostSerial ls = (LostSerial)alLostSerial[i];
ls.cnvcLostType = "0";
ls.cndOperDate = dtSysTime;
ls.cnnLostSerialNo = serialNo.cnnSerialNo;
EntityMapping.Create(ls, trans);
// ProductLostSerialLog productLostSerialLog = new ProductLostSerialLog(productLostSerial.ToTable());
// //productSerialLog.cnnSerialNo = null;
// productLostSerialLog.cnnProductLostSerialNo = serialNo.cnnSerialNo;
// EntityMapping.Create(productLostSerialLog, trans);
}
operLog.cndOperDate = dtSysTime;
operLog.cnvcComments = "生产产品报损，报损流水：" + serialNo.cnnSerialNo.ToString();
EntityMapping.Create(operLog, trans);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
LogAdapter.WriteDatabaseException(sex);
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
LogAdapter.WriteFeaturesException(ex);
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
public CStatTestFixture(int slotMax)
{
for (int i = 0; i < slotMax; i++)
{
SerialNo.Add("");
ResultName.Add("");
ResultId.Add(0);
Result.Add(0);
Value.Add("");
Volt.Add(0);
Cur.Add(0);
DD.Add("");
}
}
public CDev(int idNo, string name = "", int chanNum = 8)
{
this._idNo = idNo;
this._name = name;
this.ChanMax = chanNum;
for (int i = 0; i < chanNum; i++)
{
SerialNo.Add("");
Result.Add(0);
TestData.Add("");
}
}
public CDev(int idNo, string name = "", int chanNum = 16)
{
this._idNo = idNo;
this._name = name;
this.ChanMax = chanNum;
for (int i = 0; i < chanNum; i++)
{
SerialNo.Add("");
Result.Add(0);
FailInfo.Add("");
HpResult.Add(new CHPPara.CStepVal());
}
}
public CStat(int idNo, string name, int flowId, string flowName, int slotMax)
{
this._idNo = idNo;
this._name = name;
this._slotMax = slotMax;
this.FlowId = flowId;
this.FlowName = flowName;
for (int i = 0; i < slotMax; i++)
{
SerialNo.Add("");
Result.Add(0);
TestData.Add("");
}
}
public CStatHub(int idNo, string name, int flowId, string flowName, int slotMax)
{
this._idNo = idNo;
this._name = name;
this._slotMax = slotMax;
this.FlowId = flowId;
this.FlowName = flowName;
for (int i = 0; i < slotMax; i++)
{
SnEnable.Add(true);
SerialNo.Add("");
ResultName.Add("");
ResultId.Add(0);
Result.Add(0);
TranOK.Add(false);
}
}
public override void Encode()
{
encodeBuf.Clear();
encodeBuf.AddRange(AddString(TxnType, 2));
encodeBuf.AddRange(AddString(StationId, 4));
encodeBuf.AddRange(AddString(DeviceId, 8));
encodeBuf.AddRange(AddString(ReportDate, 8));
encodeBuf.AddRange(AddString(TestFlag, 1));
encodeBuf.AddRange(AddString(SerialNo.PadLeft(3, '0'), 3));
encodeBuf.AddRange(AddString(OperatorId, 6));
encodeBuf.AddRange(AddString(CashBoxId.PadLeft(10, '0'), 10));
encodeBuf.AddRange(AddString(Coin1Qty.PadLeft(5, '0'), 5));
encodeBuf.AddRange(AddString(Coin2Qty.PadLeft(5, '0'), 5));
encodeBuf.AddRange(AddString(Coin3Qty.PadLeft(5, '0'), 5));
encodeBuf.AddRange(AddString(CoinAddTime, 14));
encodeBuf.AddRange(AddString(Spare.PadLeft(7, '0'), 7));
}
public override void Encode()
{
encodeBuf.Clear();
encodeBuf.AddRange(AddString(TxnType, 2));
encodeBuf.AddRange(AddString(DeviceId, 8));
encodeBuf.AddRange(AddString(OperatorId, 6));
encodeBuf.AddRange(AddString(ShiftId.PadLeft(10, '0'), 10));
encodeBuf.AddRange(AddString(SerialNo.PadLeft(4, '0'), 4));
encodeBuf.AddRange(AddString(AdminType, 2));
encodeBuf.AddRange(AddString(IncomeFlag.PadLeft(2, '0'), 2));
encodeBuf.AddRange(AddString(StationId, 4));
encodeBuf.AddRange(AddString(DessesionAmt.PadLeft(8, '0'), 8));
encodeBuf.AddRange(AddString(RelateDeviceId, 8));
encodeBuf.AddRange(AddString(RelateTicketType.PadLeft(16, '0'), 16));
encodeBuf.AddRange(AddString(SaleOutBoundTicketAmt.PadLeft(8, '0'), 8));
encodeBuf.AddRange(AddString(RelateOutBoundTicketSerialNo.PadLeft(8, '0'), 10));
encodeBuf.AddRange(AddString(OutBoundTicketType, 1));
encodeBuf.AddRange(AddString(TxnTime, 14));
encodeBuf.AddRange(AddString(Spare.PadLeft(17, '0'), 17));
}
public void ProcessRequest(HttpContext context)
{
this.context = context;
//允许上传的文件列表
Hashtable extTable = new Hashtable();
extTable.Add("image", "gif,jpg,jpeg,png,bmp,ico");
extTable.Add("document", "doc,htm,html,xml,css,js");
extTable.Add("video", "mp4");
extTable.Add("audio", "mp3");
//文件大小限制（单位：KB）
int maxSize = 10240;
#region 获取参数
int index = 0;
String guid = string.Empty;
String dirName = string.Empty;
try
{
guid = Microsoft.JScript.GlobalObject.unescape(context.Request.QueryString["guid"].Trim());
dirName = Microsoft.JScript.GlobalObject.unescape(context.Request.QueryString["dir"].Trim());
}
catch
{
ShowError("参数不正确。");
}
try
{
index = Convert.ToInt32(Microsoft.JScript.GlobalObject.unescape(context.Request.QueryString["index"].Trim()));
}
catch
{
index = 0;
}
if (guid == "" || dirName == "")
{
ShowError("参数（guid、dir）不能为空。");
}
#endregion
#region 路径的确定以及创建
String savePath = "~/upload/" + dirName + "/";
String saveUrl = "/upload/" + dirName + "/";
savePath = context.Server.MapPath(savePath);
if (!Directory.Exists(savePath))
{
Directory.CreateDirectory(savePath);
}
HttpFileCollection files = context.Request.Files;
if (files.Count <= index)
{
ShowError("请选择文件.");
}
HttpPostedFile upload_file = files[index];
String fileName = upload_file.FileName;
String fileExt = Path.GetExtension(fileName).ToLower();
if (fileExt.Length <= 1)
{
ShowError("文件扩展名不正确。");
}
string ext = fileExt.Substring(1, fileExt.Length - 1);
savePath += ext + "/";
saveUrl += ext + "/";
if (!Directory.Exists(savePath))
{
Directory.CreateDirectory(savePath);
}
//savePath += guid + "/";
//saveUrl += guid + "/";
//if (!Directory.Exists(savePath))
//{
// Directory.CreateDirectory(savePath);
//}
DateTime now = DateTime.Now;
String year_month = now.ToString("yyyy", DateTimeFormatInfo.InvariantInfo) + now.ToString("MM", DateTimeFormatInfo.InvariantInfo);
savePath += year_month + "/";
saveUrl += year_month + "/";
if (!Directory.Exists(savePath))
{
Directory.CreateDirectory(savePath);
}
#endregion
#region 约束检查
if (!extTable.ContainsKey(dirName))
{
ShowError("目录名不在允许的范围内.");
return;
}
if (upload_file.InputStream == null || upload_file.InputStream.Length / 1024 > maxSize)
{
ShowError("上传文件大小超过限制,文件大小限制:" + maxSize + "KB");
}
if (String.IsNullOrEmpty(fileExt) || Array.IndexOf(((String)extTable[dirName]).Split(','), fileExt.Substring(1).ToLower()) == -1)
{
ShowError("上传文件扩展名不在允许的范围内.\n允许范围:" + ((String)extTable[dirName]) + ".");
}
#endregion
string newFileName = SerialNo.NewSerialNo() + fileExt;
String filePath = savePath + newFileName;
upload_file.SaveAs(filePath);
String fileUrl = saveUrl + newFileName;
Hashtable hash = new Hashtable();
hash["success"] = true;
hash["error"] = String.Empty;
hash["file"] = fileUrl;
context.Response.AddHeader("Content-Type", "text/html;charset=UTF-8");
context.Response.Write(JsonMapper.ToJson(hash));
context.Response.End();
}
