/// <summary>
/// 生成普通编码
/// </summary>
/// <param name="code">普通编码的类型</param>
/// <param name="DepartmentShort">部门编码的缩写</param>
/// <returns></returns>
public string GenerateStaffParam(string code, string DepartmentShort)
{
ParamCodes tmp = db.ParamCodes.Where(p => p.Type == code).Single();
string date = DateTime.Now.ToString("yyyyMMdd");
//为流水号补充零
string SerialNumber = AddZero(tmp.Count, tmp.SerialNumber);
//更新单号的计数值
tmp.Count++;
db.Entry(tmp).State = EntityState.Modified;
db.SaveChanges();
//部门缩写＋流水号的情况
if (tmp.CodeMethod.Equals(CodeMethod.Five))
{
SerialNumber = AddZero(tmp.Count - 1, 10 - DepartmentShort.Length);
return(DepartmentShort + SerialNumber);
}
switch (tmp.CodeMethod)
{
case CodeMethod.Day:
return(DateTime.Now.ToString("yyyyMMdd").ToString() + SerialNumber);
case CodeMethod.Month:
return(DateTime.Now.ToString("yyyyMM").ToString() + SerialNumber);
case CodeMethod.Serial:
return(tmp.Code.Substring(0, 10 - tmp.SerialNumber) + SerialNumber);
default:
return("");
}
}
public static string GenerateContractNumber(string abbr, string connString)
{
BonsaiiDbContext db = new BonsaiiDbContext(connString);
ParamCodes tmp = db.ParamCodes.Where(p => p.ParamName == "合同编号").Single();
string date = DateTime.Now.ToString("yyyyMMdd");
string SerialNumber = null;
//为流水号补充零
if (tmp.SerialNumber != 0)
{
SerialNumber = AddZero(tmp.Count, tmp.SerialNumber);
//更员工号计数值
tmp.Count++;
db.Entry(tmp).State = EntityState.Modified;
db.SaveChanges();
}
switch (tmp.CodeMethod)
{
case CodeMethod.Day:
return(DateTime.Now.ToString("yyMMdd").ToString() + SerialNumber);
case CodeMethod.Month:
return(DateTime.Now.ToString("yyMM").ToString() + SerialNumber);
case CodeMethod.Serial:
return(tmp.Code.Substring(0, 10 - tmp.SerialNumber) + SerialNumber);
case CodeMethod.Five:
return(abbr + SerialNumber);
default:
return("");
}
}
public void SetParameterValue <T>(ParamCodes parCode, T val)
{
try
{
if (val == null)
{
Report.Notify(new DetectorMessage(Codes.ERR_DET_SET_NULL_PARAM)
{
DetailedText = Enum.GetName(typeof(ParamCodes), parCode)
});
return;
}
_ = parCode switch
{
ParamCodes.CAM_T_SGEOMTRY => _device.Param[parCode] = val.ToString(),
_ => _device.Param[parCode] = val
};
_device.Save("", true);
}
catch (Exception ex)
{
Report.Notify(new DetectorMessage(Codes.ERR_DET_SET_PARAM_UNREG)
{
DetailedText = string.Join(Environment.NewLine, Enum.GetName(typeof(ParamCodes), parCode), ex.ToString())
});
}
}
public ActionResult DeleteConfirmed(int id)
{
ParamCodes paramCodes = db.ParamCodes.Find(id);
db.ParamCodes.Remove(paramCodes);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,CodeMethod,Code,Year,Month,Day,SerialNumber,ParamName")] ParamCodes paramCodes)
{
if (ModelState.IsValid)
{
db.Entry(paramCodes).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(paramCodes));
}
// GET: ParamCodes/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ParamCodes paramCodes = db.ParamCodes.Find(id);
if (paramCodes == null)
{
return(HttpNotFound());
}
return(View(paramCodes));
}
public ActionResult Create([Bind(Include = "Id,CodeMethod,Code,Year,Month,Day,SerialNumber,ParamName")] ParamCodes paramCodes)
{
if (ModelState.IsValid)
{
switch (paramCodes.CodeMethod)
{
case CodeMethod.Month:
paramCodes.Year = 4;
paramCodes.Month = 2;
paramCodes.Day = 0;
paramCodes.SerialNumber = 4;
break;
case CodeMethod.Serial:
paramCodes.Year = 0;
paramCodes.Month = 0;
paramCodes.Day = 0;
paramCodes.SerialNumber = this.GetSerialNumbers(paramCodes.Code);
break;
case CodeMethod.Manual:
paramCodes.Year = 0;
paramCodes.Month = 0;
paramCodes.Day = 0;
paramCodes.SerialNumber = 0;
break;
case CodeMethod.Five:
paramCodes.Year = 0;
paramCodes.Month = 0;
paramCodes.Day = 0;
paramCodes.SerialNumber = 6;
break;
default:
paramCodes.Year = 2;
paramCodes.Month = 2;
paramCodes.Day = 2;
paramCodes.SerialNumber = 2;
break;
}
paramCodes.RecordPerson = this.Name;
paramCodes.RecordTime = DateTime.Now;
db.ParamCodes.Add(paramCodes);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(paramCodes));
}
public T GetParameterValue <T>(ParamCodes parCode)
{
try
{
if (_spectra.IsOpen)
{
return(_spectra.Param[parCode].ToString().Convert <T>());
}
}
catch (Exception)
{
ErrorMessage += $"Can't convert a parameter '{Enum.GetName(parCode)}'";
}
return(default(T));
}
public T GetParameterValue <T>(ParamCodes parCode)
{
try
{
if (_device.IsConnected)
{
return(_device.Param[parCode].ToString().Convert <T>());
}
}
catch (Exception ex)
{
Report.Notify(new DetectorMessage(Codes.ERR_DET_GET_PARAM_UNREG)
{
DetailedText = string.Join(Environment.NewLine, Name, Enum.GetName(typeof(ParamCodes), parCode), ex.ToString())
});
}
return(default(T));
}
// GET: ParamCodes/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ParamCodes paramCodes = db.ParamCodes.Find(id);
List <Params> paramList = db.Params.ToList();
List <CodeMethod> list = CodeMethod.GetCodeMethod();
List <SelectListItem> item = list.Select(c => new SelectListItem
{
Value = c.Id,
Text = c.Description
}).ToList();
foreach (SelectListItem tmp in item)
{
if (tmp.Text == paramCodes.ParamName)
{
tmp.Selected = true;
}
}
ViewBag.List = item;
List <SelectListItem> item2 = paramList.Select(c => new SelectListItem
{
Value = c.ParamName,
Text = c.ParamName
}).ToList();
foreach (SelectListItem tmp in item2)
{
if (tmp.Text == paramCodes.CodeMethod)
{
tmp.Selected = true;
}
}
ViewBag.List2 = item2;
if (paramCodes == null)
{
return(HttpNotFound());
}
return(View(paramCodes));
}
public ActionResult Create([Bind(Include = "Id,CodeMethod,Code,Year,Month,Day,SerialNumber,ParamName")] ParamCodes paramCodes)
{
if (ModelState.IsValid)
{
switch (paramCodes.CodeMethod)
{
case CodeMethod.Two:
paramCodes.Year = 4;
paramCodes.Month = 2;
paramCodes.Day = 0;
paramCodes.SerialNumber = 4;
break;
case CodeMethod.Three:
paramCodes.Year = 0;
paramCodes.Month = 0;
paramCodes.Day = 0;
paramCodes.SerialNumber = 10;
break;
case CodeMethod.Four:
paramCodes.Year = 0;
paramCodes.Month = 0;
paramCodes.Day = 0;
paramCodes.SerialNumber = 0;
break;
default:
paramCodes.Year = 4;
paramCodes.Month = 2;
paramCodes.Day = 2;
paramCodes.SerialNumber = 2;
break;
}
db.ParamCodes.Add(paramCodes);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(paramCodes));
}
public static void SetValues(ParamCodes uc, Object val)
{
SqlConnection sc = new SqlConnection(DEFS.ConSTR);
sc.Open();
string search_obj = uc.ToString();
string field_name = "";
SqlCommand cmd = new SqlCommand();
cmd.Connection = sc;
cmd.CommandType = CommandType.Text;
switch (GetType(uc))
{
case ParamTypes.egesz:
field_name = "PARAM_VALUE_I";
break;
case ParamTypes.szoveg:
field_name = "PARAM_VALUE_S";
break;
case ParamTypes.tizedes:
field_name = "PARAM_VALUE_F";
break;
case ParamTypes.image:
field_name = "PARAM_VALUE_IMAGE";
break;
default:
field_name = "";
break;
}
if (field_name != "")
{
string sql_str = "IF EXISTS(select '' from syspar where PARAM_NAME = '" + search_obj + "') BEGIN " +
" UPDATE SYSPAR SET " + field_name + " = '" + val.ToString() + "' WHERE PARAM_NAME = '" + search_obj + "' " +
" end else begin INSERT INTO syspar (PARAM_NAME, " + field_name + ") VALUES ('" + search_obj + "' ,'" + val.ToString() + "') END ";
cmd.CommandText = sql_str;
cmd.ExecuteNonQuery();
sc.Close();
}
}
public static Object GetValue(ParamCodes c)
{
Object ret_obj = null;
string search_obj = c.ToString();
string field_name = "";
SqlConnection sc = new SqlConnection(DEFS.ConSTR);
sc.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = sc;
cmd.CommandType = CommandType.Text;
switch (GetType(c))
{
case ParamTypes.egesz:
field_name = "PARAM_VALUE_I";
break;
case ParamTypes.szoveg:
field_name = "PARAM_VALUE_S";
break;
case ParamTypes.tizedes:
field_name= "PARAM_VALUE_F";
break;
case ParamTypes.image:
field_name = "PARAM_VALUE_IMAGE";
break;
default:
field_name = "";
break;
}
if (field_name != "")
{
cmd.CommandText = "select " + field_name + " as VALUE from syspar where PARAM_NAME = '" + search_obj + "'";
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
ret_obj = rdr["VALUE"];
}
sc.Close();
if (ret_obj == null) { return (Object)(""); }
else
{
return (Object)(ret_obj);
}
}
else
{
return ("");
}
}
public static ParamTypes GetType(ParamCodes cc)
{
if (cc == ParamCodes.SHOW_ORDER_BEFORE)
{
return ParamTypes.egesz;
}
else if (cc == ParamCodes.CEG_NEV)
{
return (ParamTypes.szoveg);
}
else if (cc == ParamCodes.SHOW_ORDER_BEFORE)
{
return (ParamTypes.szoveg);
}
else if (cc == ParamCodes.SHOW_ORDER_BEFORE)
{
return (ParamTypes.egesz);
}
else if (cc == ParamCodes.CEG_CIM)
{
return (ParamTypes.szoveg);
}
else if (cc == ParamCodes.BLOKK_LABLEC1)
{
return (ParamTypes.szoveg);
}
else if (cc == ParamCodes.BLOKK_LABLEC2)
{
return (ParamTypes.szoveg);
}
else if (cc == ParamCodes.BLOKK_LABLEC3)
{
return (ParamTypes.szoveg);
}
else if (cc == ParamCodes.AUTO_PRINT_BLOKK)
{
return (ParamTypes.egesz);
}
else if (cc == ParamCodes.LELTAR_KOROK_SZAMA)
{
return (ParamTypes.egesz);
}
else if (cc == ParamCodes.OSSZ_REPORT_FORMAT)
{
return (ParamTypes.szoveg);
}
else if (cc == ParamCodes.BLOKK_LOGO_PATH)
{
return (ParamTypes.szoveg);
}
else if (cc == ParamCodes.CIKK_GORGET_MODE)
{
return (ParamTypes.szoveg);
}
else if (cc == ParamCodes.SKIN_NAME)
{
return (ParamTypes.szoveg);
}
else
{
return ParamTypes.egesz;
}
}
public ActionResult Edit(ParamCodes paramCode)
{
if (ModelState.IsValid)
{
ParamCodes paramCodes = db.ParamCodes.Find(paramCode.Id);
switch (paramCode.CodeMethod)
{
case CodeMethod.Month:
paramCodes.Year = 4;
paramCodes.Month = 2;
paramCodes.Day = 0;
paramCodes.SerialNumber = 4;
break;
case CodeMethod.Serial:
paramCodes.Year = 0;
paramCodes.Month = 0;
paramCodes.Day = 0;
paramCodes.SerialNumber = this.GetSerialNumbers(paramCodes.Code);
break;
case CodeMethod.Manual:
paramCodes.Year = 0;
paramCodes.Month = 0;
paramCodes.Day = 0;
paramCodes.SerialNumber = 0;
break;
case CodeMethod.Five:
paramCodes.Year = 0;
paramCodes.Month = 0;
paramCodes.Day = 0;
paramCodes.SerialNumber = 6;
break;
default:
paramCodes.Year = 4;
paramCodes.Month = 2;
paramCodes.Day = 2;
paramCodes.SerialNumber = 2;
break;
}
paramCodes.ChangePerson = this.Name;
paramCodes.ChangeTime = DateTime.Now;
paramCodes.CodeMethod = paramCode.CodeMethod;
paramCodes.Code = paramCode.Code;
paramCodes.ParamName = paramCode.ParamName;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
List <Params> paramList = db.Params.ToList();
List <CodeMethod> list = CodeMethod.GetCodeMethod();
List <SelectListItem> item = list.Select(c => new SelectListItem
{
Value = c.Id,
Text = c.Description
}).ToList();
foreach (SelectListItem tmp in item)
{
if (tmp.Text == paramCode.ParamName)
{
tmp.Selected = true;
}
}
ViewBag.List = item;
List <SelectListItem> item2 = paramList.Select(c => new SelectListItem
{
Value = c.ParamName,
Text = c.ParamName
}).ToList();
foreach (SelectListItem tmp in item2)
{
if (tmp.Text == paramCode.CodeMethod)
{
tmp.Selected = true;
}
}
ViewBag.List2 = item2;
return(View(paramCode));
}
}
