protected override void OnLoad(EventArgs e) { base.OnLoad(e); if (!this.IsPostBack) { //efectuar o data binding //dDL.DataSource = distritos; //dDL.DataBind(); SqlDB Bd = new SqlDB("ConStr_DivAdmin"); string str = "SELECT NomeDistrito from Distritos"; SqlCommand cmd = new SqlCommand(str, Bd.SqlConDB); Bd.SqlConDB.Open(); SqlDataReader dR = cmd.ExecuteReader(); //efectuar o data binding dDL.DataSource = dR; dDL.DataTextField = "NomeDistrito"; dDL.DataBind(); dR.Close(); Bd.SqlConDB.Close(); } return; }
public String getSelection(string fieldName, string filterValue) { System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append("{rs:["); using (SqlDB db = new SqlDB(ConfigurationManager.ConnectionStrings["dbconn"].ToString())) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "[sp_HubInventoryDetail_getSelectItems]"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@objectField", fieldName); cmd.Parameters.AddWithValue("@keyword", filterValue); DataTable dt = db.getDataTableWithCmd(ref cmd); cmd.Dispose(); if (dt.Rows.Count > 0) { sb.Append("\"" + urlString(dt.Rows[0][0].ToString()) + "\""); for (int i = 1; i < dt.Rows.Count; i++) { sb.Append(",\"" + urlString(dt.Rows[i][0].ToString()) + "\""); } } } sb.Append("]}"); return sb.ToString(); }
protected void MostrarSeleccao(Object obj, EventArgs e) { saida.Text = ""; ddlMunicipios.Items.Clear(); ddlMunicipios.Items.Insert(0, new ListItem("Seleccione...", "0")); //if(dDL.SelectedIndex!=0) //{ //ddlMunicipios.DataSource = municipios[dDL.SelectedIndex-1]; //ddlMunicipios.DataBind(); SqlDB Bd = new SqlDB("ConStr_DivAdmin"); string str = "SELECT NomeMunicipio from Municipios where [CodigoDistrito] = @distrito"; SqlCommand cmd = new SqlCommand(str, Bd.SqlConDB); cmd.Parameters.AddWithValue("@distrito",dDL.SelectedItem.Value); cmd.Connection = Bd.SqlConDB; Bd.SqlConDB.Open(); SqlDataReader dR = cmd.ExecuteReader(); //efectuar o data binding ddlMunicipios.DataSource = dR; ddlMunicipios.DataTextField = "NomeMunicipio"; ddlMunicipios.DataValueField = "IdMunicipio"; ddlMunicipios.DataBind(); dR.Close(); Bd.SqlConDB.Close(); //} }
protected void ImageButton3_Click(object sender, ImageClickEventArgs e) { using (SqlDB db = new SqlDB(ConfigurationManager.ConnectionStrings["dbconn"].ToString())) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "sp_HubInv_SyncPolicy"; cmd.CommandType = CommandType.StoredProcedure; db.execSqlWithCmd(ref cmd); cmd.Dispose(); } loadOEM(); }
/// <summary> /// 使用存储过程添加图书 /// </summary> /// <param name="book"></param> /// <returns></returns> public int AddBook(Books book) { //封装参数 SqlParameter[] param = new SqlParameter[] { new SqlParameter("@BarCode", book.barCode), new SqlParameter("@BookName", book.BookName), new SqlParameter("@Author", book.author), new SqlParameter("@PublisherId", book.publisherId), new SqlParameter("@PublishDate", book.publishDate), new SqlParameter("@BookCategory", book.bookCategory), new SqlParameter("@UnitPrice", book.unitPrice), new SqlParameter("@BookImage", book.bookImage), new SqlParameter("@BookCount", book.BookCount), new SqlParameter("@BookPosition", book.bookPosition), new SqlParameter("@Remainder", book.Remainder), }; //调用通用数据访问方法提交对象 return(SqlDB.UpdateByProcedure("usp_AddBook", param)); }
} // End Create public List <SI_DESCRIP_KEYS> Read() { List <SI_DESCRIP_KEYS> list = new List <SI_DESCRIP_KEYS>(); DataTable dt = SqlDB.Select("SI_DESCRIP_KEYS"); foreach (DataRow dr in dt.Rows) { list.Add( new SI_DESCRIP_KEYS( Convert.ToInt32(dr["CLA_CONCEPTO"]), Convert.ToString(dr["NOM_TABLA"]), Convert.ToInt32(dr["CONSECUTIVO"]), Convert.ToString(dr["NOM_FISICOK"]), Convert.ToString(dr["NOM_FISICOK_JOIN"]) ) ); } return(list); } // End Read
//会员办证(添加读者信息) public int AddReader(Readers reader) { string sql = "insert into Readers(ReadingCard,ReaderName,Gender,IDCard,ReaderAddress,PostCode,PhoneNumber,RoleId,ReaderImage)"; sql += " values(@ReadingCard,@ReaderName,@Gender,@IDCard,@ReaderAddress,@PostCode,@PhoneNumber,@RoleId,@ReaderImage)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@ReadingCard", reader.ReadingCard), new SqlParameter("@ReaderName", reader.ReaderName), new SqlParameter("@Gender", reader.Gender), new SqlParameter("@IDCard", reader.IDCard), new SqlParameter("@ReaderAddress", reader.ReaderAddress), new SqlParameter("@PostCode", reader.PostCode), new SqlParameter("@PhoneNumber", reader.PhoneNumber), new SqlParameter("@RoleId", reader.RoleId), new SqlParameter("@ReaderImage", reader.ReaderImage), }; return(SqlDB.Update(sql, param)); }
/// <summary> /// 生成表單號 /// </summary> /// <param name="CodeName"></param> /// <param name="CodeFix"></param> /// <returns></returns> public static string GetFormNO(string CodeFix) { string Prefix = CodeFix + DateTime.Today.ToString("yyyyMM"); SqlDB sdb = new SqlDB(DataPara.GetDbConnectionString("NPI_REPORT")); ArrayList opc = new ArrayList(); opc.Add(DataPara.CreateDataParameter("@CODE1", DbType.String, Prefix, ParameterDirection.Input, 50)); opc.Add(DataPara.CreateDataParameter("@CODE2", DbType.Int32, null, ParameterDirection.Output, 50)); string no = string.Empty; try { no = sdb.ExecuteProcScalar("[p_GetNumber]", opc, "@CODE2"); } catch (Exception) { throw; } return(Prefix + "-" + int.Parse(no).ToString("0000#")); }
protected void Button1_Click(object sender, System.EventArgs e) { cValue = int.Parse(this.ViewState["cValue"].ToString()); SqlDB sqldb = new SqlDB(System.Configuration.ConfigurationSettings.AppSettings["connstr"]); if (cValue == 2) { cValue2 = int.Parse(TextBox1.Text.ToString()); cValue3 = int.Parse(TextBox2.Text.ToString()); } else { if (cValue == 3) { cValue2 = int.Parse(TextBox3.Text.ToString()); cValue3 = int.Parse(TextBox4.Text.ToString()); } else { cValue2 = 1; cValue3 = 100; } } string mystrSql2 = "Select cValue From Question_Retry Where cCaseID = '" + cCaseID + "' And cQID = '" + cQID + "' And cDivisionID = '" + cDivisionID + "' And cSectionName = '" + SectionName + "' And cUserLevel = '" + cUserlevel + "' And CurrentTerm = '" + CurrentTerm + "'And cDescription='retry'"; DataTable dtResult = new DataTable(); dtResult = sqldb.getDataSet(mystrSql2).Tables[0]; if (dtResult.Rows.Count > 0) { string mySQL = "update Question_Retry set cValue='" + cValue + "',cValue2='" + cValue2 + "' Where cCaseID = '" + cCaseID + "' And cQID = '" + cQID + "' And cDivisionID = '" + cDivisionID + "' And cSectionName = '" + SectionName + "' And cUserLevel = '" + cUserlevel + "' And CurrentTerm = '" + CurrentTerm + "'And cDescription='retry'"; sqldb.ExecuteNonQuery(mySQL); Response.Redirect("QandA_select_setRetry.aspx?CaseID=" + cCaseID + "&CurrentTerm=" + CurrentTerm + "&SectionName=" + SectionName + "&cQID=" + cQID + "&cDivisionID=" + cDivisionID + ""); } else { string mySQL = "insert into Question_Retry (cCaseID,CurrentTerm,cSectionName,cQID,cDivisionID,cUserLevel,cDescription,cValue,cValue2) values('" + cCaseID + "','" + CurrentTerm + "','" + SectionName + "','" + cQID + "','" + cDivisionID + "','" + cUserlevel + "','retry','" + cValue + "','" + cValue2 + "')"; sqldb.ExecuteNonQuery(mySQL); Response.Redirect("QandA_select_setRetry.aspx?CaseID=" + cCaseID + "&CurrentTerm=" + CurrentTerm + "&SectionName=" + SectionName + "&cQID=" + cQID + "&cDivisionID=" + cDivisionID + ""); } }
/// <summary> /// 儲存RandomSelection的設定 /// </summary> public void saveRandomSelection(System.Web.UI.Page WebPage, string strPaperID) { RadioButton rbYes = ((RadioButton)(WebPage.FindControl("Form1").FindControl("rb-RandomSelection-Yes"))); //此功能是否有被開啟 int intSelect = 1; if (rbYes.Checked) { intSelect = 1; } else { intSelect = 0; } SqlDB myDB = new SqlDB(System.Configuration.ConfigurationSettings.AppSettings["connstr"]); string strSQL = "UPDATE Paper_Header SET bRandomSelection = '" + intSelect.ToString() + "' WHERE cPaperID = '" + strPaperID + "' "; myDB.ExecuteNonQuery(strSQL); }
/// <summary> /// 儲存StudentNameVisibleMode的設定 /// </summary> public void saveStudentNameVisibleModePresentation(System.Web.UI.Page WebPage, string strPaperID) { RadioButton rbVisible = ((RadioButton)(WebPage.FindControl("Form1").FindControl("rb-Visible"))); //此功能是否有被開啟 int intSelect = 1; if (rbVisible.Checked) { intSelect = 1; } else { intSelect = 0; } SqlDB myDB = new SqlDB(System.Configuration.ConfigurationSettings.AppSettings["connstr"]); string strSQL = "UPDATE Paper_Header SET bIsStudentNameVisible = '" + intSelect.ToString() + "' WHERE cPaperID = '" + strPaperID + "' "; myDB.ExecuteNonQuery(strSQL); }
private void BtnDeleteTable_Click(object sender, EventArgs e) { if (lbxTableList.SelectedItem == null) { System.Windows.Forms.MessageBox.Show("请选择一个表", "验证"); } else { DialogResult result = System.Windows.Forms.MessageBox.Show("确定要删除" + lbxTableList.SelectedItem.ToString() + "表的所有分表吗?", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { StringBuilder sb = new StringBuilder(); int tableCount = Convert.ToInt32(txtTableCount.Text); string tableName = lbxTableList.SelectedItem.ToString(); SqlDB db = new SqlDB(txtConnString.Text); DataTable dbNameDT = db.ExecuteDataTableByText("Select Name From Master..SysDataBases Where DbId=(Select Dbid From Master..SysProcesses Where Spid = @@spid)"); string dbName = dbNameDT.Rows[0][0].ToString(); //数据库名称 for (int i = 0; i < tableCount; i++) { string fileGroup = dbName + "_" + tableName + "_" + i.ToString(); sb.AppendLine("if exists (select top 1 * from sysobjects where id = object_id('" + tableName + "_" + i.ToString() + "') and type = 'U') begin DROP TABLE " + tableName + "_" + i.ToString() + " end"); if (cbIsCreateFileGroup.Checked) { sb.AppendLine("ALTER DATABASE [" + dbName + "] REMOVE FILE " + fileGroup); sb.AppendLine("ALTER DATABASE [" + dbName + "] REMOVE FILEGROUP " + fileGroup); } db.ExecuteNonQueryByText(sb.ToString()); sb.Clear(); } LoadTable(); System.Windows.Forms.MessageBox.Show("删除分表成功", "消息"); } else { return; } } }
public string GetAttachmentInfo() { StringBuilder sbErrMsg = new StringBuilder(); StringBuilder sbType = new StringBuilder(); int TypeCount = oUIControls.cmbAttachmentType.Items.Count; SqlDB sdb = new SqlDB(DataPara.GetDbConnectionString("NPI_REPORT")); string sql = "SELECT FILE_TYPE FROM TB_NPI_APP_ATTACHFILE WITH(NOLOCK)" + " WHERE 1=1 AND SUB_DOC_NO=@doc_no"; ArrayList opc = new ArrayList(); opc.Clear(); opc.Add(DataPara.CreateDataParameter("@doc_no", DbType.String, oUIControls.txtFormNo.Text)); DataTable dt = sdb.TransactionExecute(sql, opc); if (dt.Rows.Count > 0) { string[] arrUploaed = new string[dt.Rows.Count]; string[] arrTotal = new string[TypeCount]; for (int i = 0; i < dt.Rows.Count; i++) { arrUploaed[i] = dt.Rows[i]["FILE_TYPE"].ToString().ToUpper(); } for (int j = 0; j < TypeCount; j++) { arrTotal[j] = oUIControls.cmbAttachmentType.Items[j].Text.ToString().ToUpper().Trim(); } string[] arrNew = arrTotal.Except(arrUploaed).ToArray(); for (int m = 0; m < arrNew.Length; m++) { sbErrMsg.AppendFormat("{0} 附件未上傳!", arrNew[m]); } } else { sbErrMsg.Append("附件未上傳,請確認!"); } return(sbErrMsg.ToString()); }
} // End GetData public DataTable GetDataTable( System.Int32?cla_concepto) { string sqlstr = @"SELECT PC.CLA_CONCEPTO, P.NOM_PERIODO PERIODO_TIEMPO, P.FMT_PERIODO FORMATO, DE.NOM_TABLA TABLA, CL.NOM_FISICO CAMPO_FISICO_CLAVE, CL.NOM_DESCRIPTOR CAMPO_FISICO_DESCRIPCION, 'SI' INCLUIRSE, '' DESCRIPCION FROM SI_PERIODO P INNER JOIN SI_PERIODOSxCUBO PC ON P.CLA_PERIODO = PC.CLA_PERIODO INNER JOIN SI_CPTO_LLAVE CL ON PC.CLA_PERIODO = CL.CLA_PERIODO AND PC.CLA_CONCEPTO = CL.CLA_CONCEPTO INNER JOIN SI_DESCRIP_ENC DE ON CL.CLA_DESCRIP = DE.CLA_DESCRIP WHERE PC.CLA_CONCEPTO = @CLA_CONCEPTO AND P.CLA_PERIODO IN ( SELECT DISTINCT CLA_PERIODO FROM SI_CPTO_LLAVE WHERE NOT CLA_PERIODO IS NULL AND CLA_PERIODO <> -1 AND CLA_CONCEPTO = @CLA_CONCEPTO ) ORDER BY PERIODO_TIEMPO" ; Hashtable m_params = new Hashtable(); m_params.Add("@CLA_CONCEPTO", cla_concepto); return(SqlDB.Query(sqlstr, m_params)); } // End GetDataTable
//Close open Malfunction button private void close_mals_button_Click(object sender, RoutedEventArgs e) { if (openMalslvDataBinding.SelectedItem != null) { db = new SqlDB(); int temp = ((Malfunction)(openMalslvDataBinding.SelectedItem)).id; try { db.closeMals(temp); UpdateListOfClosedMals(); UpdateListOfOpenMals(); } finally { MessageBox.Show(".תקלה נסגרה בהצלחה"); } } else { MessageBox.Show("לא נבחרה תקלה"); } }
public static int Join_StudentAdd_WanShanXinXi(Entity.Join_Student info) { SqlParameter[] prams = { SqlDB.MakeInParam("@StudentName", SqlDbType.NVarChar, 50, info.StudentName), SqlDB.MakeInParam("@Sex", SqlDbType.Int, 4, info.Sex), SqlDB.MakeInParam("@CellPhone", SqlDbType.VarChar, 50, info.CellPhone), SqlDB.MakeInParam("@SchoolName", SqlDbType.NVarChar, 150, info.SchoolName), SqlDB.MakeInParam("@FuQinPhone", SqlDbType.NVarChar, 50, info.FuQinPhone), SqlDB.MakeInParam("@MuQinPhone", SqlDbType.NVarChar, 50, info.MuQinPhone), SqlDB.MakeInParam("@WenLi", SqlDbType.Int, 4, info.WenLi), SqlDB.MakeInParam("@BanJi", SqlDbType.NVarChar, 100, info.BanJi), SqlDB.MakeInParam("@BanZhuRen", SqlDbType.NVarChar, 100, info.BanZhuRen), SqlDB.MakeInParam("@ProvinceId", SqlDbType.Int, 4, info.ProvinceId), SqlDB.MakeInParam("@CityId", SqlDbType.Int, 4, info.CityId), SqlDB.MakeInParam("@CountyId", SqlDbType.Int, 4, info.CountyId), SqlDB.MakeInParam("@BanZhuRenMobile", SqlDbType.NVarChar, 100, info.BanZhuRenMobile), SqlDB.MakeInParam("@GKYear", SqlDbType.Int, 4, info.GKYear), SqlDB.MakeInParam("@StudentLevel", SqlDbType.Int, 4, info.StudentLevel), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.StoredProcedure, "Join_StudentAdd_WanShanXinXi", prams).ToString(), -1)); }
public static Entity.Join_Card Join_CardEntityGetByCardBank(string CardBank, string CardPass) { Entity.Join_Card info = new Entity.Join_Card(); SqlParameter[] prams = { SqlDB.MakeInParam("@CardBank", SqlDbType.NVarChar, 100, CardBank), SqlDB.MakeInParam("@CardPass", SqlDbType.NVarChar, 50, CardPass), }; DataTable dt = SqlDB.ExecuteDataset(strCon, CommandType.StoredProcedure, "Join_CardEntityGet", prams).Tables[0]; //DataTable dt = SqlDB.ExecuteDataset(strCon, CommandType.Text, "SELECT * FROM [Join_Card] WHERE CardBank = '" + CardBank + "' AND CardPass = '******'").Tables[0]; if (dt.Rows.Count > 0) { info.CardId = Basic.Utils.StrToInt(dt.Rows[0]["CardId"].ToString(), 0); info.CardBank = dt.Rows[0]["CardBank"].ToString(); info.CardPass = dt.Rows[0]["CardPass"].ToString(); info.IsValid = Basic.Utils.StrToInt(dt.Rows[0]["IsValid"].ToString(), 0); info.UseState = Basic.Utils.StrToInt(dt.Rows[0]["UseState"].ToString(), 0); info.DianId = Basic.Utils.StrToInt(dt.Rows[0]["DianId"].ToString(), 0); info.ProvinceId = Basic.Utils.StrToInt(dt.Rows[0]["ProvinceId"].ToString(), 0); info.StudentId = Basic.Utils.StrToInt(dt.Rows[0]["StudentId"].ToString(), 0); info.UseIp = dt.Rows[0]["UseIp"].ToString(); info.IsTest = Basic.Utils.StrToInt(dt.Rows[0]["IsTest"].ToString(), 0); info.OpenCardTime = Basic.TypeConverter.StrToDateTime(dt.Rows[0]["OpenCardTime"].ToString()); info.UseTime = Basic.TypeConverter.StrToDateTime(dt.Rows[0]["UseTime"].ToString()); info.OpenCardTime = Basic.TypeConverter.StrToDateTime(dt.Rows[0]["OpenCardTime"].ToString()); info.UseTime = Basic.TypeConverter.StrToDateTime(dt.Rows[0]["UseTime"].ToString()); return(info); } else { return(null); } }
public static Entity.YuSheChengJi YuSheChengJiEntityGetByStudentId(int StudentId) { Entity.YuSheChengJi info = new Entity.YuSheChengJi(); DataTable dt = SqlDB.ExecuteDataset(CommandType.Text, "SELECT * FROM [YuSheChengJi] WHERE StudentId = " + StudentId + ";").Tables[0]; if (dt.Rows.Count > 0) { info.Id = Basic.Utils.StrToInt(dt.Rows[0]["Id"].ToString(), 0); info.StudentId = Basic.Utils.StrToInt(dt.Rows[0]["StudentId"].ToString(), 0); info.KeLei = Basic.Utils.StrToInt(dt.Rows[0]["KeLei"].ToString(), 0); info.FenShu = Basic.Utils.StrToInt(dt.Rows[0]["FenShu"].ToString(), 0); info.PcFirst = Basic.Utils.StrToInt(dt.Rows[0]["PcFirst"].ToString(), 0); info.PcSecond = Basic.Utils.StrToInt(dt.Rows[0]["PcSecond"].ToString(), 0); info.PcThird = Basic.Utils.StrToInt(dt.Rows[0]["PcThird"].ToString(), 0); info.PcZhuanKe = Basic.Utils.StrToInt(dt.Rows[0]["PcZhuanKe"].ToString(), 0); info.AddTime = Basic.Utils.StrToDateTime(dt.Rows[0]["AddTime"].ToString()); return(info); } else { return(null); } }
} // End Read public SI_DESCRIP_KEYS Read(int cla_concepto, string nom_tabla, int consecutivo) { Hashtable w_params = new Hashtable(); w_params.Add("CLA_CONCEPTO", cla_concepto); w_params.Add("NOM_TABLA", nom_tabla); w_params.Add("CONSECUTIVO", consecutivo); DataTable dt = SqlDB.Select("SI_DESCRIP_KEYS", w_params); if (dt.Rows.Count == 0) { throw new Exception("No existe SI_DESCRIP_KEYS con los criterios de búsqueda especificados."); } DataRow dr = dt.Rows[0]; return(new SI_DESCRIP_KEYS( Convert.ToInt32(dr["CLA_CONCEPTO"]), Convert.ToString(dr["NOM_TABLA"]), Convert.ToInt32(dr["CONSECUTIVO"]), Convert.ToString(dr["NOM_FISICOK"]), Convert.ToString(dr["NOM_FISICOK_JOIN"]) )); } // End Read
protected void Btn_finish_Click(object sender, EventArgs e) { SqlDB myDB = new SqlDB(System.Configuration.ConfigurationSettings.AppSettings["connstr"]); //刪除q_s_a中的記錄 string strSQL = "DELETE Question_Simulator_ans WHERE cQuestion_simulator_ID LIKE '" + hf_QID.Value + "'"; clsHintsDB MLASDB = new clsHintsDB(); MLASDB.ExecuteNonQuery(strSQL); //UPDATE response //strSQL = "SELECT * FROM Question_Simulator WHERE cQID LIKE '" + hf_QID.Value + "'"; //DataTable dt_firstTime = MLASDB.getDataSet(strSQL).Tables[0]; //for (int i = 0; i > dt_firstTime.Rows.Count; i++) //{ // Label LB_temp = (Label)this.FindControl("form1").FindControl("Res_" + dt_firstTime.Rows[i]["cAnsID"].ToString()); // strSQL = "UPDATE Question_Simulator SET cAnsID=@cAnsID WHERE cResponse LIKE @cResponse "; // object[] pList = { dt_firstTime.Rows[i]["cAnsID"].ToString(), LB_temp.Text }; // myDB.ExecuteNonQuery(strSQL, pList); //} //go to next step Response.Redirect("Paper_QuestionViewNew.aspx?GroupID=" + Session["GroupID"].ToString()); }
/// <summary> /// 建立一個Section的下拉式選單 /// </summary> /// <param name="strCaseID"></param> /// <param name="intClinicNum"></param> /// <param name="strSectionName"></param> public void setupSectionList(DropDownList dlSection, string strCaseID, int intClinicNum, string strSectionName, string strPaperID, string strQID, string strSelectionID) { dlSection.Items.Clear(); //取得此Section在UserLevelPresent的DivisionID string strDivisionID = DataReceiver.getDivisionIDFromUserLevelPresentBySectionName(strCaseID, intClinicNum, strSectionName); //取得此選項是否有被Assign某個Section string strNextSection = DataReceiver.getNextSectionNameFromNextStepBySelectionID(strPaperID, strQID, strSelectionID); SqlDB sqldb = new SqlDB(System.Configuration.ConfigurationSettings.AppSettings["connstr"]); string strSQL = "SELECT cSectionName FROM UserLevelPresent WHERE cCaseID = '" + strCaseID + "' AND sClinicNum = '" + intClinicNum.ToString() + "' AND cDivisionID = '" + strDivisionID + "' ORDER BY sSectionSeq"; DataSet dsSection = sqldb.getDataSet(strSQL); if (dsSection.Tables[0].Rows.Count > 0) { for (int i = 0; i < dsSection.Tables[0].Rows.Count; i++) { string strSection = dsSection.Tables[0].Rows[i]["cSectionName"].ToString(); ListItem li = new ListItem(strSection, strSection); //不顯示此問卷所屬的Section if (strSection != strSectionName) { dlSection.Items.Add(li); } if (strSection == strNextSection) { li.Selected = true; } } } dsSection.Dispose(); }
public static Entity.ProfessionalArticle ProfessionalArticleEntityGetByProfessionalId(int intProfessionalId) { Entity.ProfessionalArticle info = new Entity.ProfessionalArticle(); DataTable dt = SqlDB.ExecuteDataset(CommandType.Text, "SELECT Top 1 * FROM [ProfessionalArticle] WHERE ProfessionalId = " + intProfessionalId + " ORDER BY Id DESC").Tables[0]; if (dt.Rows.Count > 0) { info.Id = Basic.Utils.StrToInt(dt.Rows[0]["Id"].ToString(), 0); info.ProfessionalId = Basic.Utils.StrToInt(dt.Rows[0]["ProfessionalId"].ToString(), 0); info.CategoryId = Basic.Utils.StrToInt(dt.Rows[0]["CategoryId"].ToString(), 0); info.Icon = dt.Rows[0]["Icon"].ToString(); info.Title = dt.Rows[0]["Title"].ToString(); info.ShortTitle = dt.Rows[0]["ShortTitle"].ToString(); info.MetaTitle = dt.Rows[0]["MetaTitle"].ToString(); info.MetaKeyWords = dt.Rows[0]["MetaKeyWords"].ToString(); info.MetaDescription = dt.Rows[0]["MetaDescription"].ToString(); info.Summary = dt.Rows[0]["Summary"].ToString(); info.Content = dt.Rows[0]["Content"].ToString(); info.IsPause = Basic.Utils.StrToInt(dt.Rows[0]["IsPause"].ToString(), 0); info.IsTuiJian = Basic.Utils.StrToInt(dt.Rows[0]["IsTuiJian"].ToString(), 0); info.IsNew = Basic.Utils.StrToInt(dt.Rows[0]["IsNew"].ToString(), 0); info.IsZhiDing = Basic.Utils.StrToInt(dt.Rows[0]["IsZhiDing"].ToString(), 0); info.AddWid = Basic.Utils.StrToInt(dt.Rows[0]["AddWid"].ToString(), 0); info.IsCheck = Basic.Utils.StrToInt(dt.Rows[0]["IsCheck"].ToString(), 0); info.CheckWid = Basic.Utils.StrToInt(dt.Rows[0]["CheckWid"].ToString(), 0); info.ClickNum = Basic.Utils.StrToInt(dt.Rows[0]["ClickNum"].ToString(), 0); info.AddTime = Basic.Utils.StrToDateTime(dt.Rows[0]["AddTime"].ToString()); info.CheckTime = Basic.Utils.StrToDateTime(dt.Rows[0]["CheckTime"].ToString()); info.PublishTime = Basic.Utils.StrToDateTime(dt.Rows[0]["PublishTime"].ToString()); info.ZhiDingTime = Basic.Utils.StrToDateTime(dt.Rows[0]["ZhiDingTime"].ToString()); return(info); } else { return(null); } }
/// <summary> /// 错题本 分页 /// </summary> /// <param name="strWhere">条件,可以为空</param> /// <returns>返回DataTable</returns> public static DataTable CuoTiBenPageList(string strWhere, int PageSize, int PageIndex) { string strSql; if (!string.IsNullOrEmpty(strWhere.Trim())) { strSql = "SELECT TiMuNeiRong.*,cuotiben.Answer as cuotibenAnswer,cuotiben.Id as cuotibenId FROM [TiMuNeiRong],[cuotiben] WHERE TiMuNeiRong.id = cuotiben.TiMuId AND " + strWhere; } else { strSql = "SELECT TiMuNeiRong.*,cuotiben.Answer as cuotibenAnswer,cuotiben.Id as cuotibenId FROM [TiMuNeiRong],[cuotiben] WHERE TiMuNeiRong.id = cuotiben.TiMuId "; } strSql += " ORDER BY cuotibenId DESC"; DataSet ds = new DataSet(); ds = SqlDB.ExecuteDataset((PageIndex - 1) * PageSize, PageSize, strCon, CommandType.Text, strSql); if (ds.Tables.Count > 0) { return(ds.Tables[0]); } return(new DataTable()); }
private static void PostAddUser_A3() { sdb = new SqlDB(DataPara.GetDbConnectionString("ICDB")); opc.Clear(); opc.Add(DataPara.CreateDataParameter("@P_EmpId", DbType.String, "Employeeid", ParameterDirection.Input)); DataTable dtuser = sdb.ExecuteProcTable("P_GetCardUSERInfo", opc); if (dtuser.Rows.Count > 0) { foreach (DataRow druser in dtuser.Rows) { bool Status = CheckUser(druser); if (Status == false) { InsertUser(druser); } } SendMails("success"); } else { SendMails("None"); } }
public static Entity.Join_Student Join_StudentEntityGetBank(string StudentBank, string StudentPass) { Entity.Join_Student info = new Entity.Join_Student(); SqlParameter[] prams = { SqlDB.MakeInParam("@Bank", SqlDbType.NVarChar, 100, StudentBank), SqlDB.MakeInParam("@Pass", SqlDbType.NVarChar, 50, StudentPass), SqlDB.MakeInParam("@MD5Pass", SqlDbType.NVarChar, 50, Basic.CreateMD5.Md5Encrypt(StudentPass)), }; DataTable dt = SqlDB.ExecuteDataset(strCon, CommandType.StoredProcedure, "StudentEntityGet", prams).Tables[0]; // DataTable dt = SqlDB.ExecuteDataset(strCon, CommandType.Text, "SELECT * FROM [Join_Student] WHERE StudentBank = '" + StudentBank + "' AND (StudentPass = '******' OR StudentPass = '******')").Tables[0]; if (dt != null && dt.Rows.Count > 0) { info.StudentId = Basic.Utils.StrToInt(dt.Rows[0]["StudentId"].ToString(), 0); info.StudentBank = dt.Rows[0]["StudentBank"].ToString(); info.StudentPass = dt.Rows[0]["StudentPass"].ToString(); info.StudenName = dt.Rows[0]["StudenName"].ToString(); info.StudentName = dt.Rows[0]["StudentName"].ToString(); info.Sex = Basic.Utils.StrToInt(dt.Rows[0]["Sex"].ToString(), 0); info.CellTel = dt.Rows[0]["CellTel"].ToString(); info.CellPhone = dt.Rows[0]["CellPhone"].ToString(); info.CellPhoneCheck = Basic.Utils.StrToInt(dt.Rows[0]["CellPhoneCheck"].ToString(), 0); info.Address = dt.Rows[0]["Address"].ToString(); info.SchoolName = dt.Rows[0]["SchoolName"].ToString(); info.IdNumber = dt.Rows[0]["IdNumber"].ToString(); info.CheckIdNumber = Basic.Utils.StrToInt(dt.Rows[0]["CheckIdNumber"].ToString(), 0); info.IdNumberPic = dt.Rows[0]["IdNumberPic"].ToString(); info.BirthDate = dt.Rows[0]["BirthDate"].ToString(); info.RegisterWay = Basic.Utils.StrToInt(dt.Rows[0]["RegisterWay"].ToString(), 0); info.RegisterOrigin = dt.Rows[0]["RegisterOrigin"].ToString(); info.DldId = Basic.Utils.StrToInt(dt.Rows[0]["DldId"].ToString(), 0); info.UserCategory = Basic.Utils.StrToInt(dt.Rows[0]["UserCategory"].ToString(), 0); info.PositionCase = dt.Rows[0]["PositionCase"].ToString(); info.IsPause = Basic.Utils.StrToInt(dt.Rows[0]["IsPause"].ToString(), 0); info.Mail = dt.Rows[0]["Mail"].ToString(); info.QQ = dt.Rows[0]["QQ"].ToString(); info.About = dt.Rows[0]["About"].ToString(); info.Company = dt.Rows[0]["Company"].ToString(); info.MSN = dt.Rows[0]["MSN"].ToString(); info.ArtDialog = Basic.Utils.StrToInt(dt.Rows[0]["ArtDialog"].ToString(), 0); info.FuQinPhone = dt.Rows[0]["FuQinPhone"].ToString(); info.MuQinPhone = dt.Rows[0]["MuQinPhone"].ToString(); info.WenLi = Basic.Utils.StrToInt(dt.Rows[0]["WenLi"].ToString(), 0); info.BanJi = dt.Rows[0]["BanJi"].ToString(); info.BanZhuRen = dt.Rows[0]["BanZhuRen"].ToString(); info.ProvinceId = Basic.Utils.StrToInt(dt.Rows[0]["ProvinceId"].ToString(), 0); info.CityId = Basic.Utils.StrToInt(dt.Rows[0]["CityId"].ToString(), 0); info.CountyId = Basic.Utils.StrToInt(dt.Rows[0]["CountyId"].ToString(), 0); info.IsAutoCreat = Basic.Utils.StrToInt(dt.Rows[0]["IsAutoCreat"].ToString(), 0); info.BanZhuRenMobile = dt.Rows[0]["BanZhuRenMobile"].ToString(); info.StudentLevel = Basic.Utils.StrToInt(dt.Rows[0]["StudentLevel"].ToString(), 0); info.GKYear = Basic.Utils.StrToInt(dt.Rows[0]["GKYear"].ToString(), 0); info.RegisterTime = Basic.Utils.StrToDateTime(dt.Rows[0]["RegisterTime"].ToString()); return(info); } else { return(null); } }
private DataTable getData() { DataTable dt = new DataTable(); using (SqlDB sqldb = new SqlDB(ConfigurationManager.ConnectionStrings["biconn"].ToString())) { int start = 0; int end = 0; if (startDate.Text.Trim() != "") start = Convert.ToInt32(DateTime.ParseExact(startDate.Text.Trim(), @"M/d/yyyy", null).ToString("yyyyMMdd")); if (endDate.Text.Trim() != "") end = Convert.ToInt32(DateTime.ParseExact(endDate.Text.Trim(), @"M/d/yyyy", null).ToString("yyyyMMdd")); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "[sp_MKTRPT_projectDetail]"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@oem", OEM.Text.Trim()); cmd.Parameters.AddWithValue("@plant", Plant.Text.Trim()); cmd.Parameters.AddWithValue("@project ", project.Text.Trim()); cmd.Parameters.AddWithValue("@layer", layer.Text.Trim()); cmd.Parameters.AddWithValue("@tech", tech.Text.Trim()); cmd.Parameters.AddWithValue("@surf", surf.Text.Trim()); cmd.Parameters.AddWithValue("@startDate", start); cmd.Parameters.AddWithValue("@endDate", end); dt = sqldb.getDataTableWithCmd(ref cmd); cmd.Dispose(); } return dt; }
protected void btnQuery_click(object sender, DirectEventArgs e) { SqlDB sdb = new SqlDB(DataPara.GetDbConnectionString("NPI_REPORT")); string prod_group = string.Empty; string model_name = string.Empty; string formno = string.Empty; string apply_date = string.Empty; string approve = string.Empty; StringBuilder errMsg = new StringBuilder(); if (sbProd_group.SelectedIndex < 0) { errMsg.Append("請選擇產品類別"); } if (errMsg.Length > 0) { Alert(errMsg.ToString()); return; } prod_group = sbProd_group.SelectedItem.Value.Trim(); model_name = txtModel.Text.Trim(); formno = txtFormNo.Text.Trim(); approve = txtApprove.Text.Trim(); apply_date = txtApplyDate.SelectedDate.ToShortDateString() == "1/1/0001" ? "" : txtApplyDate.SelectedDate.ToShortDateString(); StringBuilder sql = new StringBuilder(); opc.Clear(); sql.Append(" SELECT T2.*,T1.MODEL_NAME,T1.PROD_GROUP,T1.CUSTOMER FROM TB_NPI_APP_MAIN T1"); sql.Append(" LEFT JOIN TB_NPI_APP_MEMBER T2 ON T1.DOC_NO=T2.DOC_NO"); sql.Append(" WHERE T1.PROD_GROUP=@PROD_GROUP AND T1.BU=@bu AND T1.BUILDING=@building "); opc.Add(DataPara.CreateDataParameter("@PROD_GROUP", DbType.String, prod_group)); opc.Add(DataPara.CreateDataParameter("@bu", DbType.String, lblBu.Text)); opc.Add(DataPara.CreateDataParameter("@building", DbType.String, lblBuilding.Text)); if (model_name.Length > 0) { sql.Append(" AND T1.MODEL_NAME like '%" + model_name + "%'"); } if (apply_date.Length > 0) { sql.Append("AND T1.APPLY_DATE=@APPLY_DATE "); opc.Add(DataPara.CreateDataParameter("@APPLY_DATE", DbType.String, apply_date)); } if (formno.Length > 0) { sql.Append("AND T1.DOC_NO=@FORM_NO "); opc.Add(DataPara.CreateDataParameter("@FORM_NO", DbType.String, formno)); } if (approve.Length > 0) { sql.Append(" AND (T2.WriteEname=@ENAME OR T2.ReplyEName=@ENAME OR T2.CheckedEName=@ENAME)"); opc.Add(DataPara.CreateDataParameter("@ENAME", DbType.String, approve)); } DataTable dt = sdb.TransactionExecute(sql.ToString(), opc); BindGrid(dt, grdInfo); }
protected void AfterEdit(object sender, DirectEventArgs e) { string DOC_NO = e.ExtraParams["DOC_NO"]; string ID = e.ExtraParams["ID"]; string WriteEname = e.ExtraParams["WriteEname"]; string ReplyEName = e.ExtraParams["ReplyEName"]; string CheckedEName = e.ExtraParams["CheckedEName"]; string WriteEmail = string.Empty; string ReplyEmail = string.Empty; string CheckedEmail = string.Empty; Model_BorgUserInfo oModel_BorgUserInfo = new Model_BorgUserInfo(); Borg_User oBorg_User = new Borg_User(); oModel_BorgUserInfo = oBorg_User.GetUserInfoByLogonId(WriteEname); if (oModel_BorgUserInfo._EXISTS) { WriteEmail = oModel_BorgUserInfo._EMAIL; } else { Alert("英文名" + WriteEname + "不存在,请确认!"); return; } oModel_BorgUserInfo = oBorg_User.GetUserInfoByLogonId(ReplyEName); if (oModel_BorgUserInfo._EXISTS) { ReplyEmail = oModel_BorgUserInfo._EMAIL; } else { Alert("英文名" + ReplyEName + "不存在,请确认!"); return; } oModel_BorgUserInfo = oBorg_User.GetUserInfoByLogonId(CheckedEName); if (oModel_BorgUserInfo._EXISTS) { CheckedEmail = oModel_BorgUserInfo._EMAIL; } else { Alert("英文名" + WriteEname + "不存在,请确认!"); return; } SqlDB sdb = new SqlDB(DataPara.GetDbConnectionString("NPI_REPORT")); ////數據庫DB更新操作 string sql = " update TB_NPI_APP_MEMBER SET WriteEname=@writeEname, WriteEmail=@WriteEmail," + " ReplyEName=@ReplyEname,ReplyEmai=@ReplyEmail,CheckedEName=@CheckEname,CheckedEmail=@CheckedEmail," + " UPDATE_USERID=@Update_Userid,UPDATE_TIME=@Update_time" + " WHERE DOC_NO=@DocNo AND ID=@ID"; ArrayList opc = new ArrayList(); opc.Clear(); opc.Add(DataPara.CreateDataParameter("@WriteEmail", DbType.String, WriteEmail)); opc.Add(DataPara.CreateDataParameter("@writeEname", DbType.String, WriteEname)); opc.Add(DataPara.CreateDataParameter("@DocNo", DbType.String, DOC_NO)); opc.Add(DataPara.CreateDataParameter("@ReplyEname", DbType.String, ReplyEName)); opc.Add(DataPara.CreateDataParameter("@ReplyEmail", DbType.String, ReplyEmail)); opc.Add(DataPara.CreateDataParameter("@CheckEname", DbType.String, CheckedEName)); opc.Add(DataPara.CreateDataParameter("@CheckedEmail", DbType.String, CheckedEmail)); opc.Add(DataPara.CreateDataParameter("@Update_Userid", DbType.String, lblLogonId.Text.Trim())); opc.Add(DataPara.CreateDataParameter("@Update_time", DbType.DateTime, DateTime.Now)); opc.Add(DataPara.CreateDataParameter("@ID", DbType.String, ID)); try { sdb.TransactionExecute(sql, opc); txtApprove.Text = string.Empty; btnQuery_click(null, null); } catch (Exception ex) { Alert(ex.Message); } }
private DataTable loadDT() { DataTable dt = new DataTable(); using (SqlDB db = new SqlDB(ConfigurationManager.ConnectionStrings["dbconn"].ToString())) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select * from hubInventoryOEMPolicy order by warehouseId,billingPolicy,transit"; cmd.CommandType = CommandType.Text; dt = db.getDataTableWithCmd(ref cmd); cmd.Dispose(); } return dt; }
private void set_nUser(string user_id, string domainName) { domain = "asia"; if (domainName != "") domain = domainName; LDAP ldap = new LDAP(@"LDAP://DC=" + domain + ",DC=ad,DC=flextronics,DC=com"); if (ldap.findUser(user_id, domain)) { _isLdapUser = true; _uid = ldap.uid; using (SqlDB sqldb = new SqlDB(__conn)) { SqlCommand cmd = new SqlCommand("[sp_GAM_UsersGet]"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@uid", _uid); cmd.Parameters.AddWithValue("@domain", domain); DataTable dt = sqldb.getDataTableWithCmd(ref cmd); cmd.Dispose(); if (dt.Rows.Count == 1) { DataRow row = dt.Rows[0]; isActive = (bool)row["isActive"]; isAdmin = (bool)row["isAdmin"]; if (row["uGroup"].ToString().ToLower() == "admin") isAdmin = true; managerId = (int)row["managerId"]; isSale = (bool)row["isSales"]; isReportViewer = (bool)row["isReportViewer"]; sysUserId = (int)row["sysUserId"]; _isDbUser = true; } } userName = ldap.name; emailAddress = ldap.email; jobTitle = ldap.title; fax = ldap.fax; tel = ldap.tel; department = ldap.department; } else { _uid = ""; msg = "User not found."; } ldap.Dispose(); }
//New malfunction constructor public new_malfunction() { InitializeComponent(); db = new SqlDB(); dateString = DateTime.Today.ToShortDateString().ToString(); }
public IEnumerable <Project> GetAll() { IList <Project> projectList = SqlDB.Query <Project>("Management.GetProjects", commandType: StoredProcedure).ToList(); return(projectList); }
public IEnumerable <Instructor> GetAll() { IList <Instructor> instructorList = SqlDB.Query <Instructor>("Management.GetInstructors", commandType: StoredProcedure).ToList(); return(instructorList); }
protected void btnConfirm_Click(object sender, DirectEventArgs e) { SpmMaster _Master = (SpmMaster)Master; if (string.IsNullOrEmpty(cmbAttachmentType.SelectedItem.Text)) { Alert("請先選擇上傳的文件類型!"); return; } else { string MFILE_PATH = string.Empty; string MFILE_NAME = string.Empty; SqlDB sdb = new SqlDB(DataPara.GetDbConnectionString("NPI_REPORT")); string File_Type = cmbAttachmentType.SelectedItem.Text.ToString().Trim(); if (string.IsNullOrEmpty(File_Type)) { Alert("請選擇附件類別"); return; } if (!fileMeeting.HasFile) { Alert("請選擇上傳附件!"); return; } int indexMeeting = fileMeeting.FileName.LastIndexOf('.'); string extMeeting = fileMeeting.FileName.Substring(indexMeeting + 1); string fileName = fileMeeting.FileName.Substring(fileMeeting.FileName.LastIndexOf("\\") + 1); if (extMeeting != "pdf") { Alert("附件類型只能為pdf類型!"); return; } //創建保存的目錄 根據主單號與子單號 string type = cmbAttachmentType.SelectedItem.Text.Trim(); string CaseID = _Master.IFormURLPara.CaseId.ToString(); string docNoPath = Server.MapPath("~/Attachment/" + CaseID + "/" + type); string filepath = (docNoPath + "/" + MFILE_NAME); bool IsDocNoExist = Directory.Exists(docNoPath); bool IsSubDocNoExist = Directory.Exists(docNoPath); if (!IsSubDocNoExist) { Directory.CreateDirectory(docNoPath); } #region 文件上傳操作 try { MFILE_PATH = "Attachment/" + CaseID + "/" + type + "/" + fileName; MFILE_NAME = fileName; fileMeeting.PostedFile.SaveAs(docNoPath + "/" + fileName); opc.Clear(); opc.Add(DataPara.CreateDataParameter("@DOC_NO", DbType.String, txtFormNo.Text, ParameterDirection.Input, 30)); opc.Add(DataPara.CreateDataParameter("@CASE_ID", DbType.Int32, _Master.IFormURLPara.CaseId, ParameterDirection.Input, 8)); opc.Add(DataPara.CreateDataParameter("@MFILE_PATH", DbType.String, MFILE_PATH, ParameterDirection.Input, 255)); opc.Add(DataPara.CreateDataParameter("@MFILE_TYPE", DbType.String, File_Type, ParameterDirection.Input, 30)); opc.Add(DataPara.CreateDataParameter("@MFILE_NAME", DbType.String, MFILE_NAME, ParameterDirection.Input, 50)); opc.Add(DataPara.CreateDataParameter("@UPDATE_TIME", DbType.DateTime, DateTime.Now, ParameterDirection.Input, 8)); opc.Add(DataPara.CreateDataParameter("@UPDATE_USERID", DbType.String, lblLogonId.Text, ParameterDirection.Input, 20)); opc.Add(DataPara.CreateDataParameter("@Result", DbType.String, null, ParameterDirection.Output, 1000)); //SP執行結果返回固定格式 //1 OK; //2 NG;ERR MSG string tmp = sdb.ExecuteProcScalar("[P_Upload_NPI_Files]", opc, "@Result"); if (tmp.Length >= 3) { if (tmp.Substring(0, 2) == "NG") { Alert("文件上傳失敗!" + tmp.Substring(3, tmp.Length - 3)); return; } } else { DeleteExistFiles(docNoPath); Alert("文件上傳失敗!DB ERROR,Pls contact IT"); } } catch (Exception ex) { DeleteExistFiles(docNoPath); Alert("文件上傳失敗!DB ERROR:" + ex.Message); } #endregion BindAttachmentList(CaseID); } }
} // End Read public int Update() { Hashtable m_params = new Hashtable(); Hashtable w_params = new Hashtable(); w_params.Add("CLA_INDICADOR", this.CLA_INDICADOR); if (!SqlDB.IsNullOrEmpty(this.CLA_CONCEPTO)) { m_params.Add("CLA_CONCEPTO", this.CLA_CONCEPTO); } if (!SqlDB.IsNullOrEmpty(this.CLA_PADRE)) { m_params.Add("CLA_PADRE", this.CLA_PADRE); } if (!SqlDB.IsNullOrEmpty(this.NOM_INDICADOR)) { m_params.Add("NOM_INDICADOR", this.NOM_INDICADOR); } if (!SqlDB.IsNullOrEmpty(this.FORMULA_USR)) { m_params.Add("FORMULA_USR", this.FORMULA_USR); } if (!SqlDB.IsNullOrEmpty(this.FORMULA_BD)) { m_params.Add("FORMULA_BD", this.FORMULA_BD); } if (!SqlDB.IsNullOrEmpty(this.NOM_TABLA)) { m_params.Add("NOM_TABLA", this.NOM_TABLA); } if (!SqlDB.IsNullOrEmpty(this.LLAVES)) { m_params.Add("LLAVES", this.LLAVES); } if (!SqlDB.IsNullOrEmpty(this.TIPO_AGRUPACION)) { m_params.Add("TIPO_AGRUPACION", this.TIPO_AGRUPACION); } if (!SqlDB.IsNullOrEmpty(this.FORMATO)) { m_params.Add("FORMATO", this.FORMATO); } if (!SqlDB.IsNullOrEmpty(this.TIPO_INDICADOR)) { m_params.Add("TIPO_INDICADOR", this.TIPO_INDICADOR); } if (!SqlDB.IsNullOrEmpty(this.CLA_USUARIO)) { m_params.Add("CLA_USUARIO", this.CLA_USUARIO); } if (!SqlDB.IsNullOrEmpty(this.REEXPRESADOS)) { m_params.Add("REEXPRESADOS", this.REEXPRESADOS); } if (!SqlDB.IsNullOrEmpty(this.DESCRIPCION)) { m_params.Add("DESCRIPCION", this.DESCRIPCION); } if (!SqlDB.IsNullOrEmpty(this.FILTRO)) { m_params.Add("FILTRO", this.FILTRO); } if (!SqlDB.IsNullOrEmpty(this.PARETTO)) { m_params.Add("PARETTO", this.PARETTO); } if (!SqlDB.IsNullOrEmpty(this.TABLAS)) { m_params.Add("TABLAS", this.TABLAS); } if (!SqlDB.IsNullOrEmpty(this.DONDE)) { m_params.Add("DONDE", this.DONDE); } if (!SqlDB.IsNullOrEmpty(this.DIMENSIONES)) { m_params.Add("DIMENSIONES", this.DIMENSIONES); } if (!SqlDB.IsNullOrEmpty(this.NO_EJECUTIVO)) { m_params.Add("NO_EJECUTIVO", this.NO_EJECUTIVO); } if (!SqlDB.IsNullOrEmpty(this.ES_ATRIBUTO)) { m_params.Add("ES_ATRIBUTO", this.ES_ATRIBUTO); } if (!SqlDB.IsNullOrEmpty(this.NIVEL_JERARQUIA)) { m_params.Add("NIVEL_JERARQUIA", this.NIVEL_JERARQUIA); } if (!SqlDB.IsNullOrEmpty(this.ES_DIVISOR)) { m_params.Add("ES_DIVISOR", this.ES_DIVISOR); } if (!SqlDB.IsNullOrEmpty(this.DIM_DEPEND)) { m_params.Add("DIM_DEPEND", this.DIM_DEPEND); } if (!SqlDB.IsNullOrEmpty(this.DIM_ALARM)) { m_params.Add("DIM_ALARM", this.DIM_ALARM); } if (!SqlDB.IsNullOrEmpty(this.ACTUAL)) { m_params.Add("ACTUAL", this.ACTUAL); } if (!SqlDB.IsNullOrEmpty(this.CLA_PERIODO)) { m_params.Add("CLA_PERIODO", this.CLA_PERIODO); } if (!SqlDB.IsNullOrEmpty(this.DECREMENTAL)) { m_params.Add("DECREMENTAL", this.DECREMENTAL); } if (!SqlDB.IsNullOrEmpty(this.ID_CPTO_ATRIB)) { m_params.Add("ID_CPTO_ATRIB", this.ID_CPTO_ATRIB); } if (!SqlDB.IsNullOrEmpty(this.CLA_OWNER)) { m_params.Add("CLA_OWNER", this.CLA_OWNER); } if (!SqlDB.IsNullOrEmpty(this.FILTER_SQL)) { m_params.Add("FILTER_SQL", this.FILTER_SQL); } if (!SqlDB.IsNullOrEmpty(this.NIVELES)) { m_params.Add("NIVELES", this.NIVELES); } if (!SqlDB.IsNullOrEmpty(this.KPIVALUE)) { m_params.Add("KPIVALUE", this.KPIVALUE); } if (!SqlDB.IsNullOrEmpty(this.ONLY_LAST_PERIOD)) { m_params.Add("ONLY_LAST_PERIOD", this.ONLY_LAST_PERIOD); } if (!SqlDB.IsNullOrEmpty(this.NOTNUMERIC)) { m_params.Add("NOTNUMERIC", this.NOTNUMERIC); } if (!SqlDB.IsNullOrEmpty(this.NONEMPTYBEHAVIOR)) { m_params.Add("NONEMPTYBEHAVIOR", this.NONEMPTYBEHAVIOR); } if (!SqlDB.IsNullOrEmpty(this.IN_AGGREGATION)) { m_params.Add("IN_AGGREGATION", this.IN_AGGREGATION); } return(SqlDB.Update("SI_INDICADOR", m_params, w_params)); } // End Update
public void pathtohis(string blh, string debug) { debug = f.ReadString("savetohis", "debug", ""); string odbcsql = f.ReadString("savetohis", "odbcsql", "Data Source=.;Initial Catalog=pathnet;User Id=pathnet;Password=4s3c2a1p; "); string err_msg = ""; dbbase.odbcdb aa = new odbcdb("DSN=pathnet;UID=pathnet;PWD=4s3c2a1p", "", ""); DataTable bljc = new DataTable(); bljc = aa.GetDataTable("select * from T_jcxx where F_blh='" + blh + "'", "bljc"); if (bljc == null) { MessageBox.Show("病理数据库设置有问题!"); log.WriteMyLog("病理数据库设置有问题!"); return; } if (bljc.Rows.Count < 1) { MessageBox.Show("病理号有错误!"); log.WriteMyLog("病理号有错误!"); return; } if (bljc.Rows[0]["F_SQXH"].ToString().Trim() == "") { log.WriteMyLog("申请序号为空不处理!"); ZgqClass.BGHJ(blh, "HIS接口", "审核", "申请序号为空不处理", "ZGQJK", "HIS接口"); return; } if (bljc.Rows[0]["F_BGZT"].ToString().Trim() == "已登记" || bljc.Rows[0]["F_BGZT"].ToString().Trim() == "已取材" || bljc.Rows[0]["F_BGZT"].ToString().Trim() == "已写报告") { if (bljc.Rows[0]["F_HXBJ"].ToString().Trim() == "1") { return; } //if (bljc.Rows[0]["F_HXBJ"].ToString().Trim() != "2") // return; SqlDB db = new SqlDB(); try { SqlParameter[] oledbPt = new SqlParameter[2]; for (int j = 0; j < oledbPt.Length; j++) { oledbPt[j] = new SqlParameter(); } oledbPt[0].ParameterName = "OrderID"; oledbPt[0].SqlDbType = SqlDbType.VarChar; oledbPt[0].Direction = ParameterDirection.Input; oledbPt[0].Size = 32; oledbPt[0].Value = bljc.Rows[0]["F_SQXH"].ToString().Trim(); oledbPt[1].ParameterName = "OrderStatus";// oledbPt[1].SqlDbType = SqlDbType.Int; oledbPt[1].Direction = ParameterDirection.Input; oledbPt[1].Value = 1; int x = db.ExecuteNonQuery(odbcsql, "SP_SyncOrderStatusToHIS", ref oledbPt, CommandType.StoredProcedure, ref err_msg); if (x < 0) { log.WriteMyLog("执行回写标记异常:" + err_msg); ZgqClass.BGHJ(blh, "HIS接口", "保存", "执行回写标记异常:" + err_msg, "ZGQJK", "HIS接口"); } else { ZgqClass.BGHJ(blh, "HIS接口", "保存", "执行回写标记正常", "ZGQJK", "HIS接口"); aa.ExecuteSQL("update T_JCXX set F_HXBJ='1' where F_BLH='" + bljc.Rows[0]["F_BLH"].ToString().Trim() + "'"); } return; } catch (Exception e) { MessageBox.Show(e.Message); return; } } else if (bljc.Rows[0]["F_BGZT"].ToString().Trim() == "已审核") { SqlDB db = new SqlDB(); try { SqlParameter[] oledbPt = new SqlParameter[2]; for (int j = 0; j < oledbPt.Length; j++) { oledbPt[j] = new SqlParameter(); } oledbPt[0].ParameterName = "OrderID"; oledbPt[0].SqlDbType = SqlDbType.VarChar; oledbPt[0].Direction = ParameterDirection.Input; oledbPt[0].Size = 32; oledbPt[0].Value = bljc.Rows[0]["F_SQXH"].ToString().Trim(); oledbPt[1].ParameterName = "OrderStatus"; // oledbPt[1].SqlDbType = SqlDbType.Int; oledbPt[1].Direction = ParameterDirection.Input; oledbPt[1].Value = 2; int x = db.ExecuteNonQuery(odbcsql, "SP_SyncOrderStatusToHIS", ref oledbPt, CommandType.StoredProcedure, ref err_msg); if (x < 0) { log.WriteMyLog("执行回写审核标记异常:" + err_msg); ZgqClass.BGHJ(blh, "HIS接口", "审核", "执行回写审核标记异常:" + err_msg, "ZGQJK", "HIS接口"); } else { ZgqClass.BGHJ(blh, "HIS接口", "审核", "执行回写审核标记正常", "ZGQJK", "HIS接口"); } } catch (Exception e) { log.WriteMyLog(e.Message); return; } //回写报告 try { SqlParameter[] oledbPt = new SqlParameter[6]; for (int j = 0; j < oledbPt.Length; j++) { oledbPt[j] = new SqlParameter(); } oledbPt[0].ParameterName = "OrderID"; oledbPt[0].SqlDbType = SqlDbType.VarChar; oledbPt[0].Direction = ParameterDirection.Input; oledbPt[0].Size = 32; oledbPt[0].Value = bljc.Rows[0]["F_SQXH"].ToString().Trim(); oledbPt[1].ParameterName = "ReportGuid"; oledbPt[1].SqlDbType = SqlDbType.VarChar; oledbPt[1].Direction = ParameterDirection.Input; oledbPt[1].Size = 128; oledbPt[1].Value = bljc.Rows[0]["F_BLH"].ToString().Trim(); oledbPt[2].ParameterName = "WYSText"; oledbPt[2].SqlDbType = SqlDbType.VarChar; oledbPt[2].Direction = ParameterDirection.Input; oledbPt[2].Size = 4000; oledbPt[2].Value = bljc.Rows[0]["F_RYSJ"].ToString().Trim() + "\r\n" + bljc.Rows[0]["F_JXSJ"].ToString().Trim(); oledbPt[3].ParameterName = "WYGText"; oledbPt[3].SqlDbType = SqlDbType.VarChar; oledbPt[3].Direction = ParameterDirection.Input; oledbPt[3].Size = 4000; oledbPt[3].Value = bljc.Rows[0]["F_blzd"].ToString().Trim() + "\r\n" + bljc.Rows[0]["F_tsjc"].ToString().Trim(); oledbPt[4].ParameterName = "PatientID"; oledbPt[4].SqlDbType = SqlDbType.VarChar; oledbPt[4].Direction = ParameterDirection.Input; oledbPt[4].Size = 50; oledbPt[4].Value = bljc.Rows[0]["F_BRBH"].ToString().Trim(); oledbPt[5].ParameterName = "CheckedDate"; oledbPt[5].SqlDbType = SqlDbType.VarChar; oledbPt[5].Direction = ParameterDirection.Input; oledbPt[5].Size = 50; oledbPt[5].Value = bljc.Rows[0]["F_SPARE5"].ToString().Trim(); int x = db.ExecuteNonQuery(odbcsql, "SP_SyncApprovedReportToHIS", ref oledbPt, CommandType.StoredProcedure, ref err_msg); if (x < 0) { log.WriteMyLog("执行回写审核报告异常:" + err_msg); ZgqClass.BGHJ(blh, "HIS接口", "审核", "执行回写审核报告异常:" + err_msg, "ZGQJK", "HIS接口"); } else { ZgqClass.BGHJ(blh, "HIS接口", "审核", "执行回写审核报告正常", "ZGQJK", "HIS接口"); aa.ExecuteSQL("update T_JCXX set F_HXBJ='2' where F_BLH='" + bljc.Rows[0]["F_BLH"].ToString().Trim() + "'"); } return; } catch (Exception e) { log.WriteMyLog(e.Message); return; } } }
public static DataTable getDbUser(string uid, string domain) { DataTable dt = new DataTable(); using (SqlDB sqldb = new SqlDB(__conn)) { SqlCommand cmd = new SqlCommand("sp_GAM_UsersGet"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@uid", uid); cmd.Parameters.AddWithValue("@domain", domain); dt = sqldb.getDataTableWithCmd(ref cmd); cmd.Dispose(); } return dt; }
private void updateOEM(string warehouseId, int billing, int transit) { using (SqlDB db = new SqlDB(ConfigurationManager.ConnectionStrings["dbconn"].ToString())) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "update hubInventoryOEMPolicy set billingpolicy=@billing, transit=@transit where warehouseId=@warehouseId"; cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@billing", billing); cmd.Parameters.AddWithValue("@transit", transit); cmd.Parameters.AddWithValue("@warehouseId", warehouseId); db.execSqlWithCmd(ref cmd); cmd.Dispose(); } }
private DataTable loadDT() { DataTable dt = new DataTable(); using (SqlDB db = new SqlDB(ConfigurationManager.ConnectionStrings["dbconn"].ToString())) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select * from hubInventoryCEMLocation order by customer_code"; cmd.CommandType = CommandType.Text; dt = db.getDataTableWithCmd(ref cmd); cmd.Dispose(); } return dt; }
public void Command(Client client, string[] cmd) { if (client.AccessLevel <= 0) { return; } if (cmd.Length == 0) { return; } Character Tamer = client.Tamer; GameMap ActiveMap = null; if (Tamer != null && Tamer.Partner != null) { ActiveMap = Maps[client.Tamer.Location.Map]; } switch (cmd[0]) { case "inc": { client.Send(new ChatNormal(Tamer.DigimonHandle, string.Format("Incubator: Level {1} {0}", Tamer.Incubator, Tamer.IncubatorLevel))); break; } case "item": { int fullId = int.Parse(cmd[1]); Item e = new Item(0); e.ID = fullId; if (e.ItemData == null) { client.Send(new ChatNormal(Tamer.DigimonHandle, string.Format("An item with the id {0} was not found.", fullId))); return; } e.Unknown = (short)e.Max; e.Amount = 1; if (cmd.Length == 3) { int count = 1; int.TryParse(cmd[2], out count); count = count > e.Max ? e.Max : count; count = count < 0 ? 1 : count; e.Amount = count; } if (cmd.Length == 9) { short[] shorts = new short[6]; for (int i = 3; i < cmd.Length; i++) { shorts[i - 3] = short.Parse(cmd[i]); } e.Unknown1 = shorts[0]; e.Unknown2 = shorts[1]; e.Unknown3 = shorts[2]; e.Unknown4 = shorts[3]; e.Unknown5 = shorts[4]; e.Unknown6 = shorts[5]; } e.time_t = 0xFFFFFFFF; int slot = Tamer.Inventory.Add(e); if (slot != -1) { client.Send(new CashWHItem(slot, e, ((e.Modifier ^ 1) / 2), e.Max)); } break; } case "sk1": { Client Target = ActiveMap.Find(cmd[1]); if (Target == null) { return; } short skill = 0; short.TryParse(cmd[2], out skill); client.Send(new UseSkill(Tamer.DigimonHandle, Target.Tamer.DigimonHandle, skill, 1, 9999)); break; } case "hatch": { int fullId = 31001; int.TryParse(cmd[1], out fullId); Send(new BroadcastHatch(Tamer.Name, "I am a banana", fullId, 65000, 5)); break; } case "sk2": { short skill = 0; short.TryParse(cmd[1], out skill); client.Send(new UseSkill(Tamer.DigimonHandle, Tamer.TamerHandle, skill, 1, 9999)); break; } case "list": { client.Send(new BaseChat(ChatType.Normal, Tamer.DigimonHandle, "Players on this map:")); foreach (Client other in ActiveMap.Tamers) { client.Send(new BaseChat(ChatType.Normal, Tamer.DigimonHandle, string.Format("{0} - {1}", other.Tamer, other.Tamer.Partner))); } break; } case "force": { foreach (Client other in ActiveMap.Tamers) { ActiveMap.Spawn(other); } break; } case "spawn": { uint value = 0; uint.TryParse(cmd[1], out value); MDBDigimon Mob = MonsterDB.GetDigimon(value); if (Mob == null) { client.Send(new BaseChat(ChatType.Normal, Tamer.DigimonHandle, string.Format("Mob {0} was not found.", value))); } uint id = GetModel((uint)(64 + (Mob.Models[0] * 128)) << 8); GameMap cMap = Maps[Tamer.Location.Map]; cMap.Send(new SpawnObject(id, Tamer.Location.PosX, Tamer.Location.PosY)); break; } case "rld": case "reload": { ActiveMap.Leave(client); client.Send(new MapChange(Opt.GameServer.IP.ToString(), Opt.GameServer.Port, Tamer.Location.Map, Tamer.Location.PosX, Tamer.Location.PosY, Tamer.Location.MapName)); break; } case "save": { client.Send(new BaseChat(ChatType.Shout, "ADMIN", "Saving...")); SqlDB.SaveTamer(client); break; }; case "ann": { Send(new BaseChat().Megaphone(Tamer.Name, string.Join(" ", cmd, 1, cmd.Length - 1), 402417)); break; }; case "map": { int mapId = int.Parse(cmd[1]); int X = int.Parse(cmd[2]); int Y = int.Parse(cmd[3]); MapData Map = MapDB.GetMap(mapId); Tamer.Location = new Position(mapId, X, Y); SqlDB.SaveTamerPosition(client); client.Send(new MapChange(Opt.GameServer.IP.ToString(), Opt.GameServer.Port, mapId, X, Y, Map.Name)); break; }; case "tele": { Position p = null; switch (cmd[1].ToLower()) { case "dats": default: p = new Position(1, 29877, 22184); break; } if (p != null) { SqlDB.SaveTamerPosition(client); ActiveMap.Leave(client); Tamer.Location = p; client.Send(new MapChange(Opt.GameServer.IP.ToString(), Opt.GameServer.Port, p.Map, p.PosX, p.PosY, p.MapName)); } break; } case "where": case "pos": case "loc": { client.Send(new ChatNormal(Tamer.DigimonHandle, string.Format("You are at {0}", Tamer.Location))); break; } case "merc": { int value = 0; if (!int.TryParse(cmd[1], out value)) { return; } DigimonData dData = DigimonDB.GetDigimon(value); if (dData == null) { client.Send(new ChatNormal(Tamer.DigimonHandle, string.Format("Mercenary id {0} was not found.", value))); } else { client.Send(new ChatNormal(Tamer.DigimonHandle, string.Format("Mercenary {1} Found: {0}", dData.DisplayName, value))); } break; } case "mk": { if (cmd.Length < 3) { return; } int value = 0; if (!int.TryParse(cmd[2], out value)) { return; } DigimonData dData = DigimonDB.GetDigimon(value); if (dData == null) { return; } uint digiId = SqlDB.CreateMercenary(client.Tamer.CharacterId, cmd[1], value, 5, 14000, 100); if (digiId == 0) { client.Send(new ChatNormal(Tamer.DigimonHandle, "Failed to create mercenary.")); return; } else { for (int i = 0; i < Tamer.ArchivedDigimon.Length; i++) { if (Tamer.ArchivedDigimon[i] != 0) { continue; } Tamer.ArchivedDigimon[i] = (uint)digiId; break; } client.Send(new ChatNormal(Tamer.DigimonHandle, "Mercenary added to Digimon Archive.")); } break; } case "self.setav": case "tamer.setav": { int value = 0; if (!int.TryParse(cmd[2], out value)) { return; } switch (cmd[1].ToLower()) { case "level": case "lv": Tamer.Level = value; ActiveMap.Send(new UpdateLevel(Tamer.TamerHandle, (byte)value)); break; case "at": Tamer.AT = value; break; case "de": Tamer.DE = value; break; case "hp": Tamer.MaxHP = value; Tamer.HP = value; break; case "ds": Tamer.MaxDS = value; Tamer.DS = value; break; case "fatigue": Tamer.Fatigue = value; break; case "ms": Tamer.MS = (short)value; break; case "tamer": Tamer.Model = (CharacterModel)value; break; case "archive": Tamer.ArchiveSize = value; break; case "inv": Tamer.InventorySize = value; break; case "storage": Tamer.StorageSize = value; break; case "size": ActiveMap.Send(new ChangeSize(Tamer.TamerHandle, value, 0)); break; case "bits": Tamer.Money = value; //client.Send(new UpdateMoney()); break; } client.Send(new UpdateStats(Tamer, Tamer.Partner)); break; } case "mon.setav": case "digimon.setav": { if (cmd[1].ToLower() == "min") { Tamer.Partner.Stats = new DigimonStats(); Tamer.Partner.Level = 1; Tamer.Partner.EXP = 0; client.Send(new UpdateStats(Tamer, Tamer.Partner)); return; } else if (cmd[1].ToLower() == "max") { Tamer.Partner.Stats.Max(); Tamer.Level = 99; client.Send(new UpdateStats(Tamer, Tamer.Partner)); return; } else if (cmd[1].ToLower() == "default") { DigimonData dData = DigimonDB.GetDigimon(Tamer.Partner.CurrentForm); if (dData != null) { Tamer.Partner.Stats = dData.Default(Tamer, Tamer.Partner.Stats.Intimacy, Tamer.Partner.Size); client.Send(new UpdateStats(Tamer, Tamer.Partner)); } } int value = 0; if (!int.TryParse(cmd[2], out value)) { return; } switch (cmd[1].ToLower()) { case "lv": case "level": Tamer.Partner.Level = value; ActiveMap.Send(new UpdateLevel(Tamer.DigimonHandle, (byte)value)); break; case "exp": Tamer.Partner.EXP = value; break; case "hp": Tamer.Partner.Stats.MaxHP = (short)value; Tamer.Partner.Stats.HP = (short)value; break; case "ds": Tamer.Partner.Stats.MaxDS = (short)value; Tamer.Partner.Stats.DS = (short)value; break; case "at": Tamer.Partner.Stats.AT = (short)value; break; case "de": Tamer.Partner.Stats.DE = (short)value; break; case "ev": Tamer.Partner.Stats.EV = (short)value; break; case "ht": Tamer.Partner.Stats.HT = (short)value; break; case "cr": Tamer.Partner.Stats.CR = (short)value; break; case "as": Tamer.Partner.Stats.AS = (short)value; break; case "ms": Tamer.Partner.Stats.MS = (short)value; break; case "int": case "sync": case "intimacy": Tamer.Partner.Stats.Intimacy = (short)value; break; case "type": Tamer.Partner.Species = value; Tamer.Partner.CurrentForm = value; break; case "name": Tamer.Partner.Name = cmd[2]; break; case "size": Tamer.Partner.Size = (short)value; ActiveMap.Send(new ChangeSize(Tamer.DigimonHandle, value, 0)); break; case "scale": Tamer.Partner.Scale = (byte)value; break; } client.Send(new UpdateStats(Tamer, Tamer.Partner)); break; } } }
private void updateCUS(string customer_code, string location) { using (SqlDB db = new SqlDB(ConfigurationManager.ConnectionStrings["dbconn"].ToString())) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "update hubInventoryCEMLocation set location=@location where customer_code=@customer_code"; cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@location", location); cmd.Parameters.AddWithValue("@customer_code", customer_code); db.execSqlWithCmd(ref cmd); cmd.Dispose(); } }