//获取跟踪记录列表
//获取商机列表
public static List<GenZongJL> getGenZongJL(string shangjixh, int pageindex, string orderby)
{
List<GenZongJL> rtn = new List<GenZongJL>();
using (OracleConnection conn = GetOraConnection())
{
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from v_sjgl_e_genzongjl a where SHANGJIXH = '" + shangjixh + "' order by baifangrq desc "; //"0283"
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
int i = 0;
while (dr.Read())
{
GenZongJL item = new GenZongJL();
item.BaiFangRQ = dr["BaiFangRQ"].ToString().Substring(0, 10);
item.ShiJianDuan = dr["ShiJianDuan"].ToString();
item.BaiFangDX = dr["BaiFangDX"].ToString();
item.GenZhongFS = dr["GenZhongFS"].ToString();
item.GenZongFKQK = dr["GenZongFKQK"].ToString();
item.XieTongRYMC = dr["XieTongRYMC"].ToString();
i++;
rtn.Add(item);
for (int k = 0; k < i; k++)
{
rtn[k].CiShu = (i - k).ToString();
}
}
}
return rtn;
}
public static string AddGenZongJL(GenZongJL gzjl)
{
string rtn = string.Empty;
using (OracleConnection conn = GetOraConnection())
{
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "PKG_SJGL.PRC_AddShangJiGXJR";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("prm_ShangJiXH", OracleDbType.Int32).Value = int.Parse(gzjl.ShangJiXH);
cmd.Parameters.Add("prm_GenZongFS", OracleDbType.Varchar2, 10).Value = gzjl.GenZhongFS ;
cmd.Parameters.Add("prm_BaiFangRQ", OracleDbType.Date ).Value = Convert.ToDateTime(gzjl.BaiFangRQ).Date ;
cmd.Parameters.Add("prm_BaiFangDX", OracleDbType.Varchar2, 10).Value = gzjl.BaiFangDX;
cmd.Parameters.Add("prm_GenZongFK", OracleDbType.Varchar2, 10).Value = gzjl.GenZongFKQK;
cmd.Parameters.Add("prm_XieTongRYID", OracleDbType.Varchar2, 10).Value = gzjl.XieTongRYID ;
cmd.Parameters.Add("prm_XieTongRYMC", OracleDbType.Varchar2, 10).Value = gzjl.XieTongRYMC;
cmd.Parameters.Add("prm_XieTongRYBMID", OracleDbType.Varchar2, 10).Value = gzjl.XieTongRYBMID;
cmd.Parameters.Add("prm_XieTongRYBMMC", OracleDbType.Varchar2, 10).Value = gzjl.XieTongRYBMMC;
cmd.Parameters.Add("prm_ZhiGongID", OracleDbType.Varchar2, 500).Value = gzjl.ChuangJianRID;
try
{
int i = cmd.ExecuteNonQuery();
rtn = i.ToString();
}
catch (Exception ex)
{
rtn = ex.Message;
}
}
return rtn;
}