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