public void UpdateJV(string CompanyCode, string delNo) { // string pcName = System.Net.Dns.GetHostEntry(HttpContext.Current.Request.ServerVariables["REMOTE_HOST"]).HostName.ToString(); string connstring = CConnection.GetFAMSConnectionString(); using (SqlConnection conn = new SqlConnection(connstring)) { using (SqlCommand cmd = new SqlCommand("Sp_update", conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; conn.Open(); cmd.Parameters.AddWithValue("@CompCode", CompanyCode); cmd.Parameters.AddWithValue("@VouchNo", delNo); cmd.ExecuteNonQuery(); } } }
public bool CheckVoucherPostFlag(string dealercode, string voucher) { try { SqlDataAdapter dta = new SqlDataAdapter("Select Post from GVouMaster where CompCode = '" + dealercode + "' and VouchNo = '" + voucher + "'", CConnection.GetFAMSConnectionString()); DataTable dt = new DataTable(); dta.Fill(dt); if (dt == null) { return(false); } if (dt.Rows.Count > 0 && dt.Rows[0]["Post"].ToString() == "Y") { return(true); } return(false); } catch (Exception ex) { return(false); } }