public string Get_jcxbh_by_jcxmc(string jcxmc) { string sql = "select * from JCXXXB where JCXMC=@jcxmc"; SqlParameter[] spr = { new SqlParameter("@jcxmc", jcxmc) }; try { SYS.Model.JCXXXB sb = new SYS.Model.JCXXXB(); DataTable dt = new DataTable(); dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr); if (dt.Rows.Count > 0) { sb.JCXBH = dt.Rows[0]["JCXBH"].ToString(); } return(sb.JCXBH); } catch (Exception) { throw; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(SYS.Model.JCXXXB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update JCXXXB set"); //strSql.Append("JCXBH=@JCXBH,"); strSql.Append(" GYJSJIP=@GYJSJIP,"); strSql.Append("JCXMC=@JCXMC,"); strSql.Append("JCFFLX=@JCFFLX,"); strSql.Append("DPCGJBH=@DPCGJBH,"); strSql.Append("FQFXYBH=@FQFXYBH,"); strSql.Append("BTGYDJBH=@BTGYDJBH,"); strSql.Append("WYZSBBH=@WYZSBBH,"); strSql.Append("QTLLFXYBH=@QTLLFXYBH,"); strSql.Append("LEDDPBH=@LEDDPBH,"); strSql.Append("LEDPZ=@LEDPZ,"); strSql.Append("XH=@XH,"); strSql.Append("RZBH=@RZBH,"); strSql.Append("ZZCS=@ZZCS,"); strSql.Append("LLJBH=@LLJBH,"); strSql.Append("DPCGJPZ=@DPCGJPZ,"); strSql.Append("FQFXYPZ=@FQFXYPZ,"); strSql.Append("BTGYDJPZ=@BTGYDJPZ,"); strSql.Append("LLJPZ=@LLJPZ,"); strSql.Append("PCBH=@PCBH,"); strSql.Append("HJZBH=@HJZBH "); //strSql.Append("LJSYS=@LJSYS");//更新时不改变累计试验数 strSql.Append(" where JCXBH=@JCXBH"); //strSql.Append("values (@JCXBH,@GYJSJIP,@JCXMC,@JCFFLX,@DPCGJBH,@FQFXYBH,@BTGYDJBH,@WYZSBBH,@QTLLFXYBH,@LEDDPBH,@XH,@RZBH,@ZZCS,@LLJBH,@LJSYS)"); SqlParameter[] parameters = { //new SqlParameter("@JCXBH", SqlDbType.VarChar,32), new SqlParameter("@GYJSJIP", SqlDbType.VarChar, 16), new SqlParameter("@JCXMC", SqlDbType.VarChar, 64), new SqlParameter("@JCFFLX", SqlDbType.Int, 4), new SqlParameter("@DPCGJBH", SqlDbType.Int, 4), new SqlParameter("@FQFXYBH", SqlDbType.Int, 4), new SqlParameter("@BTGYDJBH", SqlDbType.Int, 4), new SqlParameter("@WYZSBBH", SqlDbType.Int, 4), new SqlParameter("@QTLLFXYBH", SqlDbType.Int, 4), new SqlParameter("@LEDDPBH", SqlDbType.Int, 4), new SqlParameter("@LEDPZ", SqlDbType.VarChar, 32), new SqlParameter("@XH", SqlDbType.VarChar, 32), new SqlParameter("@RZBH", SqlDbType.VarChar, 64), new SqlParameter("@ZZCS", SqlDbType.VarChar, 64), new SqlParameter("@LLJBH", SqlDbType.Int, 4), new SqlParameter("@DPCGJPZ", SqlDbType.VarChar, 64), new SqlParameter("@FQFXYPZ", SqlDbType.VarChar, 64), new SqlParameter("@BTGYDJPZ", SqlDbType.VarChar, 64), new SqlParameter("@LLJPZ", SqlDbType.VarChar, 64), new SqlParameter("@PCBH", SqlDbType.Int, 4), new SqlParameter("@HJZBH", SqlDbType.Int, 4), //new SqlParameter("@LJSYS", SqlDbType.Int,4), new SqlParameter("@JCXBH", SqlDbType.VarChar, 32) }; //parameters[0].Value = model.JCXBH; parameters[0].Value = model.GYJSJIP; parameters[1].Value = model.JCXMC; parameters[2].Value = model.JCFFLX; parameters[3].Value = model.DPCGJBH; parameters[4].Value = model.FQFXYBH; parameters[5].Value = model.BTGYDJBH; parameters[6].Value = model.WYZSBBH; parameters[7].Value = model.QTLLFXYBH; parameters[8].Value = model.LEDDPBH; parameters[9].Value = model.LEDPZ; parameters[10].Value = model.XH; parameters[11].Value = model.RZBH; parameters[12].Value = model.ZZCS; parameters[13].Value = model.LLJBH; parameters[14].Value = model.DPCGJPZ; parameters[15].Value = model.FQFXYPZ; parameters[16].Value = model.BTGYDJPZ; parameters[17].Value = model.LLJPZ; parameters[18].Value = model.PCBH; parameters[19].Value = model.HJZBH; //parameters[14].Value = model.LJSYS; parameters[20].Value = model.JCXBH; try { int rows = DBHelperSQL.Execute(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } } catch (Exception) { throw; } }
public bool AddLine(SYS.Model.JCXXXB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into JCXXXB ("); strSql.Append("JCXBH,"); //=@PZLX,"); strSql.Append("GYJSJIP,"); //=@JCCLPH,"); strSql.Append("JCXMC,"); //=@CLXHBH,"); strSql.Append("JCFFLX,"); //=@JCCS,"); strSql.Append("DPCGJBH,"); //=@CCRQ,"); strSql.Append("FQFXYBH,"); //=@DJRQ,"); strSql.Append("BTGYDJBH,"); //=@FDJH,"); strSql.Append("WYZSBBH,"); //=@CJH,"); strSql.Append("QTLLFXYBH,"); //=@CZ,"); strSql.Append("LEDDPBH,"); //=@CZDH,"); strSql.Append("LEDPZ,"); //=@CZDH,"); strSql.Append("XH,"); //=@CZDZ,"); strSql.Append("RZBH,"); //=@LCBDS,"); strSql.Append("ZZCS,"); //=@HBBZ,"); strSql.Append("LLJBH,"); //=@SYQK,"); strSql.Append("LJSYS)"); strSql.Append("values (@JCXBH,@GYJSJIP,@JCXMC,@JCFFLX,@DPCGJBH,@FQFXYBH,@BTGYDJBH,@WYZSBBH,@QTLLFXYBH,@LEDDPBH,@LEDPZ,@XH,@RZBH,@ZZCS,@LLJBH,@LJSYS)"); SqlParameter[] parameters = { new SqlParameter("@JCXBH", SqlDbType.VarChar, 32), new SqlParameter("@GYJSJIP", SqlDbType.VarChar, 16), new SqlParameter("@JCXMC", SqlDbType.VarChar, 64), new SqlParameter("@JCFFLX", SqlDbType.Int, 4), new SqlParameter("@DPCGJBH", SqlDbType.Int, 4), new SqlParameter("@FQFXYBH", SqlDbType.Int, 4), new SqlParameter("@BTGYDJBH", SqlDbType.Int, 4), new SqlParameter("@WYZSBBH", SqlDbType.Int, 4), new SqlParameter("@QTLLFXYBH", SqlDbType.Int, 4), new SqlParameter("@LEDDPBH", SqlDbType.Int, 4), new SqlParameter("@LEDPZ", SqlDbType.VarChar, 32), new SqlParameter("@XH", SqlDbType.VarChar, 32), new SqlParameter("@RZBH", SqlDbType.VarChar, 64), new SqlParameter("@ZZCS", SqlDbType.VarChar, 64), new SqlParameter("@LLJBH", SqlDbType.Int, 4), new SqlParameter("@LJSYS", SqlDbType.Int, 4) }; parameters[0].Value = model.JCXBH; parameters[1].Value = model.GYJSJIP; parameters[2].Value = model.JCXMC; parameters[3].Value = model.JCFFLX; parameters[4].Value = model.DPCGJBH; parameters[5].Value = model.FQFXYBH; parameters[6].Value = model.BTGYDJBH; parameters[7].Value = model.WYZSBBH; parameters[8].Value = model.QTLLFXYBH; parameters[9].Value = model.LEDDPBH; parameters[10].Value = model.LEDPZ; parameters[11].Value = model.XH; parameters[12].Value = model.RZBH; parameters[13].Value = model.ZZCS; parameters[14].Value = model.LLJBH; parameters[15].Value = model.LJSYS; try { if (Have_ThisLine(model.JCXBH, model.JCXMC, model.GYJSJIP)) { if (Update(model)) { return(true); } else { return(false); } } else { if (DBHelperSQL.Execute(strSql.ToString(), parameters) > 0) { return(true); } else { return(false); } } } catch (Exception) { throw; } }