binbinloves的专栏

heidiSql-3.2 此工具无需注册码就能登录到MySql 里面去还能自动生成Sql语句自动保存为Txt文件..好处不多说了。取其所需啊！..

在C#平台下开发的！ VS 2005 +SQL server 2005

辛苦好久了终于弄出来了人人网的接口！

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 最经典的项目