protected string summary_total_worktime(string cprj, string line) { int temp_totalwtime; int cprjstartct = Convert.ToInt32(cc1.connectionofc008_select("select count(*) as csct from ecsfc929_memb where cprj='" + cprj + "' and line='" + line + "' and code='*'", "csct")); string[] sarray = cc1.connectionofc008_selectasarray("select autm from ecsfc929_memb where cprj='" + cprj + "' and line='" + line + "' and code='*'", "autm", cprjstartct); for (int i = 0; i < cprjstartct; i++) { Global.total_work_time = Global.total_work_time + Convert.ToInt32(sarray[i]); } temp_totalwtime = Global.total_work_time; Global.total_work_time = 0; Global.hour_temp = Convert.ToInt32(temp_totalwtime) / 60; return(Global.hour_temp.ToString("00") + ":" + (Convert.ToInt32(temp_totalwtime) - (Global.hour_temp * 60)).ToString("00")); }
public void ProcessRequest(HttpContext context) { int test; #region 抓取目標tb欄位資料 DataTable dt = new DataTable(); DataColumn column; DataRow row; column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.ColumnName = "empno"; dt.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "name"; dt.Columns.Add(column); string[] earray = cc1.connectionofc008_selectasarray("select empl from ecsfc000_emplrole", "empl", Convert.ToInt32(cc1.connectionofc008_select("select count(*) as cte from ecsfc000_emplrole", "cte"))); string[] col_array = { "empl", "t_name" }; int emplct = Convert.ToInt32(cc1.connectionofc008_select("select count(*) as ct from ecsfc000_emplrole", "ct")); var enarray = cc1.mstrarray("select empl,t_name from ecsfc000_emplrole as t1 inner join ecpsl010 as t2 on t1.empl=t2.t_empl", emplct, col_array); for (int k = 0; k < emplct; k++) { row = dt.NewRow(); row["empno"] = Convert.ToInt32(enarray.Item1[0, k]); row["name"] = enarray.Item1[1, k].ToString(); dt.Rows.Add(row); } //for (int i = 0; i < earray.Length; i++) //{ // row = dt.NewRow(); // row["empno"] = i; // row["name"] = earray[i]; // dt.Rows.Add(row); //} #endregion string result = Newtonsoft.Json.JsonConvert.SerializeObject(dt); context.Response.ContentType = "application/json"; context.Response.Charset = "utf-8"; context.Response.Write(result); }
protected void login_Click(object sender, EventArgs e) { Session["emplnet"] = TextBox1.Text; string me = cc1.connectionofc008_select(string.Format(@"select top 1 line from ( select distinct top 1 line,'2' as sortID from ecsfc929_memb where emno='{0}' union select line,'1' as sortID from ecsfc000_emplrole where empl='{1}') as ut1 where line is not null order by sortID asc", Session["emplnet"], Session["emplnet"]), "line"); if (me == "") {//呼叫前端layer //通知此帳號目前並未設定產線 //請其選取並確認是否更新 string [] lines = cc1.connectionofc008_selectasarray("select distinct line from ecsfc929_memb", "line"); string strLines = string.Join(",", lines); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "lineComfirmTri", "lineComfirmTri('" + strLines + "');", true); } else { Session["gline"] = me; loginEvent(); } }
public void ProcessRequest(HttpContext context) { #region 抓取cprj資料 DataTable dt = new DataTable(); DataColumn column; DataRow row; column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "cprj"; dt.Columns.Add(column); string[] earray = cc1.connectionofc008_selectasarray("select distinct cprj from ecsfc929_memb where code!='*'", "cprj", Convert.ToInt32(cc1.connectionofc008_select("select count(distinct cprj) as cte from ecsfc929_memb where code!='*'", "cte"))); for (int i = 0; i < earray.Length; i++) { row = dt.NewRow(); row["cprj"] = earray[i]; dt.Rows.Add(row); } #endregion string result = Newtonsoft.Json.JsonConvert.SerializeObject(dt); context.Response.ContentType = "application/json"; context.Response.Charset = "utf-8"; context.Response.Write(result); }