public override string ToString() { string strsql = "select '['+ZhuangKuangCode+']'+ZhuangKuangName as showName from ZiChan_ShiYongZhuangKuang where ZhuangKuangCode='" + this.ZhuangKuangCode + "'"; object objRel = server.ExecuteScalar(strsql); return(objRel == null ? "" : objRel.ToString()); }
/// <summary> /// 验证model的合法性 /// </summary> /// <returns></returns> private bool AuditModel(T_RebatesStandard model, out string msg) { msg = ""; bool flg = true; if (model.ControlItemCode == "Qcfp") { flg = true; } else { string strsql = @"select count(*) from dbo.T_RebatesStandard where (('" + model.EffectiveDateFrm + "'>=EffectiveDateFrm and '" + model.EffectiveDateFrm + "'<=EffectiveDateTo) or ('" + model.EffectiveDateTo + "'<= EffectiveDateTo and '" + model.EffectiveDateTo + "'>=EffectiveDateFrm ) )and TruckTypeCode='" + model.TruckTypeCode + "' and DeptCode='" + model.DeptCode + "' and SaleFeeTypeCode='" + model.SaleFeeTypeCode + "' and ControlItemCode='" + model.ControlItemCode + "' and ((" + model.SaleCountFrm + ">=SaleCountFrm and " + model.SaleCountFrm + "<=SaleCountTo )or (" + model.SaleCountTo + "<=SaleCountTo and " + model.SaleCountTo + ">=SaleCountFrm))"; int ierx = int.Parse(server.ExecuteScalar(strsql).ToString()); if (ierx > 0) { msg = "该返利标准与数据库中已存在的标准存在交集,请重新设定!"; flg = false; } } return(flg); }
public override string ToString() { string strsql = "select '['+LeibieCode+']'+LeibieName as showName from ZiChan_Leibie where LeibieCode='" + this.LeibieCode + "'"; object objRel = server.ExecuteScalar(strsql); return(objRel == null ? "" : objRel.ToString()); }
/// <summary> /// 根据车架号获取车辆类型 /// </summary> /// <returns></returns> public string GetTruckTypeByCode(string StrCarcode) { string strsql = @"select top 1 cxh as cartypename from V_TruckMsg where cjh='" + StrCarcode + "'"; object obj = server.ExecuteScalar(strsql); return(obj == null ? "" : obj.ToString()); //DataSet ds = server.GetDataSet(strsql); //StringBuilder arry = new StringBuilder(); //foreach (DataRow dr in ds.Tables[0].Rows) //{ // arry.Append("'"); // arry.Append(Convert.ToString(dr["cartypename"])); // arry.Append("',"); //} //if (arry.Length > 1) //{ // string script = arry.ToString().Substring(0, arry.Length - 1); // return script; //} //else //{ // return ""; //} }