public DataTable M_Site_Select(M_Site_Entity mse) { string sp = "M_Site_Select"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@AdminNO", new ValuePair { value1 = SqlDbType.Int, value2 = mse.AdminNO } }, { "@APIKey", new ValuePair { value1 = SqlDbType.TinyInt, value2 = mse.APIKey } } }; return(SelectData(dic, sp)); }
public bool M_Site_Select(M_Site_Entity mse) { DataTable dt = mmdl.M_Site_Select(mse); if (dt.Rows.Count > 0) { mse.ItemSKUCD = dt.Rows[0]["ItemSKUCD"].ToString(); mse.APIKey = dt.Rows[0]["APIKey"].ToString(); //mse.ItemSKUFLG = dt.Rows[0]["ItemSKUFLG"].ToString(); mse.SiteURL = dt.Rows[0]["SiteURL"].ToString(); mse.InsertOperator = dt.Rows[0]["InsertOperator"].ToString(); mse.InsertDateTime = dt.Rows[0]["InsertDateTime"].ToString(); mse.UpdateOperator = dt.Rows[0]["UpdateOperator"].ToString(); mse.UpdateDateTime = dt.Rows[0]["UpdateDateTime"].ToString(); return(true); } else { return(false); } }