static void Main(string[] args)
{
AppClass appobject = new AppClass();
if (args.Length < 1)
{
System.Console.WriteLine("No string to check.");
}
else if (args.Length > 1)
{
System.Console.WriteLine("Only one argument is accepted.");
}
else
{
System.Console.Write("The string \"");
System.Console.Write(args[0]);
System.Console.Write("\" is ");
if (appobject.CheckString(args[0]) == false)
{
System.Console.WriteLine("not acceptable.");
}
else
{
System.Console.WriteLine("acceptable.");
}
}
}
public string POST_PRINT_RWQD(string datastring)
{
MES_RETURN_UI rst = new MES_RETURN_UI();
MES_PD_SCRW_LIST model = Newtonsoft.Json.JsonConvert.DeserializeObject <MES_PD_SCRW_LIST>(datastring);
MES_PD_SCRW_LIST[] model_list = new MES_PD_SCRW_LIST[1];
model_list[0] = model;
AppClass.SetSession("MES_PD_SCRW_LIST", model_list);
rst.TYPE = "S";
return(Newtonsoft.Json.JsonConvert.SerializeObject(rst));
}
public string GET_SCRW_BY_ROLE(string datastring)
{
int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID"));
string token = AppClass.GetSession("token").ToString();
MES_PD_SCRW model_MES_PD_SCRW = Newtonsoft.Json.JsonConvert.DeserializeObject <MES_PD_SCRW>(datastring);
model_MES_PD_SCRW.STAFFID = STAFFID;
SELECT_MES_PD_SCRW rst_SELECT_MES_PD_SCRW = mesModels.PD_SCRW.SELECT_BY_ROLE(model_MES_PD_SCRW, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rst_SELECT_MES_PD_SCRW));
}
public string POST_TM_DELETE(string datastring)
{
int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID"));
string token = AppClass.GetSession("token").ToString();
MES_TM_TMINFO_DELETE_IN model_MES_TM_TMINFO_DELETE_IN = Newtonsoft.Json.JsonConvert.DeserializeObject <MES_TM_TMINFO_DELETE_IN>(datastring);
model_MES_TM_TMINFO_DELETE_IN.STAFFID = STAFFID;
MES_RETURN_UI rst_MES_RETURN_UI = mesModels.TM_TMINFO.DELETE_LOG(model_MES_TM_TMINFO_DELETE_IN, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rst_MES_RETURN_UI));
}
public string GET_GZZX_BYGC_NOROLE(string GC)
{
string token = AppClass.GetSession("token").ToString();
string rst = "";
MES_SY_GZZX model = new MES_SY_GZZX();
model.GC = GC;
MES_SY_GZZX[] rst_MES_SY_GZZX = mesModels.SY_GZZX.SELECT_USER(model, token);
rst = Newtonsoft.Json.JsonConvert.SerializeObject(rst_MES_SY_GZZX);
return(rst);
}
public string GET_PDINFO_BY_STAFFID(string datastring)
{
string token = Session["token"].ToString();
MES_PD_GD model_MES_PD_GD = Newtonsoft.Json.JsonConvert.DeserializeObject <MES_PD_GD>(datastring);
int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID"));
model_MES_PD_GD.STAFFID = STAFFID;
SELECT_MES_PD_GD rst_SELECT_MES_PD_GD = mesModels.PD_GD.SELECT_BY_STAFFID(model_MES_PD_GD, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rst_SELECT_MES_PD_GD));
}
public string RCODEList(int QID = 0)
{
MES_PMM_QR model = new MES_PMM_QR();
model.RISACTION = 1;
if (QID != 0)
{
model.QID = QID;
}
return(AppClass.EasyCall <MES_PMM_QR, MES_PMM_QR[]>(model, (postData, token) => { return mesModels.PMM_QR.REP_SELECT(postData, token).MES_PMM_QR; }));
}
static public AppClass Instance()
{
if (instance == null)
{
lock (_lock_this)
{
instance = new AppClass();
}
}
return(instance);
}
public string GET_TMINFO_BY_ROLE(string datastring)
{
int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID"));
string token = AppClass.GetSession("token").ToString();
MES_TM_TMINFO model_MES_TM_TMINFO = Newtonsoft.Json.JsonConvert.DeserializeObject <MES_TM_TMINFO>(datastring);
model_MES_TM_TMINFO.STAFFID = STAFFID;
SELECT_MES_TM_TMINFO_BYTM rst_SELECT_MES_TM_TMINFO_BYTM = mesModels.TM_TMINFO.SELECT_BY_ROLE(model_MES_TM_TMINFO, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rst_SELECT_MES_TM_TMINFO_BYTM));
}
public string GET_SBH(string GC, string GZZXBH)
{
string token = AppClass.GetSession("token").ToString();
string rst = "";
MES_SY_GZZX_SBH model_MES_SY_GZZX_SBH = new MES_SY_GZZX_SBH();
model_MES_SY_GZZX_SBH.GC = GC;
model_MES_SY_GZZX_SBH.GZZXBH = GZZXBH;
MES_SY_GZZX_SBH[] rst_MES_SY_GZZX_SBH = mesModels.SY_GZZX_SBH.SELECT(model_MES_SY_GZZX_SBH, token);
rst = Newtonsoft.Json.JsonConvert.SerializeObject(rst_MES_SY_GZZX_SBH);
return(rst);
}
public string GET_TYPEMX(int TYPEID, string GC)
{
string token = AppClass.GetSession("token").ToString();
string rst = "";
MES_SY_TYPEMX model_MES_SY_TYPEMX = new MES_SY_TYPEMX();
model_MES_SY_TYPEMX.TYPEID = TYPEID;
model_MES_SY_TYPEMX.GC = GC;
MES_SY_TYPEMXLIST[] rst_MES_SY_TYPEMXLIST = mesModels.SY_TYPEMX.SELECT(model_MES_SY_TYPEMX, token);
rst = Newtonsoft.Json.JsonConvert.SerializeObject(rst_MES_SY_TYPEMXLIST);
return(rst);
}
public string DELETE_PD_GD(string GDDH)
{
string token = AppClass.GetSession("token").ToString();
string rst = "";
MES_PD_GD model = new MES_PD_GD();
model.GDDH = GDDH;
MES_RETURN_UI rst_MES_RETURN_UI = mesModels.PD_GD.DELETE(model, token);
rst = Newtonsoft.Json.JsonConvert.SerializeObject(rst_MES_RETURN_UI);
return(rst);
}
public string TM_TMINFO_UPDATE_CF(string datastring)
{
string token = AppClass.GetSession("token").ToString();
int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID"));
MES_TM_TMINFO model = Newtonsoft.Json.JsonConvert.DeserializeObject <MES_TM_TMINFO>(datastring);
model.STAFFID = STAFFID;
model.JLR = STAFFID;
MES_RETURN_UI result = mesmodels.TM_TMINFO.UPDATE_CF(model, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(result));
}
public MODEL_Assign_WorkOrder MvcModel()
{
int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID"));
string token = AppClass.GetSession("token").ToString();
MODEL_Assign_WorkOrder model = new MODEL_Assign_WorkOrder();
MES_SY_GC model_MES_SY_GC = new MES_SY_GC();
model_MES_SY_GC.STAFFID = STAFFID;
MES_SY_GC[] MES_SY_GC_list = mesModels.SY_GC.SELECT_BY_ROLE(model_MES_SY_GC, token);
model.MES_SY_GC = MES_SY_GC_list;
return(model);
}
public void SaveDataInFirstTime()
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_Dry_DefaultDataInMasters";
cmd.CommandType = CommandType.StoredProcedure;
AppClass.ExecuteNonQuery(cmd);
}
catch (Exception)
{ }
}
public string GetGCbyStaffid(int STAFFID)
{
MES_SY_GC model_MES_SY_GC = new MES_SY_GC();
//TokenInfo tokeninfo = AccountModel.UserToken.Token("api", "sonluk2018");
//AccountModel.UserToken()
model_MES_SY_GC.STAFFID = STAFFID;
string token = AppClass.GetSession("token").ToString();
MES_SY_GC[] MES_SY_GC_list = mesModels.SY_GC.SELECT_BY_ROLE(model_MES_SY_GC, token);
return(JsonConvert.SerializeObject(MES_SY_GC_list));
}
public string ComponentSoldout_read(string in_bl)
{
string token = AppClass.GetSession("token").ToString();
PS_ZPSFUG_Q_LJXJ ps_ljxj = new PS_ZPSFUG_Q_LJXJ();
string SENUM = in_bl.Substring(0, 10);
string ZROWSNUM = in_bl.Substring(10, 4);
ps_ljxj = psmodels.ComponentMove.ComponentSoldout_read(SENUM, ZROWSNUM, token);
string json = Newtonsoft.Json.JsonConvert.SerializeObject(ps_ljxj);
return(json);
}
protected void btnPrint_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
cmd.CommandText = "sp_rpt_barcodprint";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BookingNo", ddlinvoice.SelectedItem.Text);
cmd.Parameters.AddWithValue("@BranchId", Globals.BranchID);
cmd.Parameters.AddWithValue("@Flag", 4);
ds = AppClass.GetData(cmd);
ReportViewer1.LocalReport.ReportPath = "RDLC/DynamicBarCodeReport.rdlc";
ReportDataSource rds = new ReportDataSource();
rds.Name = "DataSet1";
rds.Value = ds.Tables[0];
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.LocalReport.Refresh();
string reportType = "PDF";
string mimeType;
string encoding;
string fileNameExtension;
string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>PDF</OutputFormat>" +
" <PageWidth>210mm</PageWidth>" +
" <PageHeight>297mm</PageHeight>" +
" <Columns>3</Columns>" +
" <ColumnSpacing>2.5mm</ColumnSpacing>" +
" <MarginTop>12.50mm</MarginTop>" +
" <MarginLeft>6.50mm</MarginLeft>" +
" <MarginRight>0in</MarginRight>" +
" <MarginBottom>0in</MarginBottom>" +
"</DeviceInfo>";
Warning[] warnings;
string[] streams;
byte[] renderedBytes;
renderedBytes = ReportViewer1.LocalReport.Render(
reportType,
deviceInfo,
out mimeType,
out encoding,
out fileNameExtension,
out streams,
out warnings);
Response.Clear();
Response.ContentType = mimeType;
Response.BinaryWrite(renderedBytes);
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
AppClass.CheckUserRightOnPageForFactory(this.Page);
Page.DataBind();
if (drpUserTypes.Items.Count > 0)
{
drpUserTypes_SelectedIndexChanged(null, null);
}
}
}
public string SY_MATERIAL_BZCOUNT_SELECT_LB(string datastring)
{
string token = AppClass.GetSession("token").ToString();
int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID"));
MES_SY_MATERIAL_BZCOUNT model = Newtonsoft.Json.JsonConvert.DeserializeObject <MES_SY_MATERIAL_BZCOUNT>(datastring);
model.STAFFID = STAFFID;
MES_SY_MATERIAL_BZCOUNT_SELECT data = mesmodels.SY_MATERIAL_BZCOUNT.SELECT_LB(model, token);
string rst = Newtonsoft.Json.JsonConvert.SerializeObject(data);
return(rst);
}
public string EXPOST_BZKHREPORT(string datastring, int LB)
{
MES_RETURN_UI rst = new MES_RETURN_UI();
string token = AppClass.GetSession("token").ToString();
int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID"));
HR_SY_DEPT model_HR_SY_DEPT = new HR_SY_DEPT();
model_HR_SY_DEPT.STAFFID = STAFFID;
HR_SY_DEPT_SELECT result = hrmodels.SY_DEPT.SELECT_LB(model_HR_SY_DEPT, LB, token);
if (result.MES_RETURN.TYPE == "E")
{
return(Newtonsoft.Json.JsonConvert.SerializeObject(result.MES_RETURN));
}
try
{
FileStream file = new FileStream(Server.MapPath("~") + @"/Areas/HR/ExportFile/导出模版.xlsx", FileMode.Open, FileAccess.Read);
IWorkbook workbook = new XSSFWorkbook(file);
ISheet sheet = workbook.GetSheetAt(0);
int rowcount = 0;
string tt = "公司,部门,编制人数,";
string[] ttlist = tt.Split(',');
IRow rowtt = sheet.CreateRow(rowcount++);
int cellIndex = 0;
for (int a = 0; a < ttlist.Length; a++)
{
rowtt.CreateCell(cellIndex++).SetCellValue(ttlist[a]);
}
DataTable dtinfo = result.DATALIST;
for (int i = 0; i < dtinfo.Rows.Count; i++)
{
cellIndex = 0;
IRow row = sheet.CreateRow(rowcount++);
row.CreateCell(cellIndex++).SetCellValue(dtinfo.Rows[i]["GSNAME"].ToString());
row.CreateCell(cellIndex++).SetCellValue(dtinfo.Rows[i]["DEPTNAME"].ToString());
row.CreateCell(cellIndex++).SetCellValue(Convert.ToInt32(dtinfo.Rows[i]["DEPTBZRS"].ToString()));
row.CreateCell(cellIndex++).SetCellValue(Convert.ToInt32(dtinfo.Rows[i]["GSBMRYCOUNT"].ToString()));
}
string now = DateTime.Now.ToString("yyyyMMddHHmmss.fff");
FileStream file1 = new FileStream(string.Format(@"{0}/Areas/HR/ExportFile/{1}.xlsx", Server.MapPath("~"), now), FileMode.Create);
workbook.Write(file1);
file1.Close();
rst.TYPE = "S";
rst.MESSAGE = now;
}
catch
{
rst.TYPE = "E";
rst.MESSAGE = "生成文件失败！";
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(rst));
}
public string Data_Select_GC_ROLE()
{
int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID"));
string token = Session["token"].ToString();
MES_SY_GC model = new MES_SY_GC();
model.STAFFID = STAFFID;
MES_SY_GC[] data = mesmodels.SY_GC.SELECT_BY_ROLE(model, token);
string s = Newtonsoft.Json.JsonConvert.SerializeObject(data);
return(s);
}
public string GET_WLLB(string GC, string GZZXBH)
{
string rst = "";
string token = AppClass.GetSession("token").ToString();
MES_SY_GZZX_WLLB model_MES_SY_GZZX_WLLB = new MES_SY_GZZX_WLLB();
model_MES_SY_GZZX_WLLB.GC = GC;
model_MES_SY_GZZX_WLLB.GZZXBH = GZZXBH;
MES_SY_GZZX_WLLB_SELECT rst_MES_SY_GZZX_WLLB_SELECT = mesModels.SY_GZZX_WLLB.SELECT(model_MES_SY_GZZX_WLLB, token);
rst = Newtonsoft.Json.JsonConvert.SerializeObject(rst_MES_SY_GZZX_WLLB_SELECT);
return(rst);
}
public string INSERT_TPM_INFO(string COUNT, string data)
{
string token = AppClass.GetSession("token").ToString();
int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID"));
string STAFFNAME = AppClass.GetSession("NAME").ToString();
ZSL_BCS025 model_TMINFO = Newtonsoft.Json.JsonConvert.DeserializeObject <ZSL_BCS025>(data);
model_TMINFO.CJR = STAFFID;
model_TMINFO.CJRNAME = STAFFNAME;
ZBCFUN_TPINFO_INSERT i = mesModels.MES_TPM.INSERT_TPM(model_TMINFO, COUNT);
return(Newtonsoft.Json.JsonConvert.SerializeObject(i));
}
public string INSERT_TM_WZHM(string datastring)
{
int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID"));
string STAFFNAME = AppClass.GetSession("NAME").ToString();
ZSL_BCT011 model_ZSL_BCT011 = new ZSL_BCT011();
model_ZSL_BCT011.CJR = STAFFID;
model_ZSL_BCT011.CJRNAME = STAFFNAME;
ZSL_BCT012[] model_ZSL_BCT012 = Newtonsoft.Json.JsonConvert.DeserializeObject <ZSL_BCT012[]>(datastring);
ZBCFUN_TP_ZHM_GL res = mesModels.MES_TPM.INSERT_TP_WZHM(model_ZSL_BCT011, model_ZSL_BCT012);
return(Newtonsoft.Json.JsonConvert.SerializeObject(res));
}
public string DELETE_TPM_INFOPL(string datastring)
{
string token = AppClass.GetSession("token").ToString();
ZSL_BCS025[] model_TMINFO = Newtonsoft.Json.JsonConvert.DeserializeObject <ZSL_BCS025[]>(datastring);
ZBCFUN_TPINFO_INSERT DEL = new ZBCFUN_TPINFO_INSERT();
for (int i = 0; i < model_TMINFO.Length; i++)
{
DEL = mesModels.MES_TPM.DELETE_TPM(model_TMINFO[i].TPNO);
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(DEL));
}
public string INSERT_GD(string datastring)
{
string rst = "";
int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID"));
string token = AppClass.GetSession("token").ToString();
MES_PD_GD model_MES_PD_GD = Newtonsoft.Json.JsonConvert.DeserializeObject <MES_PD_GD>(datastring);
model_MES_PD_GD.JLR = STAFFID;
MES_RETURN_UI model_MES_RETURN_UI = mesModels.PD_GD.INSERT_BY_MES(model_MES_PD_GD, token);
rst = Newtonsoft.Json.JsonConvert.SerializeObject(model_MES_RETURN_UI);
return(rst);
}
public string POST_ZFDC_CC(string datastring, string datastring2)
{
string token = AppClass.GetSession("token").ToString();
int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID"));
MES_PD_SCRW_ZXCC_INSERT model = Newtonsoft.Json.JsonConvert.DeserializeObject <MES_PD_SCRW_ZXCC_INSERT>(datastring);
model.JLR = STAFFID;
Sonluk.UI.Model.MES.PD_SCRWService.MES_TM_ZFDCMX[] model2 = Newtonsoft.Json.JsonConvert.DeserializeObject <Sonluk.UI.Model.MES.PD_SCRWService.MES_TM_ZFDCMX[]>(datastring2);
model.MES_TM_ZFDCMX = model2;
MES_RETURN_UI rst = mesModels.PD_SCRW.ZX_CC_NOUPDATE_TIME(model, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rst));
}
private DataSet GetChallanReportDetails(string ChallanNo)
{
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
cmd.CommandText = "Sp_Report_ChallanReport";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Flag", 5);
cmd.Parameters.AddWithValue("@ChallanNumber", ChallanNo);
cmd.Parameters.AddWithValue("@BranchId", Globals.BranchID);
ds = AppClass.GetData(cmd);
return(ds);
}
private void checkrights()
{
bool rights = AppClass.CheckButtonRights(SpecialAccessRightName.LedgerRight);
if (rights == true)
{
btnAddNewLedger.Visible = true;
}
else
{
btnAddNewLedger.Visible = false;
}
}
private DataSet ReturnCustomerDetail(string BookingNo)
{
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_Dry_DrawlMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BookingNumber", BookingNo);
cmd.Parameters.AddWithValue("@BranchId", Globals.BranchID);
cmd.Parameters.AddWithValue("@Flag", 15);
ds = AppClass.GetData(cmd);
return(ds);
}
