/// <summary>
/// 获取分站名称
/// </summary>
/// <param name="ProviceID"></param>
/// <returns></returns>
public string GetFenZhanName(string ProviceID)
{
string FenZhanName = "";
string sql = "select FenZhanName from FenZhanInfo where ProvinceId=@ProvinceId";
SqlParameter[] Paras = new SqlParameter[] {
new SqlParameter("@ProvinceId", SqlDbType.Int, 4)
};
Paras[0].Value = ProviceID;
if (crm.ExecuteScalar(CommandType.Text, sql, Paras) == null)
{
FenZhanName = " ";
}
else
{
FenZhanName = crm.ExecuteScalar(CommandType.Text, sql, Paras).ToString();
}
return(FenZhanName);
}