コード例 #1
0
        public bool DeactivateAllEmployees()
        {
            sQuery = "update RTM_Master_UserList set MUL_ActiveStatus =0";
            bool result = objDB.DBExecuteNoNQuery(sQuery);

            return(result);
        }
コード例 #2
0
        public bool UpdateRecordLog(string _fileId, string _newValue, string _modifiedBy)
        {
            bool result;

            string sQuery = " update EMSDB_Log set Log_NewValue='" + _newValue + "',Log_ModifiedBy='" + _modifiedBy + "',Log_ModifiedOn='" + DateTime.Now + "' where Log_FileId=" + _fileId + " and Log_NewValue='" + _newValue + "'";

            result = objDB.DBExecuteNoNQuery(sQuery);
            return(result);
        }
コード例 #3
0
    private void PrintReport()
    {
        //DataRow dr;

        // BuildTable();

        ds = getRecords1();

        if (ds.Tables["records"].Rows.Count > 0)
        {
            foreach (DataRow dr1 in ds.Tables["records"].Rows)
            {
                int count = 0;
                ds = getCountOfOrders1(Convert.ToInt32(dr1["R_ID"]));
                if (ds.Tables["count"].Rows.Count > 0)
                {
                    if (ds.Tables["count"].Rows[0]["SKU_IdCount"].ToString().Length > 0)
                    {
                        count = Convert.ToInt32(ds.Tables["count"].Rows[0]["SKU_IdCount"]);
                    }
                }

                SqlParameter[] param = new SqlParameter[]
                {
                    new SqlParameter("@client", dr1["CL_ClientName"].ToString()),
                    new SqlParameter("@task", dr1["TL_Task"].ToString()),
                    new SqlParameter("@subtask", dr1["STL_SubTask"].ToString()),
                    new SqlParameter("@count", count),
                    new SqlParameter("@user", dr1["R_User_Name"].ToString())
                };

                SQlQuery = "INSERT INTO RTM_HourlyTaskTemp (Client, Task, SubTask, CountOfOrders, username) values (@client, @task, @subtask, @count, @user)";
                bool result1 = objDB.ExecuteNonQuery(SQlQuery, CommandType.Text, param);

                //dr = dtResult.NewRow();

                //dr["Client"] = dr1["CL_ClientName"];
                //dr["Task"] = dr1["TL_Task"];
                //dr["SubTask"] = dr1["STL_SubTask"];
                //ds = getCountOfOrders(Convert.ToInt32(dr1["R_ID"]));
                //if (ds.Tables["count"].Rows.Count > 0)
                //{
                //    dr["CountOfOrders"] = ds.Tables["count"].Rows[0]["SKU_IdCount"].ToString();
                //}
                //else
                //{
                //    dr["CountOfOrders"] = "0";
                //}
                //dr["Date"] = txtFrom.Text ;
                //dr["StartTime"] = txtFromTime.Text ;
                //dr["EndTime"] = txtToTime.Text ;

                //dtResult.Rows.Add(dr);
            }
            dt       = new DataTable();
            dt       = getHourlyTasks();
            SQlQuery = "TRUNCATE TABLE RTM_HourlyTaskTemp";
            result   = objDB.DBExecuteNoNQuery(SQlQuery);


            if (dt.Rows.Count > 0)
            {
                Response.Clear();
                Response.Buffer = true;
                Response.AddHeader("content-disposition", "attachment;filename=HourlyTaskReport-(" + Convert.ToDateTime(txtFrom.Text + " " + txtFromTime.Text) + " to " + Convert.ToDateTime(txtFrom.Text + " " + txtFromTime.Text).AddHours(Convert.ToDouble(ddlHours.SelectedItem.Text)) + ") .csv");
                Response.Charset     = "";
                Response.ContentType = "application/text";
                StringBuilder sb = new StringBuilder();
                checked
                {
                    for (int k = 0; k < dt.Columns.Count; k++)
                    {
                        //add separator
                        sb.Append(dt.Columns[k].ColumnName + ',');
                    }
                }

                sb.Append("\r\n");
                checked
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        for (int k = 0; k < dt.Columns.Count; k++)
                        {
                            //add separator
                            sb.Append(dt.Rows[i][k].ToString().Replace(",", ";") + ',');
                        }
                        //append new line
                        sb.Append("\r\n");
                    }
                }


                Response.Output.Write(sb.ToString());
                Response.Flush();
                Response.End();
            }
            else
            {
                lblError.Text      = "No data found";
                lblError.ForeColor = System.Drawing.Color.Red;
            }


            //var query = (from r in dtResult.AsEnumerable()
            //             select new
            //             {
            //                 Client = r.Field<string>("Client"),
            //                 Task = r.Field<string>("Client"),
            //                 SubTask = r.Field<string>("SubTask"),
            //                 CountOfOrders = r.Field<int>("CountOfOrders")
            //             }).Distinct();

            //string strScript;
            //Session["rptSrc"] = dtResult;

            //strScript = "<script language=javascript>window.open('OrderDeskHourlyTaskReportDisplay.aspx')</script>";
            //ClientScript.RegisterClientScriptBlock(this.GetType(), "strScript", strScript);
        }
    }