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);
}
