public void bindGroups() { ds = new DataSet(); ds = objComm.GetGroups(); gdvGroups.DataSource = ds.Tables[0]; gdvGroups.DataBind(); }
public static DataSet GetDropDownListAllINV_Store() { DataSet iNV_Stores = new DataSet(); SqlINV_StoreProvider sqlINV_StoreProvider = new SqlINV_StoreProvider(); iNV_Stores = sqlINV_StoreProvider.GetDropDownListAllINV_Store(); return iNV_Stores; }
public void bindDropDownList(DropDownList ddl, DataSet ds) { if (ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; int count = dt.Rows.Count; int index = 0; while (index < count) { string str_displayYear = dt.Rows[index][2].ToString().Trim(); string str_displayMonth = dt.Rows[index][1].ToString().Trim(); if (str_displayMonth.Equals("10")) str_displayYear = (int.Parse(str_displayYear) + 1).ToString().Trim(); string str_display = date.getMeetingName(int.Parse(str_displayMonth)) + " " + str_displayYear; ddl.Items.Add(new ListItem(str_display, dt.Rows[index][0].ToString().Trim())); index++; } ddl.Enabled = true; } else { ddl.Items.Add(new ListItem("Not Exist", "-1")); ddl.Enabled = false; } }
public DataSet GetSmtpSettings() { DataSet dsSmtp = new DataSet(); SqlConnection SqlCon = new SqlConnection(ConStr); try { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = SqlCon; sqlCmd.CommandText = "sp_Get_SmtpSettings"; sqlCmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd); sqlDa.Fill(dsSmtp); } catch (SqlException SqlEx) { objNLog.Error("SQLException : " + SqlEx.Message); throw new Exception("Exception re-Raised from DL with SQLError# " + SqlEx.Number + " while Inserting SMTP Settings.", SqlEx); } catch (Exception ex) { objNLog.Error("Exception : " + ex.Message); throw new Exception("**Error occured while Inserting SMTP Settings.", ex); } finally { SqlCon.Close(); } return dsSmtp; }
public static DataSet GetAllINV_StoresWithRelation() { DataSet iNV_Stores = new DataSet(); SqlINV_StoreProvider sqlINV_StoreProvider = new SqlINV_StoreProvider(); iNV_Stores = sqlINV_StoreProvider.GetAllINV_Stores(); return iNV_Stores; }
public static DataSet GetHR_WorkingDaysShiftingEmployeeID(string EmployeeID) { DataSet hR_WorkingDaysShiftings = new DataSet(); SqlHR_WorkingDaysShiftingProvider sqlHR_WorkingDaysShiftingProvider = new SqlHR_WorkingDaysShiftingProvider(); hR_WorkingDaysShiftings = sqlHR_WorkingDaysShiftingProvider.GetHR_WorkingDaysShiftingByEmployeeID(EmployeeID); return hR_WorkingDaysShiftings; }
/// <summary> /// Returns a name for the CellBoundsVariable * ServiceDimensionForCellBoundsVar /// </summary> /// <param name="ds"></param> /// <param name="name"></param> /// <param name="boundsVariableName"></param> /// <returns></returns> private static Tuple<string, string> EnsureAddAxisCellsNames(DataSet ds, string name, string boundsVariableName) { string boundsVarName = boundsVariableName; if (boundsVarName == null) { boundsVarName = string.Format("{0}_bnds", name); if (ds.Variables.Contains(boundsVarName)) { int tryNum = 1; while (ds.Variables.Contains(string.Format("{0}_bnds{1}", boundsVarName, tryNum))) tryNum++; boundsVarName = string.Format("{0}_bnds{1}", boundsVarName, tryNum); } } if (ds.Variables.Contains(boundsVarName)) throw new ArgumentException(string.Format("The dataset is already contains a variable with a name {0}. Please specyfy another one or omit it for automatic name choice", boundsVarName)); string sndDim = "nv"; if (ds.Dimensions.Contains(sndDim) && ds.Dimensions[sndDim].Length != 2) { int num = 1; while (ds.Dimensions.Contains(string.Format("{0}{1}", sndDim, num))) num++; sndDim = string.Format("{0}{1}", sndDim, num); } return Tuple.Create(boundsVarName, sndDim); }
public static DataSet GetAllHR_WorkingDaysShiftingsWithRelation() { DataSet hR_WorkingDaysShiftings = new DataSet(); SqlHR_WorkingDaysShiftingProvider sqlHR_WorkingDaysShiftingProvider = new SqlHR_WorkingDaysShiftingProvider(); hR_WorkingDaysShiftings = sqlHR_WorkingDaysShiftingProvider.GetAllHR_WorkingDaysShiftings(); return hR_WorkingDaysShiftings; }
public static DataSet GetDropDownListAllHR_WorkingDaysShifting() { DataSet hR_WorkingDaysShiftings = new DataSet(); SqlHR_WorkingDaysShiftingProvider sqlHR_WorkingDaysShiftingProvider = new SqlHR_WorkingDaysShiftingProvider(); hR_WorkingDaysShiftings = sqlHR_WorkingDaysShiftingProvider.GetDropDownLisAllHR_WorkingDaysShifting(); return hR_WorkingDaysShiftings; }
protected void Fill_User_Header() { DataView view = null; SqlConnection con; SqlCommand cmd = new SqlCommand(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); System.Configuration.Configuration rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/BitOp"); System.Configuration.ConnectionStringSettings connString; connString = rootWebConfig.ConnectionStrings.ConnectionStrings["BopDBConnectionString"]; con = new SqlConnection(connString.ToString()); cmd.Connection = con; con.Open(); string sql = @"SELECT Fecha_Desde, Inicio_Nombre, Region, Supervisor FROM Criterios WHERE Criterio_ID = " + @Criterio_ID; SqlDataAdapter da = new SqlDataAdapter(sql, con); da.Fill(ds); dt = ds.Tables[0]; view = new DataView(dt); foreach (DataRowView row in view) { Lbl_Fecha_Desde.Text = row["Fecha_Desde"].ToString("dd-MM-yyyy"); Lbl_Inicio_Descrip.Text = row["Inicio_Nombre"].ToString(); Lbl_Region.Text = row["Region"].ToString(); Lbl_Supervisor.Text = row["Supervisor"].ToString(); } con.Close(); }
public static string PublishActivity(int ClubId, string ActivityContent) { // 将新增活动存入数据库,并从数据库返回信息及数据 string connString = System.Configuration.ConfigurationManager.ConnectionStrings["CZConnectionString"].ConnectionString; SqlConnection conn = new SqlConnection(connString); conn.Open(); // 存储 string PublishDate = DateTime.Now.ToString(); string queryString1 = "Insert Into Activity Values (" + ClubId + ",N'" + ActivityContent + "','" + PublishDate + "')"; SqlCommand cmd = new SqlCommand(queryString1, conn); cmd.ExecuteNonQuery(); // 查询最后插入的数据,就是新的数据 string queryString2 = "Select Top 1 * From Activity Where ClubId=" + ClubId + " Order By PublishDate Desc"; cmd = new SqlCommand(queryString2, conn); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adapter.Fill(ds); int Id = Convert.ToInt32(ds.Tables[0].Rows[0]["Id"].ToString()); string Content = ds.Tables[0].Rows[0]["Content"].ToString(); string Date = ds.Tables[0].Rows[0]["PublishDate"].ToString(); conn.Close(); // 通过判断前后时间知是否查入成功 if (PublishDate == Date) { return "{status:1,id:" + Id + ",content:'" + Content + "',date:'" + Date + "'}"; } else { return "{status:-1}"; } }
/// <summary> /// 生成手机密码:通过用户编号 /// </summary> /// <param name="sUserNo">用户编号</param> /// <returns>已生成手机密码的用户的手机号</returns> public string GenerateSMP(string sUserNo) { Random r1 = new Random(); int iRandomPassword; string sRandomPassword,SM_content,mobile_telephone,sOperCode; DataSet ds=new DataSet(); //生成密码 iRandomPassword = r1.Next(1000000); sRandomPassword = fu.PasswordEncode(iRandomPassword.ToString()); ds = fu.GetOneUserByUserIndex(sUserNo); sOperCode = ds.Tables[0].Rows[0]["User_code"].ToString(); mobile_telephone = ds.Tables[0].Rows[0]["mobile_telephone"].ToString(); sSql = "UPDATE Frame_user SET SM_PWD='" + sRandomPassword + "',SMP_last_change_time=getdate()" + " WHERE User_code = '" + sOperCode + "'"; sv.ExecuteSql(sSql); //发送密码 string SMP_validity_period = ds.Tables[0].Rows[0]["SMP_validity_period"].ToString(); SM_content = "欢迎您使用EBM系统!您新的手机密码是:" + iRandomPassword.ToString() + "有效时间为:" + SMP_validity_period + "小时。"; SendSMContentByPhoneCode(mobile_telephone, SM_content); return mobile_telephone; }
protected void btnOK_Click(object sender, EventArgs e) { string ID; SqlConnection mycon = new SqlConnection(ConfigurationManager.AppSettings["conStr"]); mycon.Open(); DataSet mydataset = new DataSet(); SqlDataAdapter mydataadapter = new SqlDataAdapter("select * from tb_Blog where UserName='******'", mycon); mydataadapter.Fill(mydataset, "tb_Blog"); DataRowView rowview = mydataset.Tables["tb_Blog"].DefaultView[0]; ID = rowview["BlogID"].ToString(); string P_str_Com = "Insert into tb_Message(FriendName,Sex,HomePhone,MobilePhone,QQ,ICQ,Address,Birthday,Email,PostCode,BlogID,IP)" +" values ('"+this.txtName.Text+"','"+this.DropDownList1.SelectedValue+"','"+this.txtHphone.Text+"'" +",'"+this.txtMphone.Text+"','"+this.txtQQ.Text+"','"+this.txtICQ.Text+"','"+this.txtAddress.Text+"'" +",'"+this.txtBirthday.Text+"','"+this.txtEmail.Text+"','"+this.txtPostCode.Text+"','"+ID+"','"+Request.UserHostAddress+"')"; SqlData da = new SqlData(); if (!ValidateDate1(txtBirthday.Text) && !ValidateDate2(txtBirthday.Text) && !ValidateDate3(txtBirthday.Text)) { Response.Write("<script language=javascript>alert('输入的日期格式有误!');location='javascript:history.go(-1)'</script>"); } else { bool add = da.ExceSQL(P_str_Com); if (add == true) { Response.Write("<script language=javascript>alert('添加成功!');location='AddLinkMan.aspx'</script>"); } else { Response.Write("<script language=javascript>alert('添加失败!');location='javascript:history.go(-1)'</script>"); } } }
public static DataSet GetDropDownListAllLIB_SubCategory(int CategoryID) { DataSet lIB_SubCategories = new DataSet(); SqlLIB_SubCategoryProvider sqlLIB_SubCategoryProvider = new SqlLIB_SubCategoryProvider(); lIB_SubCategories = sqlLIB_SubCategoryProvider.GetDropDownLisAllLIB_SubCategory(CategoryID); return lIB_SubCategories; }
// To get 'SubMenu' record of 'Active' or 'Inactive' from database by stored procedure public DataTable LoadActiveSubMenu(bool IsActive,int LoggedInUser, string RetMsg) { SqlConnection Conn = new SqlConnection(ConnString); // 'uspGetSubMenuDetails' stored procedure is used to get specific records from SubMenu table SqlDataAdapter DAdapter = new SqlDataAdapter("uspGetSubMenuDetails", Conn); DAdapter.SelectCommand.CommandType = CommandType.StoredProcedure; DataSet DSet = new DataSet(); try { DAdapter.SelectCommand.Parameters.AddWithValue("@IsActive", IsActive); DAdapter.SelectCommand.Parameters.AddWithValue("@LoggedInUser", LoggedInUser); DAdapter.SelectCommand.Parameters.AddWithValue("@RetMsg", RetMsg); DAdapter.Fill(DSet, "Masters.SubMenu"); return DSet.Tables["Masters.SubMenu"]; } catch { throw; } finally { DSet.Dispose(); DAdapter.Dispose(); Conn.Close(); Conn.Dispose(); } }
public static DataSet CustomQuery(string sQuery) { DataSet ds = new DataSet(); SqlDataAdapter sda = new SqlDataAdapter(sQuery, sConnection); sda.Fill(ds); return ds; }
public static DataSet GetAllLIB_SubCategoriesWithRelation() { DataSet lIB_SubCategories = new DataSet(); SqlLIB_SubCategoryProvider sqlLIB_SubCategoryProvider = new SqlLIB_SubCategoryProvider(); lIB_SubCategories = sqlLIB_SubCategoryProvider.GetAllLIB_SubCategories(); return lIB_SubCategories; }
protected void Submit_Click(object sender, EventArgs e) { string strConn = WebConfigurationManager.ConnectionStrings["dmtucaoConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(strConn); con.Open(); SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [User] WHERE [username]='" + Session["UserName"] + "'", con); SqlCommandBuilder scb = new SqlCommandBuilder(da); DataSet ds = new DataSet(); da.Fill(ds, "user"); if (ds.Tables["user"].Rows.Count > 0) { ds.Tables["user"].Rows[0]["face"] = FaceUrl.Text; ds.Tables["user"].Rows[0]["sex"] = Sex.SelectedIndex; ds.Tables["user"].Rows[0]["email"] = Email.Text; ds.Tables["user"].Rows[0]["qq"] = QQ.Text; ds.Tables["user"].Rows[0]["telephone"] = PhoneNumber.Text; ds.Tables["user"].Rows[0]["birthday"] = Birthday.Text; ds.Tables["user"].Rows[0]["introduction"] = Introduction.Text; if (da.Update(ds, "user") == 1) ClientScript.RegisterStartupScript(GetType(), "成功", "<script>alert('修改成功');location.reload();</script>"); } con.Close(); con = null; return; }
private static DataSet FindBooks(string filePath, string searchString) { searchString = searchString .Replace("%", "!%") .Replace("'", "!'") .Replace("\"", "!\"") .Replace("_", "!_") .ToLower(); SQLiteConnection connection = GetConnection(filePath); connection.Open(); using (connection) { DataSet dataSet = new DataSet(); SQLiteDataAdapter adapter = new SQLiteDataAdapter( string.Format( @"SELECT BookTitle, BookAuthor FROM Books WHERE LOWER(BookTitle) LIKE '%{0}%' ESCAPE '!'", searchString), connection); adapter.Fill(dataSet); return dataSet; } }
public static string[] GetCompletionList(string prefixText, int count) { //連線字串 //string connStr = @"Data Source=.\SQLEXPRESS;AttachDbFilename=" //+ System.Web.HttpContext.Current.Server.MapPath("~/App_Data/NorthwindChinese.mdf") + ";Integrated Security=True;User Instance=True"; ArrayList array = new ArrayList();//儲存撈出來的字串集合 //using (SqlConnection conn = new SqlConnection(connStr)) using (SqlConnection conn = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString)) { DataSet ds = new DataSet(); string selectStr = @"SELECT Top (" + count + ") Account_numbers FROM Account_Order_M_View Where Account_numbers Like '" + prefixText + "%'"; SqlDataAdapter da = new SqlDataAdapter(selectStr, conn); conn.Open(); da.Fill(ds); foreach (DataRow dr in ds.Tables[0].Rows) { array.Add(dr["Account_numbers"].ToString()); } } return (string[])array.ToArray(typeof(string)); }
public DataSet GetDataSet(string filepath, string excelFileExtension) { try { System.Data.OleDb.OleDbConnection oledbcon = null; string strConn = string.Empty; switch (excelFileExtension.Trim()) { case "xls": oledbcon = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties=\"Excel 8.0;HDR=No;IMEX=1;MaxScanRows=0;\""); strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filepath + ";" + "Extended Properties=Excel 8.0;"; break; case "xlsx": oledbcon = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties='Excel 12.0;HDR=No;IMEX=1'"); strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties=Excel 12.0;"; break; } //excel OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); DataTable dtSheetName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" }); string sheetName = dtSheetName.Rows[0]["TABLE_NAME"].ToString(); System.Data.OleDb.OleDbDataAdapter oledbAdaptor = new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM [" + sheetName + "]", oledbcon); //select DataSet ds = new DataSet(); oledbAdaptor.Fill(ds); oledbcon.Close(); return ds; } catch (Exception ex) { throw ex; } }
public static DataSet GetDropDownListAllHR_SalaryIncrement() { DataSet hR_SalaryIncrements = new DataSet(); SqlHR_SalaryIncrementProvider sqlHR_SalaryIncrementProvider = new SqlHR_SalaryIncrementProvider(); hR_SalaryIncrements = sqlHR_SalaryIncrementProvider.GetDropDownListAllHR_SalaryIncrement(); return hR_SalaryIncrements; }
//--------------------------------- protected internal DataSet getProductById(int id) { try { Open(); DataSet dataset = new DataSet(); SqlCommand cmd = new SqlCommand(); cmd.Connection = DataBase; cmd.CommandText = "Get_FeatProduct_By_ID"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@id", SqlDbType.Int); //Setting values to Parameters. cmd.Parameters[0].Value = id; SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(dataset); cmd.Dispose(); Close(); return dataset; } catch (SqlException oSqlExp) { //Console.WriteLine("" + oSqlExp.Message); return null; } catch (Exception oEx) { //Console.WriteLine("" + oEx.Message); return null; } }
public static DataSet GetDropDownListAllSTD_ClassSubjectEmployee() { DataSet sTD_ClassSubjectEmployees = new DataSet(); SqlSTD_ClassSubjectEmployeeProvider sqlSTD_ClassSubjectEmployeeProvider = new SqlSTD_ClassSubjectEmployeeProvider(); sTD_ClassSubjectEmployees = sqlSTD_ClassSubjectEmployeeProvider.GetDropDownListAllSTD_ClassSubjectEmployee(); return sTD_ClassSubjectEmployees; }
public static DataSet GetSTD_ClassSubjectByClassSubjectID(int ClassSubjectID,bool isDataset) { DataSet sTD_ClassSubjectEmployee = new DataSet(); SqlSTD_ClassSubjectEmployeeProvider sqlSTD_ClassSubjectEmployeeProvider = new SqlSTD_ClassSubjectEmployeeProvider(); sTD_ClassSubjectEmployee = sqlSTD_ClassSubjectEmployeeProvider.GetSTD_ClassSubjectEmployeeByClassSubjectID(ClassSubjectID,isDataset); return sTD_ClassSubjectEmployee; }
public DataSet BindGrandChild(int nid) { SqlDataAdapter da = new SqlDataAdapter("select NEWS_ID, CHANNEL_ID , USERID, TIEUDE, NGAY, STT, CAP_ID from TINTUC01_ENG where MENU_SUB = 1 and NHOM = "+nid+" order by STT", con); DataSet ds = new DataSet(); da.Fill(ds); return ds; }
protected void btnsubmit_Click(object sender, EventArgs e) { BALLogin objloginbal = new BALLogin(); DALLogin objlogindal = new DALLogin(); objloginbal.UserName = Session["username"].ToString(); objloginbal.Password = txtoldpassword.Text; DataSet ds = new DataSet(); ds=objlogindal.ValidateLogin(objloginbal); if(ds.Tables[0].Rows.Count>0) { objloginbal.LoginId = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString()); objloginbal.Password = txtnewpassword.Text; objlogindal.ChangePassword(objloginbal); Response.Write("<script>alert('Password Changed');</script>"); } else { Response.Write("<script>alert('Invalid Login Details');</script>"); } }
public static DataSet GetAllHR_SalaryIncrementsWithRelation() { DataSet hR_SalaryIncrements = new DataSet(); SqlHR_SalaryIncrementProvider sqlHR_SalaryIncrementProvider = new SqlHR_SalaryIncrementProvider(); hR_SalaryIncrements = sqlHR_SalaryIncrementProvider.GetAllHR_SalaryIncrements(); return hR_SalaryIncrements; }
public DataSet BindChild(int stt) { SqlDataAdapter da = new SqlDataAdapter("select NEWS_ID, TIEUDE, USERID, CHANNEL_ID, MENU_SUB, NGAY, STT, CAP_ID from TINTUC01_ENG where MENU_SUB = 0 and CHANNEL_ID = "+stt+" order by STT", con); DataSet ds = new DataSet(); da.Fill(ds); return ds; }
private void Load_Friends_And_Contacts() { localhostWebService.WebService service = new localhostWebService.WebService(); DataSet dataSet = new DataSet(); dataSet = service.GetFriendsAndContacts(user); Session["DataSet"] = dataSet; }
//Activate This Construntor to log All To Standard output //public TestClass():base(true){} //Activate this constructor to log Failures to a log file //public TestClass(System.IO.TextWriter tw):base(tw, false){} //Activate this constructor to log All to a log file //public TestClass(System.IO.TextWriter tw):base(tw, true){} //BY DEFAULT LOGGING IS DONE TO THE STANDARD OUTPUT ONLY FOR FAILURES public void run() { Exception exp = null; Exception tmpEx = new Exception(); DataSet ds = new DataSet(); ds.Tables.Add(GHTUtils.DataProvider.CreateParentDataTable()); ds.Tables.Add(GHTUtils.DataProvider.CreateChildDataTable()); ds.Relations.Add(new DataRelation("myRelation", ds.Tables[0].Columns[0], ds.Tables[1].Columns[0])); DataRow drParent = ds.Tables[0].Rows[0]; DataRow drChild = ds.Tables[1].Rows[0]; drParent.Delete(); drChild.Delete(); ds.AcceptChanges(); try { BeginCase("RowNotInTableException - AcceptChanges"); try { drParent.AcceptChanges(); } catch (RowNotInTableException ex) { tmpEx = ex; } base.Compare(tmpEx.GetType(), typeof(RowNotInTableException)); tmpEx = new Exception(); } catch (Exception ex) { exp = ex; } finally { EndCase(exp); exp = null; } try { BeginCase("RowNotInTableException - GetChildRows"); try { drParent.GetChildRows("myRelation"); } catch (RowNotInTableException ex) { tmpEx = ex; } base.Compare(tmpEx.GetType(), typeof(RowNotInTableException)); tmpEx = new Exception(); } catch (Exception ex) { exp = ex; } finally { EndCase(exp); exp = null; } try { BeginCase("RowNotInTableException - ItemArray"); object[] o = null; try { o = drParent.ItemArray; } catch (RowNotInTableException ex) { tmpEx = ex; } base.Compare(tmpEx.GetType(), typeof(RowNotInTableException)); tmpEx = new Exception(); } catch (Exception ex) { exp = ex; } finally { EndCase(exp); exp = null; } // ********** don't throw exception (should be according to MSDN) *********************** // try // { // BeginCase("RowNotInTableException - GetParentRow"); // DataRow dr = null; // try // { // dr = drChild.GetParentRow("myRelation"); // } // catch (RowNotInTableException ex) // { // tmpEx = ex; // } // base.Compare(tmpEx.GetType(),typeof(RowNotInTableException)); // tmpEx = new Exception(); // } // catch(Exception ex) {exp = ex;} // finally {EndCase(exp); exp = null;} try { BeginCase("RowNotInTableException - GetParentRows"); DataRow[] dr = null; try { dr = drChild.GetParentRows("myRelation"); } catch (RowNotInTableException ex) { tmpEx = ex; } base.Compare(tmpEx.GetType(), typeof(RowNotInTableException)); tmpEx = new Exception(); } catch (Exception ex) { exp = ex; } finally { EndCase(exp); exp = null; } try { BeginCase("RowNotInTableException - RejectChanges"); try { drParent.RejectChanges(); } catch (RowNotInTableException ex) { tmpEx = ex; } base.Compare(tmpEx.GetType(), typeof(RowNotInTableException)); tmpEx = new Exception(); } catch (Exception ex) { exp = ex; } finally { EndCase(exp); exp = null; } try { BeginCase("RowNotInTableException - SetParentRow"); try { drChild.SetParentRow(ds.Tables[0].Rows[1]); } catch (RowNotInTableException ex) { tmpEx = ex; } base.Compare(tmpEx.GetType(), typeof(RowNotInTableException)); tmpEx = new Exception(); } catch (Exception ex) { exp = ex; } finally { EndCase(exp); exp = null; } }
/// <summary> /// 获取案件目录 /// </summary> /// <param name="Request"></param> /// <param name="isAll">是否获取所有目录,false为只有已分配的</param> /// <param name="isChecked">是否默认选中</param> /// <returns></returns> public string GetMlTreeEx(System.Web.HttpRequest Request, bool isAll, bool isChecked) { string bmsah = HttpUtility.UrlDecode(HttpUtility.UrlDecode(Request.Form["bmsah"])); string parneid = Request["pid"]; string ischecked = Request["ischecked"]; string yjxh = Request["yjxh"] ?? ""; string strMlWhere = " and SFSC='N'"; string where = " and level < 3"; string withWhere = " and FMLBH is null"; object[] values = new object[2]; if (!string.IsNullOrEmpty(bmsah)) { strMlWhere += " and BMSAH=:BMSAH"; values[0] = bmsah; } //判断存在父级编码 if (!string.IsNullOrEmpty(parneid)) { withWhere = " and FMLBH =:FMLBH"; values[1] = parneid; } EDRS.BLL.YX_DZJZ_JZML bll = new EDRS.BLL.YX_DZJZ_JZML(Request); DataSet ds = bll.GetListByTreeEx(strMlWhere, where, withWhere, true, StringPlus.ReplaceSingle(yjxh), isAll, values); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0].Copy(); dt.Columns["MLBH"].ColumnName = "ID"; dt.Columns["FMLBH"].ColumnName = "PARENTID"; dt.Columns["MLXSMC"].ColumnName = "NAME"; if (isChecked) { dt.Columns["ISEXIST"].ColumnName = "ischecked"; } dt.Columns.Add("icon"); foreach (DataRow dr in dt.Rows) { switch (int.Parse(dr["MLLX"].ToString())) { case 1: dr["icon"] = "jicon"; break; case 2: dr["icon"] = "mlicon"; break; case 3: dr["icon"] = "yicon"; break; case 4: dr["icon"] = "wjicon"; break; } if (dr["wjxhjl"] != null && dr["wjxhjl"].ToString() != "") dr["ischecked"] = 1; else dr["ischecked"] = DBNull.Value; } Dictionary<string, string> styleValues = new Dictionary<string, string>(); styleValues.Add("Y", "color:blue;"); string json = new TreeJson(dt, "ID", "NAME", "PARENTID", "", "", parneid ?? "", true, true, "SFSM", styleValues, (ischecked == "true" ? true : false)).ResultJson.ToString(); return json; } return ReturnString.JsonToString(Prompt.error, "未找到相关目录!", null); }
}//Main() public static void TableProcessURI ( ref OleDbConnection oleDbConnection, String selectQuery, String filenameHtml, String filenameText, String filenameXsd, String filenameXml, String filenameXml2, String filenameStylesheet ) { DataColumn dataColumnDated = null; DataColumn dataColumnKeyword = null; DataColumn dataColumnTitle = null; DataColumn dataColumnURI = null; DataSet dataSet = null; DataTable dataTable = null; String exceptionMessage = null; String keyword = null; String title = null; String uri = null; String xmlProcessingInstructionText = null; OleDbCommand oleDbCommand = null; IDataAdapter oleDataAdapter = null; IDataReader dataReader = null; //System.IO.FileStream fileStream = null; TextWriter objTextWriterHtml = null; TextWriter objTextWriterText = null; UniqueConstraint uniqueConstraint = null; Uri objUri = null; XmlNode xmlNodeDocumentType = null; XmlNode xmlNodeRoot = null; XmlDocument xmlDocument = null; XmlProcessingInstruction xmlProcessingInstruction = null; XmlTextWriter xmlTextWriter = null; try { UtilityDatabase.DatabaseQuery ( DatabaseConnectionString, ref exceptionMessage, ref dataSet, selectQuery, CommandType.Text ); dataSet.DataSetName = "addresses"; dataSet.Tables[0].TableName = "address"; UtilityXml.WriteXml ( dataSet, ref exceptionMessage, ref filenameXml, ref filenameStylesheet ); }//try catch (XmlException exception) { System.Console.WriteLine("Uri: {0} | Exception: {1}", title, exception.Message); }//catch catch (Exception exception) { System.Console.WriteLine("Uri: {0} | Exception: {1}", title, exception.Message); }//catch finally { } //finally } //TableProcessURI
public DataSet GetParticipantSummary(string catNo, string activeParticips, string loggedInUser, out Int32 iErrorId) { ds = new DataSet(); try { OpenConnection(out iErrorId, out sErrorMsg); orlDA = new OracleDataAdapter(); ErrorId = new OracleParameter(); OracleParameter pCatNo = new OracleParameter(); OracleParameter pActiveParticips = new OracleParameter(); OracleParameter pLoggedInUser = new OracleParameter(); OracleParameter pCatStatusList = new OracleParameter(); OracleParameter pISRCStatusList = new OracleParameter(); OracleParameter pCatDetails = new OracleParameter(); OracleParameter pParticipSummaryDetails = new OracleParameter(); OracleParameter pOptionPeriodList = new OracleParameter(); OracleParameter pSellerGroupList = new OracleParameter(); OracleParameter pEscCodeList = new OracleParameter(); orlCmd = new OracleCommand("pkg_participant_summary.p_get_particip_summary", orlConn); orlCmd.CommandType = System.Data.CommandType.StoredProcedure; pCatNo.OracleDbType = OracleDbType.Varchar2; pCatNo.Direction = ParameterDirection.Input; pCatNo.Value = catNo; orlCmd.Parameters.Add(pCatNo); pActiveParticips.OracleDbType = OracleDbType.Varchar2; pActiveParticips.Direction = ParameterDirection.Input; pActiveParticips.Value = activeParticips; orlCmd.Parameters.Add(pActiveParticips); pLoggedInUser.OracleDbType = OracleDbType.Varchar2; pLoggedInUser.Direction = ParameterDirection.Input; pLoggedInUser.Value = loggedInUser; orlCmd.Parameters.Add(pLoggedInUser); pCatStatusList.OracleDbType = OracleDbType.RefCursor; pCatStatusList.Direction = System.Data.ParameterDirection.Output; orlCmd.Parameters.Add(pCatStatusList); pISRCStatusList.OracleDbType = OracleDbType.RefCursor; pISRCStatusList.Direction = System.Data.ParameterDirection.Output; orlCmd.Parameters.Add(pISRCStatusList); pCatDetails.OracleDbType = OracleDbType.RefCursor; pCatDetails.Direction = System.Data.ParameterDirection.Output; orlCmd.Parameters.Add(pCatDetails); pParticipSummaryDetails.OracleDbType = OracleDbType.RefCursor; pParticipSummaryDetails.Direction = System.Data.ParameterDirection.Output; orlCmd.Parameters.Add(pParticipSummaryDetails); pOptionPeriodList.OracleDbType = OracleDbType.RefCursor; pOptionPeriodList.Direction = System.Data.ParameterDirection.Output; orlCmd.Parameters.Add(pOptionPeriodList); pSellerGroupList.OracleDbType = OracleDbType.RefCursor; pSellerGroupList.Direction = System.Data.ParameterDirection.Output; orlCmd.Parameters.Add(pSellerGroupList); pEscCodeList.OracleDbType = OracleDbType.RefCursor; pEscCodeList.Direction = System.Data.ParameterDirection.Output; orlCmd.Parameters.Add(pEscCodeList); ErrorId.OracleDbType = OracleDbType.Int32; ErrorId.Direction = ParameterDirection.Output; ErrorId.ParameterName = "ErrorId"; orlCmd.Parameters.Add(ErrorId); orlDA = new OracleDataAdapter(orlCmd); orlDA.Fill(ds); iErrorId = Convert.ToInt32(orlCmd.Parameters["ErrorId"].Value.ToString()); } catch (Exception ex) { iErrorId = 2; } finally { CloseConnection(); } return(ds); }
public DataSet SaveParticipantDetails(string catNo, string catStatusCode, string isCatModified, Array participantsToAddUpdate, string activeParticips, string userCode, string userRoleId, out Int32 iErrorId) { ds = new DataSet(); try { OpenConnection(out iErrorId, out sErrorMsg); orlDA = new OracleDataAdapter(); ErrorId = new OracleParameter(); OracleParameter pCatNo = new OracleParameter(); OracleParameter pCatStatusCode = new OracleParameter(); OracleParameter pIsCatModified = new OracleParameter(); OracleParameter pAddUpdateList = new OracleParameter(); OracleParameter pActiveParticips = new OracleParameter(); OracleParameter pUserCode = new OracleParameter(); OracleParameter pLoggedInUserRoleId = new OracleParameter(); OracleParameter pCatlogueData = new OracleParameter(); OracleParameter pParticipantsData = new OracleParameter(); orlCmd = new OracleCommand("pkg_participant_summary.p_save_participant_details", orlConn); orlCmd.CommandType = System.Data.CommandType.StoredProcedure; pCatNo.OracleDbType = OracleDbType.Varchar2; pCatNo.Direction = ParameterDirection.Input; pCatNo.Value = catNo; orlCmd.Parameters.Add(pCatNo); pCatStatusCode.OracleDbType = OracleDbType.Varchar2; pCatStatusCode.Direction = ParameterDirection.Input; pCatStatusCode.Value = catStatusCode; orlCmd.Parameters.Add(pCatStatusCode); pIsCatModified.OracleDbType = OracleDbType.Varchar2; pIsCatModified.Direction = ParameterDirection.Input; pIsCatModified.Value = isCatModified; orlCmd.Parameters.Add(pIsCatModified); pAddUpdateList.OracleDbType = OracleDbType.Varchar2; pAddUpdateList.Direction = ParameterDirection.Input; pAddUpdateList.CollectionType = OracleCollectionType.PLSQLAssociativeArray; if (participantsToAddUpdate.Length == 0) { pAddUpdateList.Size = 1; pAddUpdateList.Value = new OracleDecimal[1] { OracleDecimal.Null }; } else { pAddUpdateList.Size = participantsToAddUpdate.Length; pAddUpdateList.Value = participantsToAddUpdate; } orlCmd.Parameters.Add(pAddUpdateList); pActiveParticips.OracleDbType = OracleDbType.Varchar2; pActiveParticips.Direction = ParameterDirection.Input; pActiveParticips.Value = activeParticips; orlCmd.Parameters.Add(pActiveParticips); pUserCode.OracleDbType = OracleDbType.Varchar2; pUserCode.Direction = ParameterDirection.Input; pUserCode.Value = userCode; orlCmd.Parameters.Add(pUserCode); pLoggedInUserRoleId.OracleDbType = OracleDbType.Varchar2; pLoggedInUserRoleId.Direction = ParameterDirection.Input; pLoggedInUserRoleId.Value = userRoleId; orlCmd.Parameters.Add(pLoggedInUserRoleId); pCatlogueData.OracleDbType = OracleDbType.RefCursor; pCatlogueData.Direction = System.Data.ParameterDirection.Output; orlCmd.Parameters.Add(pCatlogueData); pParticipantsData.OracleDbType = OracleDbType.RefCursor; pParticipantsData.Direction = System.Data.ParameterDirection.Output; orlCmd.Parameters.Add(pParticipantsData); ErrorId.OracleDbType = OracleDbType.Int32; ErrorId.Direction = ParameterDirection.Output; ErrorId.ParameterName = "ErrorId"; orlCmd.Parameters.Add(ErrorId); orlDA = new OracleDataAdapter(orlCmd); orlDA.Fill(ds); iErrorId = Convert.ToInt32(orlCmd.Parameters["ErrorId"].Value.ToString()); } catch (Exception ex) { iErrorId = 2; } finally { CloseConnection(); } return(ds); }
public ActionResult ProfileEdit1(User user) { string fileName = ""; string filePath = ""; var file = user.File[0]; string query = ""; try { if (file != null && file.ContentLength > 0) { fileName = Path.GetFileName(file.FileName); filePath = Path.Combine(Server.MapPath("~/images"), fileName); file.SaveAs(filePath); string toSave = "~/images/" + fileName; if (!string.IsNullOrEmpty(user.password)) { if (user.password == user.confirmPassword) { user.password = hashing.SHA512(user.password); query = "UPDATE USERS SET PASSWORD = '******', photo = '" + toSave + "', bio = '" + user.bio + "' WHERE USERNAME = '******'"; } else { TempData["password"] = "******"; return View("~/Views/Profile/ProfileEdit.cshtml", user); } } else { query = "UPDATE USERS SET photo = '" + toSave + "', bio = '" + user.bio + "' WHERE USERNAME = '******'"; } } else { if (!string.IsNullOrEmpty(user.password)) { if (user.password == user.confirmPassword) { user.password = hashing.SHA512(user.password); query = "UPDATE USERS SET PASSWORD = '******', bio = '" + user.bio + "' WHERE USERNAME = '******'"; } else { TempData["password"] = "******"; return View("~/Views/Profile/ProfileEdit.cshtml", user); } } else { query = "UPDATE USERS SET bio = '" + user.bio + "' WHERE USERNAME = '******'"; } } } catch { } DatabaseModel databaseModel = new DatabaseModel(); databaseModel.update(query); DatabaseModel databaseModel1 = new DatabaseModel(); User user1 = new User(); query = "SELECT *FROM USERS WHERE USERID = " + (int)System.Web.HttpContext.Current.Session["Id"]; DataSet dataSet = new DataSet(); dataSet = databaseModel1.selectFunction(query); LoginModel loginModel = new LoginModel(); loginModel.userid = Convert.ToInt32(dataSet.Tables[0].Rows[0].ItemArray[0]); loginModel.username = dataSet.Tables[0].Rows[0].ItemArray[1].ToString(); loginModel.path = dataSet.Tables[0].Rows[0].ItemArray[4].ToString(); LoginAndBookList loginAndBookList = new LoginAndBookList(); loginAndBookList.loginModel = loginModel; int id = (int)System.Web.HttpContext.Current.Session["Id"]; return RedirectToAction("Profile", "Profile", new { id = id }); }
/// <summary> /// 显示标签列表 /// </summary> private void Dispaly_TagsList(string pageContent) { string tagsHtml; int pageIndex; int.TryParse(request.QueryString["page"], out pageIndex); if (pageIndex < 1) { pageIndex = 1; } StringBuilder sb = new StringBuilder(); Regex reg = new Regex("\\$\\{([a-zA-Z]+)\\}"); DataSet ds = new DataSet(); ds.ReadXml(configPath); /* * //获取分页链接 * for (int i = 0; i < ps.PageCount; i++) * { * sb.Append("<a href=\"?page=").Append((i + 1).ToString()).Append("\"") * .Append(i == pageIndex - 1 ? " style=\"background:white;color:black;text-decoration:none\"" : "").Append(">") * .Append((i + 1).ToString()).Append("</a>"); * } * * pagerHtml = sb.ToString(); * sb.Remove(0, sb.Length); */ if (Tags.Tags.Count > 0) { foreach (Tag tag in Tags.Tags) { sb.Append("<tr><td class=\"center\"><input type=\"checkbox\" class=\"ck\" name=\"ck") .Append(tag.Indent.ToString()).Append("\" indent=\"").Append(tag.Indent.ToString()).Append("\"/></td>") .Append("<td class=\"center\">").Append(tag.Name).Append("</td><td>") .Append(tag.LinkUri).Append("</td><td>") .Append(tag.Description).Append("</td><td class=\"center\"><a href=\"javascript:;\" onclick=\"edit(this)\">修改</a></td></tr>"); } tagsHtml = sb.ToString(); } else { tagsHtml = "<tr><td colspan=\"5\" class=\"center\">暂无tags!</td></tr>"; } string html = reg.Replace(pageContent, match => { switch (match.Groups[1].Value) { default: return(null); case "css": return(ReturnStyleLink()); case "tagsHtml": return(tagsHtml); case "pagetext": return(""); } }); response.Write(html); }
protected void Page_Load(object sender, EventArgs e) { //using (SqlConnection conexao_SQL = new SqlConnection(acroni.classes.Conexao.nome_conexao)) //{ // try // { // if (conexao_SQL.State != ConnectionState.Open) // conexao_SQL.Open(); // String select = "SELECT imagem_teclado FROM tblTecladoCustomizado t INNER JOIN tblCliente c ON c.id_cliente = t.id_cliente AND usuario = '" + Session["usuario"] + "'"; // using (SqlCommand comando_sql = new SqlCommand(select, conexao_SQL)) // { // using (SqlDataReader tabela = comando_sql.ExecuteReader()) // { // tabela.Read(); // byte[] imgBytes = (byte[])tabela[0]; // string imgString = Convert.ToBase64String(imgBytes); // imgFoto.ImageUrl = "data:image/png;base64," + imgString; // conexao_SQL.Close(); // } // } // String select2 = "SELECT nickname FROM tblTecladoCustomizado t INNER JOIN tblCliente c ON c.id_cliente = t.id_cliente AND usuario = '" + Session["usuario"] + "'"; // if (conexao_SQL.State != ConnectionState.Open) // conexao_SQL.Open(); // using (SqlCommand comando_sql = new SqlCommand(select2, conexao_SQL)) // { // using (SqlDataReader tabela2 = comando_sql.ExecuteReader()) // { // tabela2.Read(); // //byte[] nomeBytes = (byte[])tabela2[0]; // //string nomeString = Convert.ToBase64String(nomeBytes); // lblNome.Text = tabela2[0].ToString(); // conexao_SQL.Close(); // } // } // } // catch (Exception ex) // { // conexao_SQL.Close(); // } //} using (SqlConnection conexao_SQL = new SqlConnection(Conexao.nome_conexao)) { try { if (!Page.IsPostBack) { if (conexao_SQL.State != ConnectionState.Open) { conexao_SQL.Open(); } //string id = Request.QueryString["id"]; //String select = "SELECT * FROM tblTecladoCustomizado t INNER JOIN tblCliente c ON c.id_cliente = t.id_cliente AND usuario='" + Session["usuario"] + "' AND id_colecao = @id_colecao"; //String select2 = "SELECT * FROM tblTecladoCustomizado t INNER JOIN tblCliente c ON c.id_cliente = t.id_cliente AND usuario = '" + Session["usuario"] + "'"; //using (SqlCommand comando_SQL = new SqlCommand(select, conexao_SQL)) //{ // comando_SQL.Parameters.Add("@id_colecao", SqlDbType.Int).Value = Int32.Parse(id); // using (SqlDataReader tabela = comando_SQL.ExecuteReader()) // { // tabela.Read(); // if (tabela.HasRows) // { // using (SqlDataAdapter da = new SqlDataAdapter(select2, conexao_SQL)) // { // ds = new DataSet(); // da.Fill(ds); // DataList1.DataSource = ds.Tables[0]; // DataList1.DataBind(); // } // } // } //} string CurrentUrl = HttpContext.Current.Request.Url.AbsoluteUri; CurrentUrl = CurrentUrl.Substring(CurrentUrl.LastIndexOf("=") + 1); //string id = Request.QueryString["id"]; String select = "SELECT * FROM tblTecladoCustomizado t INNER JOIN tblCliente c ON c.id_cliente = t.id_cliente AND usuario='" + Session["usuario"] + "' AND id_colecao =" + CurrentUrl; using (SqlDataAdapter da = new SqlDataAdapter(select, conexao_SQL)) { //da.SelectCommand.Parameters.AddWithValue("@id_colecao", "%" + id + "%"); ds = new DataSet(); da.Fill(ds); DataList1.DataSource = ds.Tables[0]; DataList1.DataBind(); } } } catch (Exception ex) { conexao_SQL.Close(); } //string s = Page.Request.Url.AbsolutePath; //s = s.Substring(s.LastIndexOf("/") + 1); //string CurrentUrl = HttpContext.Current.Request.Url.AbsoluteUri; //CurrentUrl = CurrentUrl.Substring(CurrentUrl.LastIndexOf("=") + 1); ////s = Form.Attributes["action"].ToString(); //lblhue.Text = CurrentUrl; } }
public void StartTestAction() { Control.dateTimeCreatedXls = dataSourceReport + DateTime.Now.ToString("ddMMyyyy_HHmmss") + ".xls"; Control.actionPath = ""; Control.tempNum = 0; int a = 0; xConfiguration._xCreateExcelFile(Control.dateTimeCreatedXls); dsConfiguration = xConfiguration._xReadExcelFile(dataSourceConfiguration); for (; a < dsConfiguration.Tables[0].Rows.Count; a++) { BeforeAll(a); Control xControl = new Control(); Control.insertText = ""; //Assign last feature (Login, PremiumSimulation, etc) Control.lastFeatureAction = xConfiguration._xReplaceSpecialChars(dsConfiguration.Tables[0].Rows[a]["Scenario"].ToString()); maxDataCounter = 1; if (dsConfiguration.Tables[0].Rows[a]["Data"] != null && dsConfiguration.Tables[0].Rows[a]["Data"].ToString().Length > 1) { dsData = xConfiguration._xReadExcelFile(dsConfiguration.Tables[0].Rows[a]["Data"].ToString()); maxDataCounter = dsData.Tables[0].Rows.Count; } for (int d = 0; d < maxDataCounter; d++) { Control.successFlag = 1; if (d == 0) { //Create sheet in report xConfiguration._xCreateSheetExcelFile(Control.dateTimeCreatedXls, Control.lastFeatureAction); tempSheetName = Control.lastFeatureAction; } else { //Create sheet in report Control.lastFeatureAction = tempSheetName + "_" + (d + 1).ToString(); xConfiguration._xCreateSheetExcelFile(Control.dateTimeCreatedXls, Control.lastFeatureAction); } //Read pathfile scenario xls dsScenario = xConfiguration._xReadExcelFile(dsConfiguration.Tables[0].Rows[a]["PathFile"].ToString()); //Add By Ferie lblScenario.Text = Control.lastFeatureAction; InsertDetailScenario(Control.lastFeatureAction); if (txtLoopingCount.Text == "1" && TotalDataScenario == 1) { lblTotalScenario.Text = (a + 1).ToString() + " / " + dsConfiguration.Tables[0].Rows.Count.ToString(); } else if (txtLoopingCount.Text != "1" && TotalDataScenario == 1) { lblTotalScenario.Text = count.ToString() + " / " + ((dsConfiguration.Tables[0].Rows.Count * LoopingCount).ToString()); } else if (txtLoopingCount.Text == "1" && TotalDataScenario > 1 || txtLoopingCount.Text != "1" && TotalDataScenario > 1) { lblTotalScenario.Text = count.ToString() + " / " + ((TotalDataScenario * LoopingCount).ToString()); } Application.DoEvents(); for (int b = 0; b < dsScenario.Tables[0].Rows.Count; b++) { //Add by Ferie progressBar2.Value = b + 1; progressBar2.Maximum = dsScenario.Tables[0].Rows.Count; lblStep.Text = dsScenario.Tables[0].Rows[b]["Action"].ToString(); lblTotalStep.Text = (b + 1).ToString() + " / " + dsScenario.Tables[0].Rows.Count.ToString(); lblPercentageCurrentStep.Text = (Math.Round(((double)progressBar2.Value / (double)progressBar2.Maximum), 2) * 100).ToString() + "%"; UpdateDetailScenario(lblPercentageCurrentStep.Text, count, 2); Application.DoEvents(); if (dsConfiguration.Tables[0].Rows[a]["Platform"].ToString().ToUpper().Equals("ANDROID")) { AndroidAction AndroidStart = new AndroidAction(); AndroidStart.StartTestAction(b, d); } else if (dsConfiguration.Tables[0].Rows[a]["Platform"].ToString().ToUpper().Equals("IOS")) { iOSAction iOSStart = new iOSAction(); iOSStart.StartTestAction(b, d); } else if (dsConfiguration.Tables[0].Rows[a]["Platform"].ToString().ToUpper().Equals("WEB")) { WebAction WebStart = new WebAction(); WebStart.StartTestAction(b, d); } #region b dalam //if (!dsScenario.Tables[0].Columns.Contains("Skip") || (dsScenario.Tables[0].Columns.Contains("Skip") && !dsScenario.Tables[0].Rows[b]["Skip"].ToString().ToUpper().Equals("YES"))) //{ // //Pengecekkan Looping(Compare nilai pada tiap iterasi) // if (dsScenario.Tables[0].Rows[b]["Value"] != null && dsScenario.Tables[0].Rows[b]["Value"].ToString().Length > 0 && dsScenario.Tables[0].Rows[b]["Value"].ToString()[0].Equals('$')) // { // dsScenario.Tables[0].Rows[b]["Value"] = dsData.Tables[0].Rows[d][dsScenario.Tables[0].Rows[b]["Value"].ToString().Substring(1, dsScenario.Tables[0].Rows[b]["Value"].ToString().Length - 1)]; // } // if (dsScenario.Tables[0].Rows[b]["ResultExpectation"] != null && dsScenario.Tables[0].Rows[b]["ResultExpectation"].ToString().Length > 0 && dsScenario.Tables[0].Rows[b]["ResultExpectation"].ToString()[0].Equals('$')) // { // dsScenario.Tables[0].Rows[b]["ResultExpectation"] = dsData.Tables[0].Rows[d][dsScenario.Tables[0].Rows[b]["ResultExpectation"].ToString().Substring(1, dsScenario.Tables[0].Rows[b]["ResultExpectation"].ToString().Length - 1)]; // } // if (dsScenario.Tables[0].Rows[b]["Key"] != null && dsScenario.Tables[0].Rows[b]["Key"].ToString().Length > 0 && dsScenario.Tables[0].Rows[b]["Key"].ToString()[0].Equals('$')) // { // dsScenario.Tables[0].Rows[b]["Key"] = dsData.Tables[0].Rows[d][dsScenario.Tables[0].Rows[b]["Key"].ToString().Substring(1, dsScenario.Tables[0].Rows[b]["Key"].ToString().Length - 1)]; // } // if (dsScenario.Tables[0].Rows[b]["ResourceId"] != null && dsScenario.Tables[0].Rows[b]["ResourceId"].ToString().Length > 0 && dsScenario.Tables[0].Rows[b]["ResourceId"].ToString()[0].Equals('$')) // { // //dsScenario.Tables[0].Rows[b]["ResourceId"] = dsMasterResourceId.Tables[0].Select("Variable = " + dsScenario.Tables[0].Rows[b]["ResourceId"].ToString()).ToString(); // DataRow dr = dsMasterResourceId.Tables[0].Select("Variable = '" + dsScenario.Tables[0].Rows[b]["ResourceId"].ToString() + "'")[0]; // dsScenario.Tables[0].Rows[b]["ResourceId"] = dr["ResourceId"].ToString(); // } // string tempChecking = ""; // if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("PATH") && dsScenario.Tables[0].Rows[b]["Class"].ToString().ToUpper() != null && dsScenario.Tables[0].Rows[b]["Class"].ToString().Length > 1) // { // tempChecking = xControl._xCheckBuildPath(dsScenario.Tables[0].Rows[b], b, true); // } // if (!dsScenario.Tables[0].Rows[b]["Action"].ToString().ToUpper().Equals("WAIT") && !dsScenario.Tables[0].Rows[b]["Action"].ToString().ToUpper().Equals("CHECKNOTEXIST") && (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("PATH")) && (dsScenario.Tables[0].Rows[b]["Class"].ToString().Length > 1) && !Control._xCheckBaseClass(tempChecking, waitSeconds, dsScenario.Tables[0].Rows[b]["Type"].ToString())) // { // int c, flagAlternate = 0; // dsBaseAlternateClass = xConfiguration._xReadAlternateClass(dataSourceBaseAlternateClass, dsScenario.Tables[0].Rows[b]["Class"].ToString()); // if (dsBaseAlternateClass.Tables[0].Rows.Count > 0) // { // string tempClass = dsScenario.Tables[0].Rows[b]["Class"].ToString(); // for (c = 0; c < dsBaseAlternateClass.Tables[0].Rows.Count; c++) // { // dsScenario.Tables[0].Rows[b]["Class"] = dsBaseAlternateClass.Tables[0].Rows[c]["AlternateClass"].ToString(); // tempChecking = xControl._xCheckBuildPath(dsScenario.Tables[0].Rows[b], b, true); // if (Control._xCheckBaseClass(tempChecking, waitSeconds, dsScenario.Tables[0].Rows[b]["Type"].ToString())) // { // flagAlternate = 1; // break; // } // } // if (c == dsBaseAlternateClass.Tables[0].Rows.Count && !dsScenario.Tables[0].Rows[b]["Action"].ToString().ToUpper().Equals("CHECKNOTEXIST")) // { // dsScenario.Tables[0].Rows[b]["Class"] = tempClass; // xControl._xNoClassSupported(dsScenario.Tables[0].Rows[b]["Class"].ToString()); // } // else if (flagAlternate != 1 && !dsScenario.Tables[0].Rows[b]["Action"].ToString().ToUpper().Equals("CHECKNOTEXIST")) // { // xControl._xNoClassSupported(dsScenario.Tables[0].Rows[b]["Class"].ToString()); // } // } // else // { // xControl._xNoClassOrElement(dsScenario.Tables[0].Rows[b]["Action"].ToString()); // } // } // string[] elementClass = dsScenario.Tables[0].Rows[b]["Class"].ToString().Split(Control.delimiterChar); // switch (dsScenario.Tables[0].Rows[b]["Action"].ToString().ToUpper()) // { // //definition of each action by its type // case "WRITE": // if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("ELEMENT")) // { // xControl._xWriteByElementId(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["ResourceId"].ToString(), dsScenario.Tables[0].Rows[b]["Value"].ToString(), dsScenario.Tables[0].Rows[b]["Type"].ToString(), waitSeconds); // break; // } // else if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("PATH")) // { // xControl._xWriteByXPath(dsScenario.Tables[0].Rows[b]["Action"].ToString(), xControl._xCheckBuildPath(dsScenario.Tables[0].Rows[b], b, false), dsScenario.Tables[0].Rows[b]["Value"].ToString(), dsScenario.Tables[0].Rows[b]["Type"].ToString(), waitSeconds); // break; // } // break; // case "CLICK": // if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("ELEMENT")) // { // xControl._xClickByElementId(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["ResourceId"].ToString(), dsScenario.Tables[0].Rows[b]["Type"].ToString(), waitSeconds); // break; // } // else if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("PATH")) // { // xControl._xClickByXPath(dsScenario.Tables[0].Rows[b]["Action"].ToString(), xControl._xCheckBuildPath(dsScenario.Tables[0].Rows[b], b, false), dsScenario.Tables[0].Rows[b]["Type"].ToString(), waitSeconds); // break; // } // break; // case "SWIPE": xControl._xSwipe(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["Value"].ToString()); // break; // case "SWIPEUP": xControl._xSwipeUp(dsScenario.Tables[0].Rows[b]["Action"].ToString(), Convert.ToInt32(dsScenario.Tables[0].Rows[b]["Value"].ToString())); // break; // case "SWIPEDOWN": xControl._xSwipeDown(dsScenario.Tables[0].Rows[b]["Action"].ToString(), Convert.ToInt32(dsScenario.Tables[0].Rows[b]["Value"].ToString())); // break; // case "SWIPERIGHT": xControl._xSwipeRight(dsScenario.Tables[0].Rows[b]["Action"].ToString(), Convert.ToInt32(dsScenario.Tables[0].Rows[b]["Value"].ToString())); // break; // case "SWIPELEFT": xControl._xSwipeLeft(dsScenario.Tables[0].Rows[b]["Action"].ToString(), Convert.ToInt32(dsScenario.Tables[0].Rows[b]["Value"].ToString())); // break; // case "DATESWIPEUP": xControl._xDateSwipeUp(dsScenario.Tables[0].Rows[b]["Value"].ToString()); // break; // case "DATESWIPEDOWN": xControl._xDateSwipeDown(dsScenario.Tables[0].Rows[b]["Value"].ToString()); // break; // case "SCREENSHOT": xControl._xScreenShot(dsScenario.Tables[0].Rows[b]["Action"].ToString()); // break; // case "WAIT": // if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("ELEMENT")) // xControl._xWaitUntil(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["ResourceId"].ToString(), Convert.ToInt32(dsScenario.Tables[0].Rows[b]["Value"]), dsScenario.Tables[0].Rows[b]["Type"].ToString()); // else if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("PATH")) // xControl._xWaitUntil(dsScenario.Tables[0].Rows[b]["Action"].ToString(), xControl._xCheckBuildPath(dsScenario.Tables[0].Rows[b], b, false), Convert.ToInt32(dsScenario.Tables[0].Rows[b]["Value"]), dsScenario.Tables[0].Rows[b]["Type"].ToString()); // break; // case "DELAY": xControl._xDelay(dsScenario.Tables[0].Rows[b]["Action"].ToString(), Convert.ToInt32(dsScenario.Tables[0].Rows[b]["Value"])); // break; // case "CHECKRESULT": // if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("ELEMENT")) // { // xControl._xCheckResultById(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["ResourceId"].ToString(), dsScenario.Tables[0].Rows[b]["ResultExpectation"].ToString(), elementClass[2].ToString()); // break; // } // else if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("PATH")) // { // xControl._xCheckResultByXPath(dsScenario.Tables[0].Rows[b]["Action"].ToString(), xControl._xCheckBuildPath(dsScenario.Tables[0].Rows[b], b, false), dsScenario.Tables[0].Rows[b]["ResultExpectation"].ToString(), elementClass[2].ToString()); // break; // } // break; // case "PRESSKEYENTER": xControl._xPressKeyCode(dsScenario.Tables[0].Rows[b]["Action"].ToString(), 66); // break; // case "BUILDPATH": Control.actionPath += xControl._xComposeString(dsScenario.Tables[0].Rows[b], b); // break; // case "CHECKEXIST": // if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("ELEMENT")) // { // xControl._xCheckExistByElementId(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["ResourceId"].ToString()); // break; // } // else if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("PATH")) // { // xControl._xCheckExistByXpath(dsScenario.Tables[0].Rows[b]["Action"].ToString(), xControl._xCheckBuildPath(dsScenario.Tables[0].Rows[b], b, false)); // break; // } // break; // case "GET": // if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("ELEMENT")) // { // xControl._xGetByElementId(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["ResourceId"].ToString(), dsScenario.Tables[0].Rows[b]["ResultExpectation"].ToString(), dsScenario.Tables[0].Rows[b]["Type"].ToString(), waitSeconds); // break; // } // else if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("PATH")) // { // xControl._xGetElementByXPath(dsScenario.Tables[0].Rows[b]["Action"].ToString(), xControl._xCheckBuildPath(dsScenario.Tables[0].Rows[b], b, false), dsScenario.Tables[0].Rows[b]["ResultExpectation"].ToString(), dsScenario.Tables[0].Rows[b]["Type"].ToString(), waitSeconds); // break; // } // break; // case "POST": // if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("ELEMENT")) // { // xControl._xPostByElementId(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["ResourceId"].ToString(), dsScenario.Tables[0].Rows[b]["Value"].ToString(), dsScenario.Tables[0].Rows[b]["Type"].ToString(), waitSeconds); // break; // } // else if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("PATH")) // { // xControl._xPostByXPath(dsScenario.Tables[0].Rows[b]["Action"].ToString(), xControl._xCheckBuildPath(dsScenario.Tables[0].Rows[b], b, false), dsScenario.Tables[0].Rows[b]["Value"].ToString(), dsScenario.Tables[0].Rows[b]["Type"].ToString(), waitSeconds); // break; // } // break; // case "BACK": xControl._xBackDriver(dsScenario.Tables[0].Rows[b]["Action"].ToString()); // break; // case "SWIPENOTIFICATION": xControl._xSwipeNotificationBar(dsScenario.Tables[0].Rows[b]["Action"].ToString()); // break; // case "CHECKTOAST": xControl._xCheckToast(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["ResultExpectation"].ToString()); // break; // //Forbidden only few devices supported, bad effect is disconecting adb driver to appium server. // case "NETWORK": xControl._xNetworkChange(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["Value"].ToString()); // break; // case "DELETETEXT": // if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("ELEMENT")) // { // xControl._xDeleteTextByElementId(dsScenario.Tables[0].Rows[b]["ResourceId"].ToString(), dsScenario.Tables[0].Rows[b]["Action"].ToString(), Convert.ToInt32(dsScenario.Tables[0].Rows[b]["Value"].ToString())); // break; // } // else if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("PATH")) // { // xControl._xDeleteTextByXPath(xControl._xCheckBuildPath(dsScenario.Tables[0].Rows[b], b, false), dsScenario.Tables[0].Rows[b]["Action"].ToString(), Convert.ToInt32(dsScenario.Tables[0].Rows[b]["Value"].ToString())); // break; // } // break; // case "COMPAREIMAGE": xControl._xScreenShot(dsScenario.Tables[0].Rows[b]["Action"].ToString()); // break; // case "CHECKCOLOR": xControl._xScreenShot(dsScenario.Tables[0].Rows[b]["Action"].ToString()); // break; // case "ZOOM": // if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("ELEMENT")) // { // xControl._xZoomByElementId(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["ResourceId"].ToString()); // } // else if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("PATH")) // { // xControl._xZoomByXPath(dsScenario.Tables[0].Rows[b]["Action"].ToString(), xControl._xCheckBuildPath(dsScenario.Tables[0].Rows[b], b, false)); // } // break; // case "LONGCLICK": // if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("ELEMENT")) // { // xControl._xLongPressByElementId(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["ResourceId"].ToString(), 1000); // } // else if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("PATH")) // { // xControl._xLongPressByXPath(dsScenario.Tables[0].Rows[b]["Action"].ToString(), xControl._xCheckBuildPath(dsScenario.Tables[0].Rows[b], b, false), 1000); // } // break; // case "SORT": // xControl._xCheckSorted(dsScenario.Tables[0].Rows[b]["Action"].ToString(), xControl._xCheckBuildPath(dsScenario.Tables[0].Rows[b], b, false), dsScenario.Tables[0].Rows[b]["Value"].ToString()); // break; // case "CHECKACTIVEDIRECTORY": // xControl._xCheckUserAD(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["Value"].ToString()); // break; // case "CHECKSCREENORIENTATION": // xControl._xCheckPortrait(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["ResultExpectation"].ToString()); // break; // case "RATE": // if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("ELEMENT")) // { // xControl._xRateByElementId(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["ResourceId"].ToString(), Convert.ToInt32(dsScenario.Tables[0].Rows[b]["Value"].ToString())); // } // else if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("PATH")) // { // xControl._xRateByXPath(dsScenario.Tables[0].Rows[b]["Action"].ToString(), xControl._xCheckBuildPath(dsScenario.Tables[0].Rows[b], b, false), Convert.ToInt32(dsScenario.Tables[0].Rows[b]["Value"].ToString())); // } // break; // case "CHECKNOTEXIST": // if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("ELEMENT")) // { // xControl._xCheckNotExistByElementId(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["ResourceId"].ToString()); // break; // } // else if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("PATH")) // { // xControl._xCheckNotExistByXPath(dsScenario.Tables[0].Rows[b]["Action"].ToString(), xControl._xCheckBuildPath(dsScenario.Tables[0].Rows[b], b, false)); // break; // } // break; // //Add By Ferie // case "DBGET": // _xDBControl._xDBGet(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["ConnectionString"].ToString(), dsScenario.Tables[0].Rows[b]["SQL"].ToString(), dsScenario.Tables[0].Rows[b]["ResultVariable"].ToString()); // break; // case "DBPOST": // if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("ELEMENT")) // { // _xDBControl._xDBPostByElementId(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["ResourceId"].ToString(), dsScenario.Tables[0].Rows[b]["Value"].ToString(), dsScenario.Tables[0].Rows[b]["Type"].ToString(), waitSeconds); // break; // } // else if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("PATH")) // { // _xDBControl._xDBPostByXPath(dsScenario.Tables[0].Rows[b]["Action"].ToString(), xControl._xCheckBuildPath(dsScenario.Tables[0].Rows[b], b, false), dsScenario.Tables[0].Rows[b]["Value"].ToString(), dsScenario.Tables[0].Rows[b]["Type"].ToString(), waitSeconds); // break; // } // break; // case "DBEXECUTE": // _xDBControl._xDBExec(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["ConnectionString"].ToString(), dsScenario.Tables[0].Rows[b]["SQL"].ToString()); // break; // case "CHECKENABLED": // if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("ELEMENT")) // { // xControl._xCheckEnabledByElementId(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["ResourceId"].ToString(), dsScenario.Tables[0].Rows[b]["Type"].ToString(), waitSeconds, dsScenario.Tables[0].Rows[b]["ResultExpectation"].ToString()); // break; // } // else if (dsScenario.Tables[0].Rows[b]["Type"].ToString().ToUpper().Equals("PATH")) // { // xControl._xCheckEnabledByXPath(dsScenario.Tables[0].Rows[b]["Action"].ToString(), xControl._xCheckBuildPath(dsScenario.Tables[0].Rows[b], b, false), dsScenario.Tables[0].Rows[b]["Type"].ToString(), waitSeconds, dsScenario.Tables[0].Rows[b]["ResultExpectation"].ToString()); // break; // } // break; // default: xControl._xNoActionSupported(dsScenario.Tables[0].Rows[b]["Action"].ToString(), dsScenario.Tables[0].Rows[b]["ResourceId"].ToString()); // break; // } //} #endregion } if (maxDataCounter > 1) { if (Control.successFlag == 1) { LoopResult[a, d] = LoopResult[a, d] + "Success; "; } else { LoopResult[a, d] = LoopResult[a, d] + "Failed; "; } xConfiguration._xUpdateDataResult(dsConfiguration.Tables[0].Rows[a]["Data"].ToString(), dsData, d, LoopResult[a, d]); } //Add By Ferie UpdateDetailScenario(Control.successFlag.ToString(), count, 3); if (totalFailed >= 0 && totalSuccess >= 0) { lblTotalFailed.Text = totalFailed.ToString(); lblTotalSuccess.Text = totalSuccess.ToString(); Application.DoEvents(); } if (txtLoopingCount.Text == "1" && TotalDataScenario > 1 || txtLoopingCount.Text != "1" && TotalDataScenario > 1) { progressBar1.Value = count; progressBar1.Maximum = (TotalDataScenario * LoopingCount); } lblPercentScenario.Text = (Math.Round(((double)progressBar1.Value / (double)progressBar1.Maximum), 2) * 100).ToString() + "%"; Application.DoEvents(); Control.myDictionary.Clear(); }//Batas Loop "d" if (Control.successFlag == 1) { Result[a] = Result[a] + "Success; "; } else { Result[a] = Result[a] + "Failed; "; } Control.successFlag = 1; //Add by Ferie if (txtLoopingCount.Text == "1" && TotalDataScenario == 1) { progressBar1.Value = a + 1; progressBar1.Maximum = dsConfiguration.Tables[0].Rows.Count; } else if (txtLoopingCount.Text != "1" && TotalDataScenario == 1) { progressBar1.Value = count; progressBar1.Maximum = dsConfiguration.Tables[0].Rows.Count * LoopingCount; } lblPercentScenario.Text = (Math.Round(((double)progressBar1.Value / (double)progressBar1.Maximum), 2) * 100).ToString() + "%"; Application.DoEvents(); #region CSV /* CSV * foreach (string line in testCase) * { * string[] testCommand = line.Split(','); * switch (testCommand[1]) * { * case "Write": xControl._xWriteByElementId(testCommand[4].ToString(), testCommand[5].ToString()); * break; * case "Click": xControl._xClickByElementId(testCommand[4].ToString()); * break; * case "Screenshot": xControl._xScreenShot(); * break; * } * } * //xControl._xWriteByElementId("com.aab.mobilesalesnative:id/etUser", "*****@*****.**"); * //xControl._xWriteByElementId("com.aab.mobilesalesnative:id/etPassword", "qwerty1234"); * //xControl._xClickByElementId("com.aab.mobilesalesnative:id/btnLogin"); * xControl._xScreenShot(); * xControl._xWaitUntil("//android.widget.ImageView[contains(@resource-id, 'android:id/up')]", 500); * */ #endregion xConfiguration._xUpdate(dataSourceConfiguration, "Scenario", dsConfiguration.Tables[0].Rows[a]["No"].ToString(), dsConfiguration.Tables[0].Rows[a]["Scenario"].ToString(), Result[a]); dsScenario.Clear(); } dsConfiguration.Clear(); }
public static void GetProjectPlan(string queryString, string frmtext, OracleCommandBuilder builder, DataSet myDS, DataGridView dgv, OracleDataAdapter adapter, BindingSource bdsource, BindingNavigator bdn) { //OracleConnection conn = new OracleConnection(DataAccess.OIDSConnStr);//获得conn连接 //conn.Open(); //OracleCommand cmd = new OracleCommand(queryString, conn); //cmd.CommandType = System.Data.CommandType.StoredProcedure; //OracleParameter pram = new OracleParameter("V_CS", OracleType.Cursor); //pram.Direction = System.Data.ParameterDirection.Output; //cmd.Parameters.Add(pram); //cmd.Parameters.Add("formtext_in", OracleType.VarChar).Value = frmtext; //cmd.Parameters["formtext_in"].Direction = System.Data.ParameterDirection.Input; ////OracleDataAdapter adapter = new OracleDataAdapter(cmd); //myDS = new DataSet(); //adapter = new OracleDataAdapter(cmd); //builder = new OracleCommandBuilder(adapter); ////adapter.FillSchema( //adapter.Fill(myDS); ////BindingSource bds = new BindingSource(); //bdsource.DataSource = myDS.Tables[0]; //dgv.DataSource = bdsource; //bdn.BindingSource = bdsource; ////dgv.DataSource = myDS.Tables["plantable"]; //myDS.Dispose(); }
/// <summary> /// 得到一个对象实体 /// </summary> public DigiPower.Onlinecol.Standard.Model.T_Question_MDL GetModel(int QuestionID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 QuestionID,SingleProjectID,QuestionTypeCode,FileListID,Title,Description,CreateUserID,CreateUserName,CreateDate,AnswerCount,ClickCount,AttachName,AttachPath,ReadFlag,DescriptionHtml from T_Question "); strSql.Append(" where QuestionID=@QuestionID "); SqlParameter[] parameters = { new SqlParameter("@QuestionID", SqlDbType.Int,8)}; parameters[0].Value = QuestionID; DigiPower.Onlinecol.Standard.Model.T_Question_MDL model = new DigiPower.Onlinecol.Standard.Model.T_Question_MDL(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["QuestionID"].ToString() != "") { model.QuestionID = int.Parse(ds.Tables[0].Rows[0]["QuestionID"].ToString()); } if (ds.Tables[0].Rows[0]["SingleProjectID"].ToString() != "") { model.SingleProjectID = int.Parse(ds.Tables[0].Rows[0]["SingleProjectID"].ToString()); } if (ds.Tables[0].Rows[0]["FileListID"].ToString() != "") { model.FileListID = int.Parse(ds.Tables[0].Rows[0]["FileListID"].ToString()); } model.QuestionTypeCode = ds.Tables[0].Rows[0]["QuestionTypeCode"].ToString(); model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); model.Description = ds.Tables[0].Rows[0]["Description"].ToString(); if (ds.Tables[0].Rows[0]["CreateUserID"].ToString() != "") { model.CreateUserID = int.Parse(ds.Tables[0].Rows[0]["CreateUserID"].ToString()); } model.CreateUserName = ds.Tables[0].Rows[0]["CreateUserName"].ToString(); if (ds.Tables[0].Rows[0]["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString()); } if (ds.Tables[0].Rows[0]["AnswerCount"].ToString() != "") { model.AnswerCount = int.Parse(ds.Tables[0].Rows[0]["AnswerCount"].ToString()); } if (ds.Tables[0].Rows[0]["ClickCount"].ToString() != "") { model.ClickCount = int.Parse(ds.Tables[0].Rows[0]["ClickCount"].ToString()); } model.AttachName = ds.Tables[0].Rows[0]["AttachName"].ToString(); model.AttachPath = ds.Tables[0].Rows[0]["AttachPath"].ToString(); if (ds.Tables[0].Rows[0]["ReadFlag"].ToString() != "") { if ((ds.Tables[0].Rows[0]["ReadFlag"].ToString() == "1") || (ds.Tables[0].Rows[0]["ReadFlag"].ToString().ToLower() == "true")) { model.ReadFlag = true; } else { model.ReadFlag = false; } } model.DescriptionHtml = ds.Tables[0].Rows[0]["DescriptionHtml"].ToString(); return model; } else { return null; } }
public FamilyTemplateReferencePlaneViewModel(DataSet dataSet, SQLiteConnection sQLiteConnection, User user, object application) : base(dataSet, sQLiteConnection, user, application) { InternalDataView = InternalDataSet.Tables[TableNames.FF_FamilyTemplateReferencePlanes.ToString()].DefaultView; RefreshCollections(); }
protected void Wizard1_FinishButtonClick(object sender, WizardNavigationEventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { DAO_Assign_Doc DAO = new DAO_Assign_Doc(); ArrayList lstDoc = new ArrayList(); ArrayList lstDoc1 = new ArrayList(); lstDoc = (ArrayList)Session["SelectedDocList"]; lbAllSelectedDocuments.Items.Clear(); int order = 0; string[] arrSpeciality = new string[1000]; string[] arrNode = new string[1000]; int count = 0; ArrayList lstRemoved = (ArrayList)Session["RemovedDoc"]; for (int i = 0; i < lstRemoved.Count; i++) { DAO_Assign_Doc dao = new DAO_Assign_Doc(); dao = (DAO_Assign_Doc)lstRemoved[i]; objBillSysDocBO.RemoveSpecialityDoc(dao.SelectedSpecialityID, txtCompanyID.Text, dao.SelectedId); } lstRemoved.Clear(); for (int i = 0; i < lstDoc.Count; i++) { int iflag = 0; DAO = (DAO_Assign_Doc)lstDoc[i]; string[] selectedNode = new string[500]; selectedNode = hfselectedNodeinListbox.Value.Split(','); for (int j = 0; j < selectedNode.Length - 1; j++) { if (!selectedNode[j].Equals("") && selectedNode[j].Split('~')[1].Equals(DAO.SelectedId) && selectedNode[j].Split('~')[0].Equals(DAO.SelectedSpecialityID)) { objBillSysDocBO.AssignDocToSpeciality(selectedNode[j].Split('~')[1], ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID, DAO.SelectedSpecialityID, txtCompanyID.Text, DAO.ORDER, true); iflag = 1; DAO.REQUIRED_MULTIPLE = true; arrSpeciality[i] = DAO.SelectedSpecialityID; arrNode[i] = selectedNode[j].Split('~')[1]; count++; } order = DAO.ORDER; } if (iflag == 0) { objBillSysDocBO.AssignDocToSpeciality(DAO.SelectedId, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID, DAO.SelectedSpecialityID, txtCompanyID.Text, DAO.ORDER, false); DAO.REQUIRED_MULTIPLE = false; arrSpeciality[i] = DAO.SelectedSpecialityID; arrNode[i] = DAO.SelectedId; count++; } lstDoc1.Add(DAO); } DataSet ds = new DataSet(); //ds = objBillSysDocBO.GetSecialityDoc(txtCompanyID.Text, arrSpeciality[0]); //for (int i = 0; i < ds.Tables[0].Rows.Count; i++) //{ // int flag = 0; // for (int j = 0; j < count; j++) // { // if ((Convert.ToInt32(ds.Tables[0].Rows[i][0]) == Convert.ToInt32(arrNode[j])) && ds.Tables[0].Rows[i][1].Equals(arrSpeciality[j])) // { // flag = 1; // } // } // if (flag == 0) // { // if (arrSpeciality[i] == null) // { // break; // } // else // { // objBillSysDocBO.RemoveSpecialityDoc(arrSpeciality[i], txtCompanyID.Text, arrNode[i]); // } // } // ds = objBillSysDocBO.GetSecialityDoc(txtCompanyID.Text, arrSpeciality[i]); //} Session["SelectedDocList"] = lstDoc1; //lblmsg.Text = "Documents Saved Successfully!"; lstDoc = (ArrayList)Session["SelectedDocList"]; lbAllSelectedDocuments.Items.Clear(); lbselect.Items.Clear(); if (lstDoc != null) { hfselectedNodeinListbox.Value = ""; for (int i = 0; i < lstDoc.Count; i++) { DAO = (DAO_Assign_Doc)lstDoc[i]; if (DAO.REQUIRED_MULTIPLE) { ListItem lst = new ListItem(); lst.Text = DAO.SelectedSpeciality + DAO.SelectedText; lst.Value = DAO.SelectedSpecialityID + "~" + DAO.SelectedId; hfselectedNodeinListbox.Value = hfselectedNodeinListbox.Value + lst.Value + ","; lbselect.Items.Add(lst); } else { ListItem lst = new ListItem(); lst.Text = DAO.SelectedSpeciality + DAO.SelectedText; lst.Value = DAO.SelectedSpecialityID + "~" + DAO.SelectedId; lbAllSelectedDocuments.Items.Add(lst); } } } ds = objBillSysDocBO.GetAllSecialityDoc(txtCompanyID.Text); lstDoc.Clear(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DAO_Assign_Doc DAONew = new DAO_Assign_Doc(); DAONew.SelectedId = ds.Tables[0].Rows[i][0].ToString(); DAONew.SelectedText = objBillSysDocBO.GetFullPathOfNode(ds.Tables[0].Rows[i][0].ToString()); DAONew.SelectedSpeciality = objBillSysDocBO.GetSpecialityNameUsingId(ds.Tables[0].Rows[i][1].ToString()); DAONew.SelectedSpecialityID = ds.Tables[0].Rows[i][1].ToString(); DAONew.ORDER = Convert.ToInt32(ds.Tables[0].Rows[i][2]); DAONew.REQUIRED_MULTIPLE = Convert.ToBoolean(ds.Tables[0].Rows[i][3]); lstDoc.Add(DAONew); } Session["SelectedDocList"] = lstDoc; lstRemoved.Clear(); Session["RemovedDoc"] = lstRemoved; MessageControl1.PutMessage("Documents Saved Successfully!"); MessageControl1.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage); MessageControl1.Show(); //Session["SelectedDocList"] = null; } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
private void btnStart_Click(object sender, EventArgs e) { dsConfiguration = xConfiguration._xReadExcelFile(dataSourceConfiguration); dsMasterResourceId = xConfiguration._xReadExcelFile(masterResourceId); dsDictionary = xConfiguration._xReadExcelFile(dictionary); Result = new string[dsConfiguration.Tables[0].Rows.Count]; if (btnStart.Text == "START") { if (txtLoopingCount.Text == "" || txtLoopingCount.Text == "0") { MessageBox.Show("Scenario Looping tidak boleh kosong atau nol!!!"); } else { LoopingCount = int.Parse(txtLoopingCount.Text); Clear(); Control.successFlag = 1; dt.Rows.Clear(); dataGridView1.DataSource = dt; btnStart.Text = "STOP"; //Hitung total data scenario looping for (int x = 0; x < dsConfiguration.Tables[0].Rows.Count; x++) { if (dsConfiguration.Tables[0].Rows[x]["Data"].ToString() != "") { dsdataTemp = xConfiguration._xReadExcelFile(dsConfiguration.Tables[0].Rows[x]["Data"].ToString()); maxDataCounterTemp = dsdataTemp.Tables[0].Rows.Count; TotalDataScenario = TotalDataScenario + maxDataCounterTemp; } else if (dsConfiguration.Tables[0].Rows[x]["Data"].ToString() == "") { TotalDataScenario = TotalDataScenario + 1; } } LoopResult = new string[dsConfiguration.Tables[0].Rows.Count, TotalDataScenario]; //BeforeAll(); if (txtLoopingCount.Text != "" && txtLoopingCount.Text != "0" && txtLoopingCount.Text != "1") { for (int i = 0; i < int.Parse(txtLoopingCount.Text); i++) { StartTestAction(); } } else { StartTestAction(); } AfterAll(); MessageBox.Show("Test Complete!!!"); Array.Clear(Result, 0, Result.Length); if (TotalDataScenario > 0) { Array.Clear(LoopResult, 0, LoopResult.Length); } btnStart.Text = "START"; } } else if (btnStart.Text == "STOP") { btnStart.Text = "START"; Clear(); AfterAll(); MessageBox.Show("Test Fail!!!"); } }
void FillChildMenu(TreeNode node) { string MenuID = node.Value; DataSet ChildMenuTable = new DataSet(); ChildMenuTable = objBillSysDocBO.GetChildNodes(Convert.ToInt32(MenuID), txtCompanyID.Text); dsSpecialityDoc = objBillSysDocBO.GetSecialityDoc(txtCompanyID.Text, ddlSpeciality.SelectedValue); if (ChildMenuTable.Tables.Count > 0) { foreach (DataRow row in ChildMenuTable.Tables[0].Rows) { TreeNode newNode = new TreeNode(row["SZ_NODE_NAME"].ToString(), row["I_NODE_ID"].ToString()); newNode.PopulateOnDemand = false; newNode.SelectAction = TreeNodeSelectAction.Expand; newNode.ShowCheckBox = true; string str = ""; newNode.ToolTip = node.ToolTip + ">>" + row["SZ_NODE_NAME"].ToString() + "(" + row["I_NODE_ID"].ToString() + ")"; newNode.Value = row["I_NODE_ID"].ToString(); for (int i = 0; i < dsSpecialityDoc.Tables[0].Rows.Count; i++) { if (row["I_NODE_ID"].ToString().Equals(dsSpecialityDoc.Tables[0].Rows[i][0].ToString())) { newNode.Checked = true; string path = node.ToolTip; string[] nodeid = new string[10]; nodeid = node.ValuePath.Split('/'); for (int j = 0; j < nodeid.Length; j++) { path = path.Replace("(" + nodeid[j] + ")", ""); } hfselectedNode.Value = hfselectedNode.Value + path + ">>" + row["SZ_NODE_NAME"].ToString() + "~" + dsSpecialityDoc.Tables[0].Rows[i][1].ToString() + "~" + row["I_NODE_ID"].ToString() + ","; ListItem list1 = new ListItem(); list1.Text = path + ">>" + row["SZ_NODE_NAME"].ToString(); list1.Value = dsSpecialityDoc.Tables[0].Rows[i][1].ToString() + "~" + row["I_NODE_ID"].ToString(); lbSelectedDocs.Items.Insert(Convert.ToInt32(dsSpecialityDoc.Tables[0].Rows[i][2]), list1); lbSelectedDocs.Items.RemoveAt(Convert.ToInt32(dsSpecialityDoc.Tables[0].Rows[i][2]) + 1); hfOrder.Value = hfOrder.Value + row["I_NODE_ID"].ToString() + "~" + dsSpecialityDoc.Tables[0].Rows[i][2].ToString() + ","; DAO_Assign_Doc DAO = new DAO_Assign_Doc(); DAO.SelectedId = row["I_NODE_ID"].ToString(); DAO.SelectedText = path + ">>" + row["SZ_NODE_NAME"].ToString(); DAO.SelectedSpeciality = ddlSpeciality.SelectedItem.Text; DAO.SelectedSpecialityID = dsSpecialityDoc.Tables[0].Rows[i][1].ToString(); DAO.ORDER = Convert.ToInt32(dsSpecialityDoc.Tables[0].Rows[i][2]); DAO.REQUIRED_MULTIPLE = Convert.ToBoolean(dsSpecialityDoc.Tables[0].Rows[i][3]); ArrayList lstDoc = new ArrayList(); if (Session["SelectedDocList"] == null) { lstDoc.Add(DAO); Session["SelectedDocList"] = lstDoc; } else { lstDoc = (ArrayList)Session["SelectedDocList"]; Session["SelectedDocList"] = lstDoc; int flag = 0; for (int l = 0; l < lstDoc.Count; l++) { DAO_Assign_Doc DAO1 = new DAO_Assign_Doc(); DAO1 = (DAO_Assign_Doc)lstDoc[l]; if (DAO1.SelectedId.Equals(DAO.SelectedId) && DAO1.SelectedSpecialityID.Equals(DAO.SelectedSpecialityID)) { flag = 1; break; } } if (flag == 0) { lstDoc.Add(DAO); } } if (Session["SelectedDocList"] != null) { ArrayList lstDoc1 = new ArrayList(); lstDoc1 = (ArrayList)Session["SelectedDocList"]; for (int k = 0; k < lstDoc1.Count; k++) { DAO_Assign_Doc dao = new DAO_Assign_Doc(); dao = (DAO_Assign_Doc)lstDoc[k]; if (dao.SelectedId.Equals(row["I_NODE_ID"].ToString()) && dao.SelectedSpecialityID.Equals(ddlSpeciality.SelectedValue.ToString())) { newNode.Checked = true; } } } } else if (Session["SelectedDocList"] != null) { ArrayList lstDoc = new ArrayList(); lstDoc = (ArrayList)Session["SelectedDocList"]; for (int k = 0; k < lstDoc.Count; k++) { DAO_Assign_Doc dao = new DAO_Assign_Doc(); dao = (DAO_Assign_Doc)lstDoc[k]; if (dao.SelectedId.Equals(row["I_NODE_ID"].ToString()) && dao.SelectedSpecialityID.Equals(ddlSpeciality.SelectedValue.ToString())) { newNode.Checked = true; } } } } node.ChildNodes.Add(newNode); FillChildMenu(newNode); } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack == true) { try { CrmClass objcrm = new CrmClass(); string state = Request.Form["TxStatus"].ToString(); string pgtxnid = Request.Form["pgTxnNo"].ToString(); string amount = Request.Form["amount"].ToString(); string marchant_txt_id = Request.Form["TxId"].ToString(); objcrm.InsertCitrusTransactionResult(state, pgtxnid, amount, marchant_txt_id); if (state == "SUCCESS") { SqlConnection LocalConn = new SqlConnection(); LocalConn.ConnectionString = ConfigurationManager.ConnectionStrings["TESTQUEUEConnectionString"].ToString(); LocalConn.Open(); SqlDataAdapter da; DataSet ds = new DataSet(); SqlCommand cmd = new SqlCommand(); cmd = new SqlCommand("UpdateBookTaskOnlineTransactionID", LocalConn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@BookingID", SqlDbType.Int).Value = Convert.ToInt32(marchant_txt_id); cmd.Parameters.Add("@TransactionID", SqlDbType.VarChar, 50).Value = pgtxnid; da = new SqlDataAdapter(cmd); da.Fill(ds); string contactNo = ""; string ClientID = "0"; string Name = ""; if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { contactNo = ds.Tables[0].Rows[0].ItemArray[0].ToString(); ClientID = ds.Tables[0].Rows[0].ItemArray[1].ToString(); Name = ds.Tables[0].Rows[0].ItemArray[2].ToString(); } } cmd.Dispose(); LocalConn.Close(); if (Request.QueryString["ReferMode"] == "N") { if (Name != "" && contactNo != "") { WebClient client = new WebClient(); client.Headers.Add("user-agent", "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; .NET CLR 1.0.3705;)"); string MessagePart = Server.UrlEncode("Dear " + Name + ", Thank you for booking your task with Russsh.com You will receive your confirmation within the next 20 minutes."); Stream data = client.OpenRead("http://enterprise.smsgupshup.com/GatewayAPI/rest?method=SendMessage&send_to=" + contactNo + "&msg=" + MessagePart + "&msg_type=TEXT&userid=2000148575&auth_scheme=plain&password=getmypeon&v=1.1&format=text"); StreamReader reader = new StreamReader(data); string s = reader.ReadToEnd(); Console.WriteLine(s); data.Close(); reader.Close(); } } } } catch (Exception em) { } } }
public ActionResult UploadToDB(string[] files) { //string[] timeSheetHeader = { "TatigkeitsNachweis", "MonatJahr", "Firma", "Mitarbeiter", "Kunde", "EBNummer", "AuftragsNummer", "SummeDerStunden", "SummeTage" }; //string[] timeSheetLineHeader = { "Datum", "ArbeitsZeitVon", "ArbeitsZeitBis", "GerundetVon", "GerundetBis", "Pause", "Project", "TatigkeitEinsatzort", "StundenNetto" }; const string providerXLS = "Provider=Microsoft.ACE.OLEDB.12.0.;Data Source="; const string extensionXLS = ";Extended Properties=\"Excel 8.0;HDR=NO;IMEX=2\""; const string providerXLSX = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="; const string extensionXLSX = ";Extended Properties=\"Excel 12.0 Xml;HDR=NO;IMEX=2\""; string companyId = (string)Session["CompanyID"]; int modelId = (int)IWSLookUp.MetaModelId.TimeSheet; int daysInMonth = 0; string fullPath = files[0].ToString(); string msg = string.Empty; string fileName = fullPath.Substring(fullPath.IndexOf(@"\") + 1); if (fileName.Equals(null)) { return(View("ImportTimeSheets")); } int count = 0; int rowCount = 0; string sheetName = ""; //int errorAtLine = 0; int transId = 0; int readDetailFrom = 11; try { string path = Path.Combine(Server.MapPath(TimeSheetsFileManagerSettings.RootFolder), fileName); string extension = Path.GetExtension(fileName).ToLower(); if ((extension != ".xls") && (extension != ".xlsx")) { msg = $"{IWSLocalResource.UnsupportedFormat} "; var msgFormat = new { Description = msg }; return(Json(msgFormat)); } string connectionString = string.Empty; DataTable dataTable = new DataTable(); connectionString = providerXLS + path + extensionXLS; if (extension == ".xlsx") { connectionString = providerXLSX + path + extensionXLSX; } OleDbConnection oleDBConnection = new OleDbConnection(connectionString); oleDBConnection.Open(); dataTable = oleDBConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); oleDBConnection.Close(); if (dataTable == null) { return(null); } string[] excelSheets = new string[dataTable.Rows.Count]; foreach (DataRow row in dataTable.Rows) { excelSheets[count] = row["TABLE_NAME"].ToString(); sheetName = excelSheets[count].Replace("\'", ""); #region key process if (sheetName != "Daten$") { string query = $"Select * from [{excelSheets[count]}]"; DataSet dataSet = new DataSet(); using (OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, oleDBConnection)) { dataAdapter.Fill(dataSet); } if (!(dataSet.Tables[0].Rows.Count > 0)) { string x = $"{IWSLocalResource.GenericError}{Environment.NewLine}{IWSLocalResource.DataFormat} "; var s = new { Description = x }; return(Json(s)); } if (DateTime.TryParse(dataSet.Tables[0].Rows[12][1].ToString(), CultureInfo.GetCultureInfo(Thread.CurrentThread.CurrentUICulture.Name), DateTimeStyles.None, out DateTime currentDate)) { daysInMonth = DateTime.DaysInMonth(currentDate.Year, currentDate.Month); } else { string x = $"{IWSLocalResource.GenericError}{Environment.NewLine}{IWSLocalResource.DataFormat} "; var s = new { Description = x }; return(Json(s)); } #region TimeSheets Header string TatigkeitsNachweis = dataSet.Tables[0].AsEnumerable().FirstOrDefault().Field <string>(0); string MonatJahr = dataSet.Tables[0].AsEnumerable().Skip(1).FirstOrDefault().Field <string>(11); string Firma = dataSet.Tables[0].AsEnumerable().Skip(3).FirstOrDefault().Field <string>(2); string Mitarbeiter = dataSet.Tables[0].AsEnumerable().Skip(4).FirstOrDefault().Field <string>(2); string Kunde = dataSet.Tables[0].AsEnumerable().Skip(5).FirstOrDefault().Field <string>(2); string EBNummer = dataSet.Tables[0].AsEnumerable().Skip(6).FirstOrDefault().Field <string>(2); string AuftragsNummer = dataSet.Tables[0].AsEnumerable().Skip(7).FirstOrDefault().Field <string>(2); decimal SummeDerStunden = Convert.ToDecimal(dataSet.Tables[0].AsEnumerable().Skip(42).FirstOrDefault().Field <string>(11)); decimal SummeTage = Convert.ToDecimal(dataSet.Tables[0].AsEnumerable().Skip(43).FirstOrDefault().Field <string>(11)); TimeSheet timeSheet = new TimeSheet { TatigkeitsNachweis = TatigkeitsNachweis, MonatJahr = MonatJahr, Firma = Firma, Mitarbeiter = Mitarbeiter, Kunde = Kunde, EBNummer = EBNummer, AuftragsNummer = AuftragsNummer, SummeDerStunden = SummeDerStunden, SummeTage = SummeTage, IsValidated = false, ModelId = modelId, CompanyId = companyId }; #endregion #region TimeSheets Lines List <TimeSheetLine> timeSheetLines = dataSet.Tables[0].AsEnumerable().Skip(readDetailFrom).Take(daysInMonth). Where(x => x.Field <string>(0) != null).Select(t => new TimeSheetLine { Datum = Convert.ToDateTime(t.Field <string>(1), CultureInfo.GetCultureInfo(Thread.CurrentThread.CurrentUICulture.Name)), ArbeitsZeitVon = t.Field <string>(2), ArbeitsZeitBis = t.Field <string>(3), GerundetVon = t.Field <string>(4), GerundetBis = t.Field <string>(5), Pause = t.Field <string>(6), Project = t.Field <string>(7), TatigkeitEinsatzort = t.Field <string>(8), Gerundet = t.Field <string>(10), StundenNetto = t.Field <string>(11) }).ToList(); #endregion if (db.TimeSheets.Any(m => m.MonatJahr.Equals(timeSheet.MonatJahr) && m.Firma.Equals(timeSheet.Firma) && m.Mitarbeiter.Equals(timeSheet.Mitarbeiter) && m.Kunde.Equals(timeSheet.Kunde) && m.CompanyId.Equals(companyId))) { TimeSheet entity = db.TimeSheets.FirstOrDefault(n => n.MonatJahr.Equals(timeSheet.MonatJahr) && n.Firma.Equals(timeSheet.Firma) && n.Mitarbeiter.Equals(timeSheet.Mitarbeiter) && n.Kunde.Equals(timeSheet.Kunde) && n.CompanyId.Equals(companyId)); if (entity.IsValidated.Equals(false)) { db.TimeSheets.DeleteOnSubmit(entity); db.SubmitChanges(ConflictMode.FailOnFirstConflict); } } db.TimeSheets.InsertOnSubmit(timeSheet); db.SubmitChanges(); transId = db.TimeSheets.DefaultIfEmpty().Max(m => m == null ? 0 : m.Id); count += 1; foreach (TimeSheetLine timeSheetLine in timeSheetLines) { timeSheetLine.TransId = transId; db.TimeSheetLines.InsertOnSubmit(timeSheetLine); } db.SubmitChanges(ConflictMode.ContinueOnConflict); int linx = timeSheetLines.Count(); rowCount += linx; } #endregion } if (rowCount > 0) { msg = $"{rowCount} {IWSLocalResource.Imported} "; } else { msg = $"{IWSLocalResource.ImportedNone}"; } var Message = new { Description = msg }; return(Json(Message)); } catch (Exception ex) { IWSLookUp.LogException(ex); msg = ex.Message; //if (errorAtLine > 0) // msg = $"{msg} {Environment.NewLine} {sheetName}: {errorAtLine + 1}"; var Message = new { Description = msg }; return(Json(Message)); } }
protected void btnAssign_Click(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { if (ddlSpeciality.SelectedValue.Equals("0")) { usrMessage.PutMessage("Speciality is not selected."); usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_ErrorMessage); usrMessage.Show(); } else { ArrayList lstDoc = (ArrayList)Session["SelectedDocList"]; if (lstDoc == null) { lstDoc = new ArrayList(); } string[] Documents = new string[100]; Documents = hfselectedNode.Value.Split(','); lbSelectedDocs.Items.Clear(); ArrayList lstRemoved = new ArrayList(); for (int i = 0; i < Documents.Length - 1; i++) { DAO_Assign_Doc DAO = new DAO_Assign_Doc(); DAO.SelectedText = Documents[i].Split('~')[0]; DAO.SelectedId = Documents[i].Split('~')[2]; DAO.SelectedSpeciality = ddlSpeciality.SelectedItem.Text; DAO.SelectedSpecialityID = ddlSpeciality.SelectedItem.Value; DAO.ORDER = i; for (int j = 0; j < lstDoc.Count; j++) { DAO_Assign_Doc DAO1 = new DAO_Assign_Doc(); DAO1 = (DAO_Assign_Doc)lstDoc[j]; if (DAO1.SelectedSpecialityID.Equals(DAO.SelectedSpecialityID)) { lstDoc.Remove(DAO1); lstRemoved.Add(DAO1); j--; } } } if (Documents.Length - 1 == 0) { for (int j = 0; j < lstDoc.Count; j++) { DAO_Assign_Doc DAO1 = new DAO_Assign_Doc(); DAO1 = (DAO_Assign_Doc)lstDoc[j]; if (ddlSpeciality.SelectedValue.Equals(DAO1.SelectedSpecialityID)) { lstDoc.Remove(DAO1); lstRemoved.Add(DAO1); j--; } } } for (int i = 0; i < Documents.Length - 1; i++) { ListItem list = new ListItem(); list.Text = ""; list.Value = ""; if (!Documents[i].Split('~')[0].Equals("")) { lbSelectedDocs.Items.Add(list); } } hfselectedNode.Value = ""; ArrayList lstDoc1 = new ArrayList(); DataSet ds = new DataSet(); ds = objBillSysDocBO.GetAllSecialityDoc(txtCompanyID.Text); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DAO_Assign_Doc DAO = new DAO_Assign_Doc(); DAO.SelectedId = ds.Tables[0].Rows[i][0].ToString(); DAO.SelectedText = objBillSysDocBO.GetFullPathOfNode(ds.Tables[0].Rows[i][0].ToString()); DAO.SelectedSpeciality = objBillSysDocBO.GetSpecialityNameUsingId(ds.Tables[0].Rows[i][1].ToString()); DAO.SelectedSpecialityID = ds.Tables[0].Rows[i][1].ToString(); DAO.ORDER = Convert.ToInt32(ds.Tables[0].Rows[i][2]); DAO.REQUIRED_MULTIPLE = Convert.ToBoolean(ds.Tables[0].Rows[i][3]); lstDoc1.Add(DAO); } for (int i = 0; i < Documents.Length - 1; i++) { ListItem list = new ListItem(); if (!Documents[i].Split('~')[0].Equals("")) { list.Text = Documents[i].Split('~')[0]; list.Value = Documents[i].Split('~')[1] + "~" + Documents[i].Split('~')[2]; lbSelectedDocs.Items.Insert(i, list); lbSelectedDocs.Items.RemoveAt(i + 1); DAO_Assign_Doc DAO = new DAO_Assign_Doc(); DAO.SelectedText = Documents[i].Split('~')[0]; DAO.SelectedId = Documents[i].Split('~')[2]; DAO.SelectedSpeciality = ddlSpeciality.SelectedItem.Text; DAO.SelectedSpecialityID = ddlSpeciality.SelectedItem.Value; DAO.ORDER = i; int flag = 0; for (int j = 0; j < lstDoc1.Count; j++) { DAO_Assign_Doc DAO1 = new DAO_Assign_Doc(); DAO1 = (DAO_Assign_Doc)lstDoc1[j]; if (DAO.SelectedSpecialityID.Equals(DAO1.SelectedSpecialityID) && DAO.SelectedId.Equals(DAO1.SelectedId)) { DAO.REQUIRED_MULTIPLE = DAO1.REQUIRED_MULTIPLE; flag = 1; int ins = 0; for (int k = 0; k < lstDoc.Count; k++) { DAO_Assign_Doc DAODocInSession = new DAO_Assign_Doc(); DAODocInSession = (DAO_Assign_Doc)lstDoc[k]; if (DAO.SelectedSpecialityID.Equals(DAODocInSession.SelectedSpecialityID) && DAO.SelectedId.Equals(DAODocInSession.SelectedId)) { ins = 1; } else { ins = 0; } } if (ins == 0) { lstDoc.Add(DAO); lstRemoved.Remove(DAO); hfselectedNode.Value = hfselectedNode.Value + list.Text + "~" + list.Value + ","; } break; } } if (flag == 0) { lstDoc.Add(DAO); hfselectedNode.Value = hfselectedNode.Value + list.Text + "~" + list.Value + ","; } } } Session["SelectedDocList"] = lstDoc; Session["RemovedDoc"] = lstRemoved; usrMessage.PutMessage("Documents Assigned Successfully!"); usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage); usrMessage.Show(); //Label3.Text = "Documents Assigned Successfully!"; } } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
/// <summary> /// 获得数据列表 /// </summary> public List <Tc.Model.TcLinks> GetModelList(string strWhere) { DataSet ds = dal.GetList(strWhere); return(DataTableToList(ds.Tables[0])); }
protected void Page_Load(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { tvwmenu.Attributes.Add("onclick", "OnCheckBoxCheckChanged(event)"); btnAssign.Attributes.Add("onclick", "order()"); txtCompanyID.Text = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID; if (!IsPostBack) { txtUserID.Text = ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID; //load speciality in the dropdownlist. DataSet dsSpeciality = objSpeciality.GetSpecialityList(txtCompanyID.Text); ListItem list2 = new ListItem(); list2.Text = "---Select---"; list2.Value = "0"; ddlSpeciality.Items.Add(list2); for (int i = 0; i < dsSpeciality.Tables[0].Rows.Count; i++) { ListItem list = new ListItem(); list.Text = dsSpeciality.Tables[0].Rows[i][1].ToString(); list.Value = dsSpeciality.Tables[0].Rows[i][0].ToString(); ddlSpeciality.Items.Add(list); } hfselectedNodeinListbox.Value = ""; //Load All the documents in the session, which are available in the database. DataSet ds = new DataSet(); ds = objBillSysDocBO.GetAllSecialityDoc(txtCompanyID.Text); ArrayList lstDoc = new ArrayList(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DAO_Assign_Doc DAO = new DAO_Assign_Doc(); DAO.SelectedId = ds.Tables[0].Rows[i][0].ToString(); DAO.SelectedText = objBillSysDocBO.GetFullPathOfNode(ds.Tables[0].Rows[i][0].ToString()); DAO.SelectedSpeciality = objBillSysDocBO.GetSpecialityNameUsingId(ds.Tables[0].Rows[i][1].ToString()); DAO.SelectedSpecialityID = ds.Tables[0].Rows[i][1].ToString(); DAO.ORDER = Convert.ToInt32(ds.Tables[0].Rows[i][2]); DAO.REQUIRED_MULTIPLE = Convert.ToBoolean(ds.Tables[0].Rows[i][3]); lstDoc.Add(DAO); } Session["SelectedDocList"] = lstDoc; } //load Listbox on the Step 1 of the wizard. if selected speciality is not '---Select---' if (!ddlSpeciality.SelectedValue.Equals("0")) { tvwmenu.Visible = true; DAO_Assign_Doc DAO = new DAO_Assign_Doc(); ArrayList lstDoc = new ArrayList(); lstDoc = (ArrayList)Session["SelectedDocList"]; lbSelectedDocs.Items.Clear(); if (lstDoc != null) { for (int i = 0; i < lstDoc.Count; i++) { DAO = (DAO_Assign_Doc)lstDoc[i]; ListItem lst = new ListItem(); lst.Text = DAO.SelectedText; lst.Value = DAO.SelectedSpecialityID + "~" + DAO.SelectedId; if (DAO.SelectedSpecialityID.Equals(ddlSpeciality.SelectedValue)) { lbSelectedDocs.Items.Add(lst); } } } } else { //load treeview tvwmenu.Visible = true; tvwmenu.ExpandAll(); tvwmenu.ShowExpandCollapse = true; } // Label3.Text = ""; //lblmsg.Text = ""; //load treeview and listbox on the step 1 of the wizard if user clicks on 'Previous' button on the step 2 of the wizard. if (Wizard1.ActiveStepIndex == 1) { if (Session["SelectedDocList"] != null) { hfselectedNode.Value = ""; dsSpecialityDoc = objBillSysDocBO.GetSecialityDoc(txtCompanyID.Text, ddlSpeciality.SelectedValue); for (int i = 0; i < dsSpecialityDoc.Tables[0].Rows.Count; i++) { ListItem list = new ListItem(); list.Text = ""; list.Value = ""; lbSelectedDocs.Items.Add(list); } //tvwmenu.PopulateNodesFromClient = true; //tvwmenu.Nodes.RemoveAt(0); //TreeNode node = new TreeNode("Document Manager", "0"); //node.PopulateOnDemand = true; //tvwmenu.Nodes.Add(node); //tvwmenu.ExpandAll(); int count = lbSelectedDocs.Items.Count; for (int i = 0; i < count; i++) { if (lbSelectedDocs.Items[i].Value.Equals("")) { lbSelectedDocs.Items.RemoveAt(i); i--; count--; } else { } } } } DataSet dsDoc = new DataSet(); dsDoc = objBillSysDocBO.GetAllSecialityDoc(txtCompanyID.Text); lbAllAssignedDoc.Items.Clear(); for (int i = 0; i < dsDoc.Tables[0].Rows.Count; i++) { DAO_Assign_Doc DAO = new DAO_Assign_Doc(); DAO.SelectedId = dsDoc.Tables[0].Rows[i][0].ToString(); DAO.SelectedText = objBillSysDocBO.GetFullPathOfNode(dsDoc.Tables[0].Rows[i][0].ToString()); DAO.SelectedSpeciality = objBillSysDocBO.GetSpecialityNameUsingId(dsDoc.Tables[0].Rows[i][1].ToString()); DAO.SelectedSpecialityID = dsDoc.Tables[0].Rows[i][1].ToString(); DAO.ORDER = Convert.ToInt32(dsDoc.Tables[0].Rows[i][2]); DAO.REQUIRED_MULTIPLE = Convert.ToBoolean(dsDoc.Tables[0].Rows[i][3]); ListItem lst = new ListItem(); lst.Text = DAO.SelectedSpeciality.ToString() + DAO.SelectedText.ToString(); lst.Value = DAO.SelectedId.ToString(); lbAllAssignedDoc.Items.Add(lst); } } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } #region "check version readonly or not" string app_status = ((Bill_Sys_BillingCompanyObject)Session["APPSTATUS"]).SZ_READ_ONLY.ToString(); if (app_status.Equals("True")) { Bill_Sys_ChangeVersion cv = new Bill_Sys_ChangeVersion(this.Page); cv.MakeReadOnlyPage("Bill_Sys_DocumentType.aspx"); } #endregion //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
private void Form11_Load(object sender, EventArgs e) { Dictionary <string, string> ls = new Dictionary <string, string>(); string commandString = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=C:\\Users\\Administrator\\Desktop\\新建文件夹(1)\\201902更新三目\\广东1.17.09中成药全库.xls;" + ";Extended Properties=\"Excel 12.0;HDR=YES;IMEX=1\""; string commandString1 = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=C:\\Users\\Administrator\\Desktop\\新建文件夹(1)\\201902更新三目\\广东1.17.10西药全库.xls;" + ";Extended Properties=\"Excel 12.0;HDR=YES;IMEX=1\""; DataSet dataSet = new DataSet(); // 创建连接到数据源的对象 OleDbConnection command = new OleDbConnection(commandString); OleDbConnection command1 = new OleDbConnection(commandString1); // 打开连接 command.Open(); // Sql的查询命令,有关于数据库自行百度或者Google string sqlex = "select * from [中成药注册信息库$]"; string sqlex1 = "select * from [西药注册信息库$]"; OleDbDataAdapter adaper = new OleDbDataAdapter(sqlex, command); OleDbDataAdapter adaper1 = new OleDbDataAdapter(sqlex1, command1); // 用来存放数据 dataSet = new DataSet(); adaper.Fill(dataSet); // 填充DataTable数据到DataSet中 DataTable dt = dataSet.Tables[0]; foreach (DataRow r in dt.Rows) { ls.Add(r["药监局药品编码"].ToString(), r["中成药药品代码"].ToString()); } dataSet = new DataSet(); adaper1.Fill(dataSet); dt = dataSet.Tables[0]; foreach (DataRow r in dt.Rows) { ls.Add(r["药监局药品编码"].ToString(), r["西药药品代码"].ToString()); } hisDBConn hdb = new hisDBConn(); //foreach (var l in ls) //{ // string sql = "update yk_typk2 set YBDM = '" + l.Value + "' where sbdm = '" + l.Key + "'"; // hdb.GetSqlCmd(sql); //} Dictionary <string, string> nls = new Dictionary <string, string>(); string sqln = "select * from [YK_TYPK2] where ybdm is null"; DataTable dtn = hdb.GetDataSet(sqln).Tables[0]; foreach (DataRow n in dtn.Rows) { string ypxh = n["ypxh"].ToString(); string sbdm = n["sbdm"].ToString(); string sql = "update yk_typk2 set YBDM = '" + sbdm + "' where ypxh = '" + ypxh + "'"; hdb.GetSqlCmd(sql); } // 释放连接的资源 command.Close(); }
/// <summary> /// 获得数据列表 /// </summary> public List <XCWeiXin.Model.wx_ucard_cardinfo> GetModelList(string strWhere) { DataSet ds = dal.GetList(strWhere); return(DataTableToList(ds.Tables[0])); }
public void DataSetExtendedPropertiesTest() { DataSet dataSet1 = new DataSet(); dataSet1.ExtendedProperties.Add("DS1", "extended0"); DataTable table = new DataTable("TABLE1"); table.ExtendedProperties.Add("T1", "extended1"); table.Columns.Add("C1", typeof(int)); table.Columns.Add("C2", typeof(string)); table.Columns[1].MaxLength = 20; table.Columns[0].ExtendedProperties.Add("C1Ext1", "extended2"); table.Columns[1].ExtendedProperties.Add("C2Ext1", "extended3"); dataSet1.Tables.Add(table); table.LoadDataRow(new object[] { 1, "One" }, false); table.LoadDataRow(new object[] { 2, "Two" }, false); string file = Path.Combine(Path.GetTempPath(), "schemas-test.xml"); try { dataSet1.WriteXml(file, XmlWriteMode.WriteSchema); } catch (Exception ex) { Assert.False(true); } finally { File.Delete(file); } DataSet dataSet2 = new DataSet(); dataSet2.ReadXml(new StringReader( @"<?xml version=""1.0"" standalone=""yes""?> <NewDataSet> <xs:schema id=""NewDataSet"" xmlns="""" xmlns:xs=""http://www.w3.org/2001/XMLSchema"" xmlns:msdata=""urn:schemas-microsoft-com:xml-msdata"" xmlns:msprop=""urn:schemas-microsoft-com:xml-msprop""> <xs:element name=""NewDataSet"" msdata:IsDataSet=""true"" msdata:UseCurrentLocale=""true"" msprop:DS1=""extended0""> <xs:complexType> <xs:choice minOccurs=""0"" maxOccurs=""unbounded""> <xs:element name=""TABLE1"" msprop:T1=""extended1""> <xs:complexType> <xs:sequence> <xs:element name=""C1"" type=""xs:int"" minOccurs=""0"" msprop:C1Ext1=""extended2"" /> <xs:element name=""C2"" type=""xs:string"" minOccurs=""0"" msprop:C2Ext1=""extended3"" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> </xs:element> </xs:schema> <TABLE1> <C1>1</C1> <C2>One</C2> </TABLE1> <TABLE1> <C1>2</C1> <C2>Two</C2> </TABLE1> </NewDataSet>"), XmlReadMode.ReadSchema); Assert.Equal(dataSet1.ExtendedProperties["DS1"], dataSet2.ExtendedProperties["DS1"]); Assert.Equal(dataSet1.Tables[0].ExtendedProperties["T1"], dataSet2.Tables[0].ExtendedProperties["T1"]); Assert.Equal(dataSet1.Tables[0].Columns[0].ExtendedProperties["C1Ext1"], dataSet2.Tables[0].Columns[0].ExtendedProperties["C1Ext1"]); Assert.Equal(dataSet1.Tables[0].Columns[1].ExtendedProperties["C2Ext1"], dataSet2.Tables[0].Columns[1].ExtendedProperties["C2Ext1"]); }
private void readExcel(string filename) { string fsn = ""; try { string connstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("~/upload/" + filename) + ";Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1;\""; using (OleDbConnection conn = new OleDbConnection(connstring)) { conn.Open(); DataTable sheetsName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" }); //得到所有sheet的名字 //for(int k=0;k<sheetsName.Rows.Count;k++) //{ // log.Info(sheetsName.Rows[k][2].ToString()); //} string firstSheetName = sheetsName.Rows[0][2].ToString(); //得到第一个sheet的名字 string sql = string.Format("SELECT * FROM [{0}]", firstSheetName); //查询字符串 OleDbDataAdapter ada = new OleDbDataAdapter(sql, connstring); DataSet set = new DataSet(); ada.Fill(set); DataTable dt = set.Tables[0]; int i = 0; SQLHelper.DbHelperSQL.SetConnectionString(""); string OrderNo = "", LotNo = "", ClientCode = "", ClientOrderNo = "", RecOrderPersonID = "", RecOrderPerson = "", RecOrderDate = "", SendOrderDate = "", OutGoodsDate = "";//产品名称、产品编号、版本、瑞麟编号、客户编号、客户代号、日期 ArrayList al = new ArrayList(); //获取表头 添加orderheader if (dt != null && dt.Rows.Count >= 6) { OrderNo = dt.Rows[1][2].ToString(); LotNo = dt.Rows[1][7].ToString(); ClientCode = dt.Rows[1][13].ToString(); ClientOrderNo = dt.Rows[2][2].ToString(); RecOrderPerson = dt.Rows[3][2].ToString(); RecOrderDate = dt.Rows[4][2].ToString(); SendOrderDate = dt.Rows[4][7].ToString(); OutGoodsDate = dt.Rows[4][11].ToString(); sql = "select sn from OrderHeader where OrderNo='" + OrderNo + "'"; log.Info(sql); DataTable dtitem = SQLHelper.DbHelperSQL.ReturnDataTable(sql, 30); if (dtitem == null || dtitem.Rows.Count == 0) { //sql = "insert into allitem(itemno,name) values('" + dt.Rows[2][4].ToString() + "','" + dt.Rows[2][2].ToString() + "')"; //log.Info("sqlallitem::::" + sql); //al.Add(sql); sql = "insert into OrderHeader(OrderNo,LotNo,ClientCode,ClientOrderNo,RecOrderPerson,RecOrderDate,SendOrderDate,OutGoodsDate,Inputer,InputerDate,IsCheck) values('" + OrderNo + "','" + LotNo + "','" + ClientCode + "','" + ClientOrderNo + "','" + RecOrderPerson + "','" + RecOrderDate.Replace(".", "-") + "','" + SendOrderDate.Replace(".", "-") + "','" + OutGoodsDate.Replace(".", "-") + "','" + User.Identity.Name + "',getdate(),0)"; log.Info("sqlbase::::" + sql); SQLHelper.DbHelperSQL.ExecuteSql(sql, 30); } else { //产品名称、产品编号、版本、瑞麟编号、客户编号、客户代号、日期 sql = "update OrderHeader set LotNo='" + LotNo + "',ClientCode='" + ClientCode + "',ClientOrderNo='" + ClientOrderNo + "',RecOrderPerson='" + RecOrderPerson + "',RecOrderDate='" + RecOrderDate.Replace(".", "-") + "',SendOrderDate='" + SendOrderDate.Replace(".", "-") + "',OutGoodsDate='" + OutGoodsDate.Replace(".", "-") + "',Updater='" + User.Identity.Name + "',UpdateDate=getdate() where OrderNo='" + OrderNo + "'"; log.Info("sqlbase::::" + sql); SQLHelper.DbHelperSQL.ExecuteSql(sql, 30); } sql = "select max(sn) from OrderHeader"; SQLHelper.DbHelperSQL.SetConnectionString(""); fsn = SQLHelper.DbHelperSQL.GetSingle(sql).ToString(); #region orderdtl add for (i = 7; i < dt.Rows.Count; i++) { if (dt.Rows[i][0].ToString() == "" || dt.Rows[i][1].ToString() == "") { break; } else { #region bomdtl add //料号,名称,规格,材质,表面处理或颜色,底数,类别 //ItemNo,Name,Spec,MaterialNo,ItemColor,AddReserve1,ClassName sql = "select top 1 * from OrderDetail where itemno='" + dt.Rows[i][1].ToString() + "' and ItemName='" + dt.Rows[i][2].ToString() + "' and OrderNo='" + OrderNo + "' "; dtitem = SQLHelper.DbHelperSQL.ReturnDataTable(sql, 30); if (dtitem == null || dtitem.Rows.Count == 0) { //sql = "insert into allitem(itemno,name) values('" + dt.Rows[i][1].ToString() + "','" + dt.Rows[i][2].ToString() + "')"; //log.Info("sqlallitem::::" + sql); //SQLHelper.DbHelperSQL.ExecuteSql(sql, 30); //bomsn,物料sn,料号,名称,规格,材质,表面处理,用量,分类 sql = "insert into OrderDetail(FSN,OrderNo,ClinetNo,ItemNo,ItemName,Quantity,Demand1,Demand2,Demand3,Demand4,Demand5,Demand6,Demand7,Demand8,Demand9,Demand10,Demand11,Demand12,Remark,Inputer,InputerDate) values(" + fsn + ",'" + OrderNo + "','" + dt.Rows[i][1].ToString() + "','" + dt.Rows[i][2].ToString() + "','" + dt.Rows[i][3].ToString() + "'," + dt.Rows[i][4].ToString() + ",'" + dt.Rows[i][5].ToString() + "','" + dt.Rows[i][6].ToString() + "','" + dt.Rows[i][7].ToString() + "','" + dt.Rows[i][8].ToString() + "','" + dt.Rows[i][9].ToString() + "','" + dt.Rows[i][10].ToString() + "','" + dt.Rows[i][11].ToString() + "','" + dt.Rows[i][12].ToString() + "','" + dt.Rows[i][13].ToString() + "','" + dt.Rows[i][14].ToString() + "','" + dt.Rows[i][15].ToString() + "','" + dt.Rows[i][16].ToString() + "','" + dt.Rows[i][17].ToString().Replace(" ", "") + "','" + User.Identity.Name + "',getdate())"; log.Info("sqldtl::::" + sql); SQLHelper.DbHelperSQL.ExecuteSql(sql, 30); } else { sql = "update OrderDetail ClinetNo='" + dt.Rows[i][1].ToString() + "',ItemNo,ItemName,Quantity=" + dt.Rows[i][4].ToString() + ",Demand1='" + dt.Rows[i][5].ToString() + "',Demand2='" + dt.Rows[i][6].ToString() + "',Demand3='" + dt.Rows[i][7].ToString() + "',Demand4='" + dt.Rows[i][8].ToString() + "',Demand5='" + dt.Rows[i][9].ToString() + "',Demand6='" + dt.Rows[i][10].ToString() + "',Demand7='" + dt.Rows[i][11].ToString() + "',Demand8='" + dt.Rows[i][12].ToString() + "',Demand9='" + dt.Rows[i][13].ToString() + "',Demand10='" + dt.Rows[i][14].ToString() + "',Demand11='" + dt.Rows[i][15].ToString() + "',Demand12='" + dt.Rows[i][16].ToString() + "',Remark='" + dt.Rows[i][17].ToString().Replace(" ", "") + "',Updater='" + User.Identity.Name + "',UpdateDate=getdate() where itemno='" + dt.Rows[i][1].ToString() + "' and ItemName='" + dt.Rows[i][2].ToString() + "' and OrderNo='" + OrderNo + "' "; log.Info("sqldtl::::" + sql); SQLHelper.DbHelperSQL.ExecuteSql(sql, 30); } #endregion } } #endregion } else { Alert.Show("NO Data"); } } Alert.Show("导入成功"); } catch (Exception ee) { Alert.Show("导入失败"); log.Info(ee.ToString()); } finally { BindGrid(); } }
public static void Update(Product product, string nname, string nsource, string nproductLink, string nprice, string ngroup, string nphotoLink) { var updateQuery = ""; updateQuery += Check(product.name, nname, "name"); updateQuery += Check(product.source, nsource, "source"); updateQuery += Check(product.product_link, nproductLink, "product_link"); updateQuery += Check(product.price, nprice, "price"); updateQuery += Check(product.group, ngroup, "group"); updateQuery += Check(product.photo_link, nphotoLink, "photo_link"); if (updateQuery.Length > 0) { using (var con = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["database"].ConnectionString)) { con.Open(); updateQuery = updateQuery.TrimEnd(',', ' '); // var sql = new NpgsqlCommand( "UPDATE dbo.\"Products\" SET " + updateQuery + " where name='" + product.name + "' and source='" + product.source + "';", con); sql.Parameters.AddWithValue("@name", nname); sql.Parameters.AddWithValue("@source", nsource); sql.Parameters.AddWithValue("@product_link", nproductLink); sql.Parameters.AddWithValue("@price", nprice); sql.Parameters.AddWithValue("@group", ngroup); sql.Parameters.AddWithValue("@photo_link", nphotoLink); var dataAdapter = new NpgsqlDataAdapter("select * FROM dbo.\"Products\"", con) { UpdateCommand = sql }; var dataSet = new DataSet(); dataAdapter.AcceptChangesDuringUpdate = true; dataAdapter.Fill(dataSet, "dbo.\"Products\""); Debug.WriteLine(sql.CommandText); var dataTable = dataSet.Tables["dbo.\"Products\""]; //dataTable.Rows.Find(row => row[1].ToString().Equals(product.name)); foreach (DataRow dataRow in dataTable.Rows) { if (!dataRow[1].ToString().Equals(product.name)) { continue; } if (ShouldUpdate(product.name, nname)) { dataRow[1] = nname; } if (ShouldUpdate(product.source, nsource)) { dataRow[2] = nname; } if (ShouldUpdate(product.product_link, nproductLink)) { dataRow[5] = nname; } if (ShouldUpdate(product.price, nprice)) { dataRow[3] = nname; } if (ShouldUpdate(product.@group, ngroup)) { dataRow[6] = nname; } if (ShouldUpdate(product.photo_link, nphotoLink)) { dataRow[4] = nname; } break; } dataAdapter.Update(dataTable); dataAdapter.Dispose(); } } }
public DbNetResult ExecuteCommand(DbNetCommand command, ref IDbNetScope scope, ExecuteType executetype) { StringBuilder sqlBulider = new StringBuilder(PARAMTER_REPLACE.Replace(command.SqlText, "@${pName} OR @${pName} IS NULL")); string sql = sqlBulider.ToString(); foreach (Match m in FORMAT_PARAMTER_REPLACE.Matches(sql)) { if (m.Success) { var name = m.Groups[P_NAME].Value; var paramter = command.Paramters.Get(name); if (paramter == null) { //如果本身不存在参数集合里面则跳过 continue; } string res = val == null ? string.Empty : val.ToString(); var code = string.Format(FORMAT_CODE, name); sqlBulider = sqlBulider.Replace(code, res); } } sql = sqlBulider.ToString(); command.SqlText = sql; //封装数据库执行 object result = null; scope = GetScope(scope, command); scope.Open(); var s = scope as SQLiteDbNetScope; SQLiteCommand com = new SQLiteCommand(command.SqlText, s.Connection); if (s.Transaction != null) { com.Transaction = s.Transaction; } com.CommandTimeout = 30; switch (command.CommandType) { default: case "Text": com.CommandType = CommandType.Text; break; case "StoredProcedure": com.CommandType = CommandType.StoredProcedure; break; case "TableDirect": com.CommandType = CommandType.TableDirect; break; } foreach (var p in command.Paramters) { var sql_p = new SqlParameter(string.Format(PARAMTERFORAMT, p.Name), p.Value); if (p.Value == null) { sql_p.Value = DBNull.Value; } switch (p.Direction) { case DbNetParamterDirection.Input: sql_p.Direction = ParameterDirection.Input; break; case DbNetParamterDirection.InputAndOutPut: sql_p.Direction = ParameterDirection.InputOutput; break; case DbNetParamterDirection.Output: sql_p.Direction = ParameterDirection.Output; break; } com.Parameters.Add(sql_p); } switch (executetype) { case ExecuteType.ExecuteDateTable: using (SQLiteDataAdapter adapter = new SQLiteDataAdapter(com)) { DataSet set = new DataSet(); adapter.Fill(set); result = set; } break; case ExecuteType.ExecuteNoQuery: result = com.ExecuteNonQuery(); break; case ExecuteType.ExecuteObject: result = com.ExecuteScalar(); break; } scope.Close(); foreach (var p in command.Paramters) { string pName = string.Format(PARAMTERFORAMT, p.Name); if (com.Parameters[pName] != null) { object pv = com.Parameters[pName].Value; if (pv == DBNull.Value) { p.Value = null; } else { p.Value = com.Parameters[pName].Value; } } } return(new DbNetResult(result)); }
private void loadGridData(bool bind = true) { _dtResources = MasterData.WTS_Resource_Get(includeArchive: false); _dtUser = UserManagement.LoadUserList(organizationId: 0, excludeDeveloper: false, loadArchived: false, userNameSearch: ""); Page.ClientScript.RegisterArrayDeclaration("_userList", JsonConvert.SerializeObject(_dtUser, Newtonsoft.Json.Formatting.None)); DataTable dt = null, dtTemp = null; DataSet ds = null; if (_refreshData || Session["dtMD_AllocationDS"] == null) { ds = MasterData.AllocationList_Get(includeArchive: true); if (ds != null && ds.Tables.Count > 0) { if (ds.Tables.Contains("Allocation")) { dt = ds.Tables["Allocation"]; HttpContext.Current.Session["dtMD_AllocationDS"] = ds; } } } else { ds = (DataSet) HttpContext.Current.Session["dtMD_AllocationDS"]; if (ds.Tables.Contains("Allocation")) { dt = ds.Tables["Allocation"]; } } if (dt != null) { // 12902 - 3: dtTemp = dt.DefaultView.ToTable(true, new string[] { "AllocationGroupID", "AllocationGroup", "AllocationCategoryID", "AllocationCategory" }); dtTemp.DefaultView.RowFilter = "AllocationGroupID IS NOT NULL"; //dtTemp = dt.DefaultView.ToTable(true, new string[] { "AllocationCategoryID", "AllocationCategory" }); //dtTemp.DefaultView.RowFilter = "AllocationCategoryID IS NOT NULL"; dtTemp = dtTemp.DefaultView.ToTable(); this.DCC = dt.Columns; Page.ClientScript.RegisterArrayDeclaration("_dcc", JsonConvert.SerializeObject(DCC, Newtonsoft.Json.Formatting.None)); if (ds.Tables.Contains("Category")) { _dtCat = ds.Tables["Category"]; Page.ClientScript.RegisterArrayDeclaration("_AllocationCategoryList", JsonConvert.SerializeObject(_dtCat, Newtonsoft.Json.Formatting.None)); } //12092 - 3: if (ds.Tables.Contains("Group")) { _dtGroup = ds.Tables["Group"]; Page.ClientScript.RegisterArrayDeclaration("_AllocationGroupList", JsonConvert.SerializeObject(_dtGroup, Newtonsoft.Json.Formatting.None)); } ListItem item = null; foreach (DataRow row in dtTemp.Rows) { item = ddlQF.Items.FindByValue(row["AllocationCategoryID"].ToString()); if (item == null) { ddlQF.Items.Add(new ListItem(row["AllocationCategory"].ToString(), row["AllocationCategoryID"].ToString())); } // 12902 - 3: item = ddlQFGroup.Items.FindByValue(row["AllocationGroupID"].ToString()); if (item == null) { ddlQFGroup.Items.Add(new ListItem(row["AllocationGroup"].ToString(), row["AllocationGroupID"].ToString())); } } // 12092 - 3 - Remarked out: // item = ddlQF.Items.FindByValue(_qfAllocationCategoryID.ToString()); //if (item != null) //{ // item.Selected = true; //} // 12092 - 3: item = ddlQFGroup.Items.FindByValue(_qfAllocationGroupID.ToString()); if (item != null) { item.Selected = true; } InitializeColumnData(ref dt); dt.AcceptChanges(); iti_Tools_Sharp.DynamicHeader head = WTSUtility.CreateGridMultiHeader(dt); if (head != null) { grdMD.DynamicHeader = head; } } // 12902 - 3: if (_qfAllocationGroupID != 0 && dt != null && dt.Rows.Count > 0) { dt.DefaultView.RowFilter = string.Format(" AllocationGroupID = {0}", _qfAllocationGroupID.ToString()); dt = dt.DefaultView.ToTable(); } //if (_qfAllocationCategoryID != 0 && dt != null && dt.Rows.Count > 0) //{ // dt.DefaultView.RowFilter = string.Format(" AllocationCategoryID = {0}", _qfAllocationCategoryID.ToString()); // dt = dt.DefaultView.ToTable(); //} int count = dt.Rows.Count; count = count > 0 ? count - 1 : count; //need to subtract the empty row spanRowCount.InnerText = count.ToString(); if (_export) { exportExcel(dt); } grdMD.DataSource = dt; if (bind) grdMD.DataBind(); }
public void ReadComplexElementDocument() { var ds = new DataSet(); ds.ReadXml(new StringReader(xml29)); }
public void selectDataSet(DataSet dataSet) { ui_ComboBox_SelectDataSets.SelectedItem = null; ui_ComboBox_SelectDataSets.SelectedItem = dataSet; }
public ActionResult Login(string username, string password, Login login, Login lm, string rememberme) { lm.Username = username; lm.Password = password; bool rememberMe = true; if (rememberme != "on") { rememberMe = false; } FormsAuthentication.SetAuthCookie(username, rememberMe); HttpCookie myCookie = new HttpCookie("InspireUserCookie"); bool IsRemember = rememberMe; if (true) { string errorMessage = ""; string validityRemaining = ""; List<SqlParameter> parameters = new List<SqlParameter>(); parameters.Add(new SqlParameter() { ParameterName = "@UserName", SqlDbType = SqlDbType.VarChar, Value = lm.Username, Direction = System.Data.ParameterDirection.Input }); parameters.Add(new SqlParameter() { ParameterName = "@Password", SqlDbType = SqlDbType.VarChar, Value = lm.Password, Direction = System.Data.ParameterDirection.Input }); SqlParameter error = new SqlParameter() { ParameterName = "@Error", SqlDbType = SqlDbType.VarChar, Size = 1000, Direction = System.Data.ParameterDirection.Output }; SqlParameter validity = new SqlParameter() { ParameterName = "@validity", SqlDbType = SqlDbType.Int, Direction = System.Data.ParameterDirection.Output }; parameters.Add(error); parameters.Add(validity); DataSet dataSet = SqlManager.ExecuteDataSet("SP_LoginAIO", parameters.ToArray()); errorMessage = error.Value.ToString(); TempData["Message"] = errorMessage; ViewBag.errormsg = errorMessage; validityRemaining = validity.Value.ToString(); try { if (errorMessage == "Access Granted") { DataTable dt1 = dataSet.Tables[0]; string emailid = ""; UserInfo user = new UserInfo(); user.validity = validityRemaining; user.FirstName = emailid; if (dt1.Rows.Count > 0) { emailid = dt1.Rows[0]["Emailid"].ToString(); user.U_Id = Convert.ToInt32(dt1.Rows[0]["U_ID"]); Session["UID"] = user.U_Id; user.G_Id = Convert.ToInt32(dt1.Rows[0]["Group_Id"]); Session["GID"] = user.G_Id; user.Comp_ID = Convert.ToInt32(dt1.Rows[0]["Comp_ID"]); user.EmailId = dt1.Rows[0]["EmailId"].ToString(); user.FirstName = dt1.Rows[0]["FirstName"].ToString(); user.LastName = dt1.Rows[0]["LastName"].ToString(); user.UserName = dt1.Rows[0]["UserName"].ToString(); user.Comp_Type = dt1.Rows[0]["Type"].ToString(); user.Active = bool.Parse(dt1.Rows[0]["Active"].ToString()); user.Admin_Id = Convert.ToInt32(dt1.Rows[0]["Admin_Id"]); user.Trade_ID = Convert.ToInt32(dt1.Rows[0]["Trade"]); user.Profile_ID = dt1.Rows[0]["Profile"].ToString(); user.UserGroupName = dt1.Rows[0]["Group_Name"].ToString(); user.CompanyName = dt1.Rows[0]["CompName"].ToString(); Session["EmailId"] = dt1.Rows[0]["EmailId"].ToString(); Session["FullName"] = user.FirstName + " " + user.LastName; Session["GroupName"] = user.UserGroupName; Session["CompanyName"] = user.CompanyName; Session["ProfileId"] = user.Profile_ID; Session["TradeId"] = user.Trade_ID; } Session["UserInfo"] = user; if (IsRemember) { myCookie["username"] = username; myCookie["password"] = password; myCookie.Expires = DateTime.Now.AddDays(15); } else { myCookie["username"] = string.Empty; myCookie["password"] = string.Empty; myCookie.Expires = DateTime.Now.AddMinutes(1); } Response.Cookies.Add(myCookie); Response.SetCookie(myCookie); return RedirectToRoute(new { controller = "Inspire", action = "Admin", id = UrlParameter.Optional }); } else { return RedirectToRoute(new { controller = "Login", action = "Login", id = UrlParameter.Optional }); } } catch (Exception) { return RedirectToRoute(new { controller = "Login", action = "Login", id = UrlParameter.Optional }); } } else { return RedirectToRoute(new { controller = "Login", action = "Login", id = UrlParameter.Optional }); } }