MySql 可视化工具
heidiSql-3.2 此工具无需注册码就能登录到MySql 里面去还能自动生成Sql语句自动保存为Txt文件..好处不多说了。取其所需啊!..
heidiSql-3.2 此工具无需注册码就能登录到MySql 里面去还能自动生成Sql语句自动保存为Txt文件..好处不多说了。取其所需啊!..
AJAX 综合 快速能学懂AJAX AJAX 综合 快速能学懂AJAX AJAX 综合 快速能学懂AJAX AJAX 综合 快速能学懂AJAX AJAX 综合 快速能学懂AJAX AJAX 综合 快速能学懂AJAX AJAX 综合 快速能学懂AJAX AJAX 综合 快速能学懂AJAX AJAX 综合 快速能学懂AJAX AJAX 综合 快速能学懂AJAX AJAX 综合 快速能学懂AJAX
public UnDebt GetUnDebtByUDID(int UDID) { UnDebt unDebt = new UnDebt(); string sql = "select * from UnDebt where DID = "+UDID; SqlDataReader dr = SQLHelper.ExecuteReader(sql); if (dr.Read()) { unDebt.DID = UDID; unDebt.DName = dr["DName"].ToString(); unDebt.DSTime = (DateTime)dr.GetDateTime(2); try { unDebt.DETime = (DateTime)dr.GetDateTime(3); } catch (SqlNullValueException ex) { unDebt.DETime = DateTime.Now; } unDebt.User = userService.GetUserByUID(int.Parse(dr["UID"].ToString())); unDebt.FeeItem = feeItemService.GetFeeItemByFIID(int.Parse(dr["FIID"].ToString())); } dr.Close(); return unDebt; } /// <summary> /// 根据非公表明细账记录编号查找非公表明细账记录 /// </summary> /// <param name="UDNumber"></param> /// <returns></returns> public UnDebt GetUnDebtByUDName(string UDName) { UnDebt unDebt = null; string sql = "select * from UnDebt where DName = '" + UDName+"'"; SqlDataReader dr = SQLHelper.ExecuteReader(sql); if (dr.Read()) { unDebt = new UnDebt(); unDebt.DID = dr.GetInt32(0); unDebt.DName = dr["DName"].ToString(); unDebt.DSTime = (DateTime)dr.GetDateTime(2); try { unDebt.DETime = (DateTime)dr.GetDateTime(3); } catch (SqlNullValueException ex) { unDebt.DETime = DateTime.Now; } unDebt.User = userService.GetUserByUID(int.Parse(dr["UID"].ToString())); unDebt.FeeItem = feeItemService.GetFeeItemByFIID(int.Parse(dr["FIID"].ToString())); } dr.Close(); return unDebt; C/S 最经典的项目